Can't login into admincp after URL change

[Wayne Luke]

That would have the same effect.

[holymannn]

Run these queries:

update %%prefix%%setting set value = '%%your.url%%' where varname='frontendurl';
update %%prefix%%setting set value = '%%your.url%%' where varname='frontend_login';
update %%prefix%%setting set value = '%%your.url%%/core' where varname='bburl';
delete from datastore where title in ('options', 'publicoptions', 'miscoptions');

%%prefix%% should match the table prefix value in your /core/includes/config.php
%%your.url%% should be the URL that you want to access the site from.

Do not do anything in the information_schema database. That isn't used directly by vBulletin and making changes here can make MySQL inoperable.

Hi, for the delete from datastore part. just hit the delete button of option, publicoptions and miscoption?

[Glenn Vergara]

Run these queries:

update %%prefix%%setting set value = '%%your.url%%' where varname='frontendurl';
update %%prefix%%setting set value = '%%your.url%%' where varname='frontend_login';
update %%prefix%%setting set value = '%%your.url%%/core' where varname='bburl';
delete from datastore where title in ('options', 'publicoptions', 'miscoptions');

%%prefix%% should match the table prefix value in your /core/includes/config.php
%%your.url%% should be the URL that you want to access the site from.

Do not do anything in the information_schema database. That isn't used directly by vBulletin and making changes here can make MySQL inoperable.

There's a typo in the second query. It should be:

update %%prefix%%setting set value = '%%your.url%%' where varname='frontendurl_login';

[Wayne Luke]

Run these queries:

update %%prefix%%setting set value = '%%your.url%%' where varname='frontendurl';
update %%prefix%%setting set value = '%%your.url%%' where varname='frontend_login';
update %%prefix%%setting set value = '%%your.url%%/core' where varname='bburl';
delete from datastore where title in ('options', 'publicoptions', 'miscoptions');

%%prefix%% should match the table prefix value in your /core/includes/config.php
%%your.url%% should be the URL that you want to access the site from.

Do not do anything in the information_schema database. That isn't used directly by vBulletin and making changes here can make MySQL inoperable.

[Glenn Vergara]

@Glenn: How can one break a broken forum? :P

By making it more broken. Doing a manual update on the database may cause vital data to be deleted or interconnected data to not be synced which may cause the site to totally stop working.

[Duke49th]

If someone still cant fix it that way - look at table "information_schema" (search the same vars) - I needed to fix that one too to get the forum back running normal.

@Glenn: How can one break a broken forum? :P

[TwinsForMe]

Thanks Glenn. I'll give it a shot this weekend.

[Glenn Vergara]

Look for the frontendurl, frontendurl_login and bburl varnames in the setting table. After you updated the table, you need to go back to the same settings in AdminCP where the URLs are and save it.

Warning: Do this at your own risk. Updating database manually is not recommended. You might break the site when you do this. It is recommended to back up the database first.

[TwinsForMe]

Bump

[TwinsForMe]

???

[TwinsForMe]

I closed and moved our forum (vb5) to a subdirectory but I forgot to make the change in the admincp first. I can't move the forum back to the original URL because we reverted back to vb4 (an old backup) and that one is now live.

I saw a reference in the manual that it is possible to edit the URL in the database but there were no instructions. Could you tell me what table(s) would contain the URL so I can edit in the subdirectory, and therefore gain back access to the admincp for the closed forum, please?