Fresh installation on local
I believe that many people get this problem on setting up their local development environment for Magento project. Everything seems to be fine through Wizard process but you just simply can’t login into Magento admin then. So it is strange? Don’t worry – the most reason for this is that you are using localhost as local domain and this is the problem.
If so, follow two steps will help you to resolve this problem
1. Decide to use a new local domain – you can either use 127.0.0.1 or something like localhost.com. So please make sure that you will need to update url_base value in Magento database (table config_data)
2. If you use a custom domain like localhost.com, you need to edit your DNS file (alilas).
For Window users please go and add this line
Move / transfer Magento site to new hosting
You might get some errors like this
Notice: Undefined index: 0 in app/code/core/Mage/Core/Model/Mysql4/Config.php on line 92
In order to solve this you need to update 4 tables core_website, core_store_group, core_store, customer_group (not all hosting requires these steps – only database not started index from zero is getting this problem)
Looking for improvement for your Magento Store?
Facebook Connector Extension
Product related article extension
Magento Offer popup on exit extension
Unlimited Slideshow Magento Extension
Light Checkout in One Step Magento Extension
- 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.
is important to disable foreign key check, otherwise you can update table one by one in this order
core_website, core_store_group, core_store, customer_group
Hope this helps. Thanks.