cancel
Showing results for 
Search instead for 
Did you mean: 

Error SQL query: UPDATE `core_store` SET store_id =0 WHERE code = 'admin';

Error SQL query: UPDATE `core_store` SET store_id =0 WHERE code = 'admin';

i am using this code to resolve error 404 admin page problem

     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;

but i have this error message

    Error

SQL query:

UPDATE `core_store` SET store_id =0 WHERE code = 'admin';

MySQL said: Documentation
#1146 - Table 'tests_maga.core_store' doesn't exist 

help me please

2 REPLIES 2

Re: Error SQL query: UPDATE `core_store` SET store_id =0 WHERE code = 'admin';

Magento 2 does not have the "core_store" table.

Magento 2 stores the stores in the "store" table.

And I would recommend against of running any SQL scripts on your database if you not fully understand what you are doing.

Re: Error SQL query: UPDATE `core_store` SET store_id =0 WHERE code = 'admin';

mysql accepted my code with your help , but now i have this error again ! what can i do ?