Magento URL Mistake No Access to Backend Admin Area
by Mike Cohen on Aug.03, 2009, under Uncategorized
The urls set in the Magento Admin -> Configuration -> Web are used to build all the urls to the css and js
files, if you make a mistake saving them and they don’t resolve properly, that means all the references are off and breaks the site. This means your site won’t appear or function properly and worse, your admin back end will not function since it depends heavily on js. Without js, you can’t do anything in the admin, so you can’t go back in and change back to the old config. Big problem. Here’s how you solve:
1. Change the config back directly in the db, as of Magento 1.3 the table is core_config_data the SQL used should be something like this, or just use PhpMyAdmin.
UPDATE core_config_data SET value=’NEW URL’ WHERE value=’OLD URL’
Make this change for both the Unsecure Base Url and Secure Base Url
2. Clear the Magento cache – according to most post on Magento, this solved the problem for most people. Didn’t for us so there was one additional step that took us a long time to figure out.
3. Magento also has the capability of caching the configuration settings in xml. This file apparently controls how Magento loads config variables, once deleted Magento resorted to using the config values stored in the database.
/app/etc/use_cache.ser
Delete this file, and you should now have your site and admin back to normal. It might be necessary to re-upload the file, not 100% sure about that.
Hope this helps someone save their site and a lot of time. Link to a Magento post on the issue:
