0

I have run the following queries on MySql:

  1. SELECT config_id FROM core_config_data WHERE path = 'web/unsecure/base_url';

Taken this config_id for #2

  1. UPDATE core_config_data SET value = "online-rug-store" WHERE config_id = 6;

  2. SELECT config_id FROM core_config_data WHERE path = 'web/secure/base_url';

  3. UPDATE core_config_data SET value = "online-rug-store" WHERE config_id = 7;

And now I can't access my Magento store or admin page on either my-site.com/magento or my-site.com/online-rug-store

Is there anything I can do at this point to gain access?

  • Did you solve your problem? How? Please share the details with us. Thanks! – Fabian Blechschmidt May 9 '13 at 7:06
  • I changed my hosting company and they did it for me so my problem is solved but not by me. If I had to guess I think my problem was that I changed my site url in the sql but not in the folder structure. – Raphael Rafatpanah May 9 '13 at 12:24
2
UPDATE core_config_data
SET `value` = 'http://my-site.com/online-rug-store/'
WHERE PATH LIKE '%base_url'

Note that you need the full URL and a trailing slash. If you have SSL setup for your domain (particularly for use with the admin) then you will need to update the secure_base_url path separately.

1

Number 1 rule of Magento - don't edit the DB directly.
Number 2 rule of Magento - seriously, don't edit the DB directly.

Chuck Norris is excluded from these rules of course

We don't normally advocate re-running the installer just to change the URL, in fact its a horrible practice, but in this situation, its your easiest solution.

Remove/rename app/etc/local.xml and launch the site from the base URL and re-run the installer.

It should correct any mistakes you've made from editing the DB directly.

  • This will change your encryption key, will it not? – philwinkle Apr 17 '13 at 17:28
  • Is there any possibility that a "slow" shared server might be causing the problems? I ended up getting my site back (with no reinstall) by changing the core_config_data table for the unsecured url back to my-site.com/magento and and leaving the secured url blank. I have no idea why this works, but it does. In fact, even if I change it, it works but only for a few hours. I really would like to understand this issue but I am lost. – Raphael Rafatpanah Apr 17 '13 at 17:32
  • @philwinkle - you can always edit the local.xml and re-enter your old key though. We never use the installer as a 're-installer' - in fact, there's a debate going on about the use of it for that purpose here. But given the OP's skillset, it seemed a more appropriate fix. – Ben Lessani - Sonassi Apr 17 '13 at 17:44
  • @RaphaelRafatpanah Very unlikely. But if you are aware your hosting is slow - why keep using it? There are some very good specialist hosting providers out there. – Ben Lessani - Sonassi Apr 17 '13 at 17:45
  • As soon as I realized that are some better options out there, I started doing the research. I am looking at either Aspiration Hosting or SiteGround (super cache?). One question - If I go with something like Magento Go that is hosted already, can I still edit core files to extend magento's classes, or do I not have access to the files on the server? – Raphael Rafatpanah Apr 17 '13 at 18:00

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.