Magento

System / Configuration / Admin / Admin Base URL

Where is this URL Stored?  We made a mistake in entering the URL and now the Admin is un useable.  We have tried to restore the database and the files, but can not seem to get the admin back online.  The error was the the Custom URL was entered without and slash marks so like this http:www.domain/admin/ So i think it is now looking at this as if it were a folder. 

Help how do we resolve this?

I can’t apply the functionality.
If you need to rollback your action, go to core_config_data table.

Delete this keys (column name is path):
- admin/url/use_custom
- admin/url/custom
- web/secure/base_url
- web/unsecure/base_url

Thanks.  Actuall I did something similar.  Since I knew what I had entered incorrectly in to the base URL I was able to search the database and find the entries described.  Once i changed them we were back in business.

I just did the same thing and am completely stuck! Please help me!

I am new to Databases… i tried searching for the path but had no luck. What can i do?

I’m afraid to do anything with the DB because there are SO many products… I can’t afford to lose them.

I found:
SELECT * FROM `magento`.`core_config_data` WHERE (`config_id` LIKE ‘­min/url/use_custom%’ OR `scope` LIKE ‘­min/url/use_custom%’ OR `scope_id` LIKE ‘­min/url/use_custom%’ OR `path` LIKE ‘­min/url/use_custom%’ OR `value` LIKE ‘­min/url/use_custom%’)

in admin/url/use_custom

Should that be deleted?

Please help me, this is urgent!

Thanks so much,
Jon

I am still stuck on this… can someone please help me! it will only take a few minutes of your time!

I am really in need of help…

Thanks,
Jon

I hate to keep bumping this issue, but I am still struggling to figure this out.... I haven’t been able to figure it out nor find anyone to help me.. Please, someone give me a few moments of your time and help me out!! I am desperate!

Jon, what exactly are you having trouble with. What did you try?

This is how I would go about solving it:

Use a tool such as phpMyAdmin.  This is included with a lot of hosting services. I’m sure you can find one that is similar.

Anyways, this tool will allow you to see/modify records.  You can run mySql statements in it, but sometimes I just like to browse records using the browse tab.  It only shows me 30 records at a time, but changing the “show” field allows you to show any number.  Go to your core_config_data table and browse all records.

Sort them by clicking on the column heading.  This will allow you to search what you are looking for.  You can either search for the path column with the admin/whatever or you can search the value column that actually has the http://www.... that you typed in to change your admin url.  I only have around 430 or so records in that table to it’s not too big to search by scrolling.

Hope that helps.  Depending on what you see there is what your next action needs to be. Does the “value” column have a slash “/” at the end of it?  See if it’s the correct url that you were trying to change it to.  Messing with this table value won’t affect any of your products.

Oh, I forgot to mention, you can modify these values with a tool such as phpMyAdmin one by one using the user interface. No need for sql statements. I wouldn’t recommend using sql if you are new to databases. You may write one that accidentally corrupts a lot of data. I think there is an edit button that looks like a pencil. 

Vinnie

Thanks Brandlive - Your info to rollback is useful. Just want to add deleting cache through folder root: public_html>var>cache, and then try to refresh your page.

I am running magento 1.1.8 from localhost computer and try to customize admin base URL but my browser went redirect loop (what this mean?) so I have tried twice and still cannot change the admin base url. Any idea?

Meanwhile, I have fresh installed for version 1.2.0 and set up customize admin base url in the installing steps and worked fine. I dont want to install again my previous version 1.1.8 and dumping all the data - to many works - does anyone face the same failure to change admin base url?

Thanks

Make sure you update the app/etc/local.xml file to have the correct value under admin frontName.

Sindre|ProperHost - 11 February 2009 05:37 AM

Make sure you update the app/etc/local.xml file to have the correct value under admin frontName.

You mean:

Replace with:

Where “management” is my desire base URL. Is there any additional setting in local.xml as you mentioned?

Then I can insert the data through phpmyadmin in core_config_data table:

INSERT INTO `core_config_data` VALUES (533, ‘stores’, 0, ‘web/unsecure/base_url’, ‘management/’);
INSERT INTO `core_config_data` VALUES (532, ‘stores’, 0, ‘web/secure/base_url’, ‘management/’);
INSERT INTO `core_config_data` VALUES (531, ‘default’, 0, ‘admin/url/custom’, ‘management/’);
INSERT INTO `core_config_data` VALUES (530, ‘default’, 0, ‘admin/url/use_custom’, ‘1’);

Do I need to set up another else things ? If those steps that I need to do, then it’s really simple and save time. Knowledge is power

Thanks for the useful info.

You should not set the “web/unsecure/base_url” / “web/secure/base_url” values as those are used for the frontend. Only set the admin url.

PS: you can configure this through the Magento Admin Panel as well, you do not have to make the update directly in the database unless you are unable to access the admin.

It took me long long enough to do through admin area - not successfully saved configuration because my browser stop working (firefox 3) and said “redirect loop” (forgot the rest of warning message in the browser). I have tried twice and always stuck.

Regarding these two lines:
INSERT INTO `core_config_data` VALUES (533, ‘stores’, 0, ‘web/unsecure/base_url’, ‘management/’);
INSERT INTO `core_config_data` VALUES (532, ‘stores’, 0, ‘web/secure/base_url’, ‘management/’);

Those are the last record in core_config_data when I tried to save the configuration through admin area. I don’t find any problems with my frontend and find the correct value of secure and unsecure base url in the table with different config_id.

@Sindre: “You’re absolutely right about secure and unsecure base url - there double value with different config id, so I delete the last and everything work well”. Thanks again for your useful info : Two thumbs for you.

Cheers

No problem! Glad I could help

I’ld like to provide a resolved problem:

After followed the previous steps provided by Sindre, yo umay have an eventual problem of 404 error in the middle of your administration page. Explanation

If I want to have access to my admin shop with this address http://www.mydomain.com/myshop/myadmin/ after to have configured CORRECTLY the custom admin base url, I manage to get the login form.
After to have been logged, I have my administration page but in the middle of the page, instead to have the dashboard I have a 404 error. The page don’t manage to be redirected to the following address http://www.mydomain.com/myshop/index.php/myadmin/dashboard/, the address stay this one http://www.mydomain.com/myshop/myadmin/ and so that’s why I have this 404 error.

But to not have this problem with the administration, I put the option System > Configuration > Web > Url Options > Add Store Code Urls to No and then everything is ok. But I lose the possibility to have the store name in the front end !!!

Hope it’s help

Hi there,

I have an a serious problem.

How to:

I developed my site and the link from categories is not go properly......It should be like “..../index.php/shoes” but it goes like “.../shoes”
so it can’t find it. then i need to put “index.php” before categories’s name… why?

Then:

I went to back end i have change about “ base link url “ not base url....so it is more serious because when i go through google to search how to solve it only for when people change base url not BASE LINK URL.......the website work fine....no need to put index.php before categories’s name but i can’t access to back end instead of.... WHAT SHOULD I DO THEN......???

Please help me!!!!