Home » Magento

Magento Error – Notice: Undefined index: 0 app/code/core/Mage/Core/Model/Mysql4/Config.php on line 92

12 July 2010 5,758 views Popularity: 12% Share/Bookmark

0
email

I got this error message when migrating my Magento files and database from one server to another.

Notice: Undefined index: 0 in app/code/core/Mage/Core/Model/Mysql4/Config.php on line 92

Solution:

- Open PhpMyAdmin
- Go to your database
- Click SQL
- Run the following SQL Query:

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;

That’s all. Your error is solved now.

Hope this helps. Thanks.

Related posts:

  1. Magento: Recoverable Error: Argument 1 passed to Mage_Core_Model_Store :: setWebsite() must be an instance of Mage_Core_Model_Website
  2. Magento: Solution to “Error: 404 Not Found” in Admin Login Page
  3. Magento: Fatal error: Call to a member function getTable() on a non-object
  4. Magento: How to remove index.php from URL?
  5. Magento: How to change Currency symbol by Model Override ?
  6. Magento: Block Controller Model Helper Override
  7. Magento: Helper Data not found error
  8. Configuration error on new Magento installation
  9. Magento: Read config XML nodes
  10. PHP extension error while installing Magento
  • http://www.canvasprintosnline.com Paul

    This works thanks mate !

  • http://pinoguin.com Elijah

    Many thanks, this worked for me.

  • Abc

    you are genius

  • http://openid-provider.appspot.com/shane.keyzo Shane

    Hi I’ve done that and seems to have worked, but the admin has lost the css and it’s broke when I try to navigate to any admin page such as import profile – it’s happening to all pages.

    Any Suggestions?

  • Waka

    Same problem here… please let us know if you found a solution :)

  • Luca

    I have the same problem of you 2!! Did you find any solution?!

  • Luca

    I think I found the solution… Try without deleting the “var” folder content! It worked for me on magento 1.5!!

  • Prabir nath

    This is amazing..a real solution to my problem..and also think the exact solution to this problem..

  • Pepe

    your great!!! thanks

  • Harsh Shah

    Great man !!! I got the Solution

    Thanks A lot!!!!!!!!!!!

  • Quimcoll

    Thank you so much, Mukesh!! It worked perfectly; but Luca, it worked for me after DELETING the content of var/session, var/cache!!!

  • Nico

    Thank you very much, after 3-4 hours for nothing your solution saved me :) :) :)

  • http://www.tinytoys.com.au Toys

    Hi did that and it is says #1146 – Table ‘tinytoys_mage1.core_store’ doesn’t exist. Can anyone help?

  • James

    Cheers Mukesh – works a treat

  • James

    Cheers Mukesh – works a treat

  • James

    Cheers Mukesh – works a treat

  • http://www.facebook.com/Schoenschrift Christian Wutke

    Many thanks!!!

  • Me

    It works great!

  • http://www.net-recruit.co.uk Netrecruit Co Uk

    Thanks dude, this worked a treat after recently moving a Magento install over to a dedicated server!

  • Charlesmarsh

    Thanks very much worked perfectly…

  • Nishant

    As simple as you posted “tinytoys_mage1.core_store’” doesn’t exist.. create the table

  • Steffen Jung

    Thanks so much for sharing this … I have searched hours to getting this error fixed. I have made a local copy of a live system on my XAMPP and always getting this annoying error message “Front controller reached 100 router match iterations” when tried to login into admin panel. Found a lot of hints around this error message but at least you one fixed it for me. You are my angel of the day ;-) BR, Steffen