Magento Homepage Keeps on redirecting to a 404 page

Question

I have been on this issue for almost a week now and have been research all over the net for answers but i could not find one.

Problem:

each time i access the homepage of my site, it results to a 404 error.

ex. http://www.domain.com ---> redirects to 404

http://www.domain.com/home ---> enters to the cms page that i set as my homepage

I have already run the magento cleanup scripts but it was not able to solve the problem.

ERROR MESSAGE:

Whoops, our bad...

The page you requested was not found, and we have a fine guess why.

        If you typed the URL directly, please make sure the spelling is correct.
        If you clicked on a link to get here, the link is outdated.

What can you do?
    Have no fear, help is near! There are many ways you can get back on track with Magento Store.

        Go back to the previous page.
        Use the search bar at the top of the page to search for your products.
        Follow these links to get you back on track!
        Store Home | My Account

Answer 1

I've got a similar error and would like to post my solution here. The case was exactly the same for me: all the pages, categories, etc. worked perfectly, but the home page showed a 404 error.

I looked into the core_url_rewrite table and discover that there was an entry with the «request_path» field empty. So this entry was rewriting my base url and that was the reason for the 404 in my case. I just deleted it.

Hope this helps to other people.