January 07, 2014

Magento Admin CMS Pages not showing in admin panel

This might be complicated if you have deleted german, french store etc.
Then or else you will receive error 404 while loading CMS pages in admin panel.

To solve this,

Get Turn on Error log on by renaming file named local.xml.sample to local.xml in errors directory

Now, Run following query in mysql window.

SET FOREIGN_KEY_CHECKS=0;
UPDATE `core_store` SET store_id = 0 WHERE code='admin';
UPDATE `core_store_group` SET group_id = 0 WHERE name='Default';
UPDATE `core_website` SET website_id = 0 WHERE code='admin';
UPDATE `customer_group` SET customer_group_id = 0 WHERE customer_group_code='NOT LOGGED IN';
SET FOREIGN_KEY_CHECKS=1;

Check your cms_page_store table in database. 
Also, fire this query in window.

DELETE FROM cms_page_store WHERE store_id NOT IN (SELECT store_id FROM core_store)

No comments:

Post a Comment

Thank you very much for your comment.
Your message has been successfully sent out to author of this blog.