Thursday 12 January 2012

In case magento admin side problem

use the following coding for avoid magneto admin side foreign key problem

  1. copy th below query for forignkey error
  2. because we download some sites it will chenage to another site 
  3. some times forign keys are not .so follow the query and paste in sql tab-> in phpmyadmin


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;

No comments:

Post a Comment