Magento 2 - Homepage is 404

Question

Am struggling with a strange error in magento 2.

Have a setup where i have removed some stores, so now only single store.

Am trying to set the home page in admin (CMS Home Page)

No matter what I do, it says 404 on home page, all other pages work.

Have looked in database, setting for is: web/default/cms_home_page is there and set ok and for scope_id = 0.

not sure which pages it is looking for, is there a way to debug that?

any other suggestions for how to fix this?

Answer 1

It can happen if one of the products is miss-configured/bad-saved/bad-imported especially url_rewrite table is missing request_path value.

What i did to fix it... Open MySQL console & run this query and see which product(s) has an empty request_path

SELECT * FROM `url_rewrite` WHERE request_path='';

Remove those entities & Clear the cache. Now you can enjoy your homepage ;)

Answer 2

In my case,

The categories entity had an empty request_path.

Go to the database and with the help of this command find the categories or products entities that have an empty request_path

SELECT * FROM `url_rewrite` WHERE request_path='';

Delete all those entries and use the cache clean and flush command:

php bin/magento cache:clean
php bin/magento cache:flush

Revisit the url, and the homepage will work fine once again.

Answer 3

Home page 404 may be solve below way as per your Issue

Issue: Store Configuration

Your store configuration point to wrong CMS page. CMS Home page was deleted or recreated, or you were experimenting with single store / multistore. What you need to do is :

Login to admin>Navigate to Stores > Configuration>Select General > Web tab >open Default Pages section>Set correct value for CMS Home Page option

Option value can be overrides on different scope level.

Scope switch located in top left corner. It is recommended to check option value from the Store View scope.

flush the cache in System > Cache Management or via console command

Issues: URL Rewrite

Under certain circumstances product or category can have empty request_path value. To fix it:

login to your store database with any database manager ( like phpMyAdmin or HeidySQL ) check if you have any records with empty request path by running following & delete those entries. It can be done manually or with SQL

MySQL> SELECT * FROM url_rewrite WHERE request_path='';
MySQL> DELETE FROM url_rewrite WHERE request_path=''; 
MagentoCLi>php bin/magento c:f

Answer 4

In admin, go to set the page you want to show as homepage in Stores > Configuration > General > Web > Default Pages > CMS Home Page.

Remember to flush the cache in System > Cache Management > Flush Magento Cache.