Announcement

Collapse
No announcement yet.

Can't login into admincp after URL change

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Wayne Luke
    replied
    That would have the same effect.

    Leave a comment:


  • holymannn
    replied
    Originally posted by Wayne Luke View Post
    Run these queries:
    Code:
    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?

    Click image for larger version

Name:	Screen Shot 2020-02-19 at 7.02.45 AM.png
Views:	231
Size:	23.6 KB
ID:	4434849
    Attached Files

    Leave a comment:


  • Glenn Vergara
    replied
    Originally posted by Wayne Luke View Post
    Run these queries:
    Code:
    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:
    Code:
    update %%prefix%%setting set value = '%%your.url%%' where varname='frontend[COLOR=#FF0000]url[/COLOR]_login';

    Leave a comment:


  • Wayne Luke
    replied
    Run these queries:
    Code:
    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.

    Leave a comment:


  • Glenn Vergara
    replied
    Originally posted by Duke49th View Post
    @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.

    Leave a comment:


  • Duke49th
    replied
    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

    Leave a comment:


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

    Leave a comment:


  • Glenn Vergara
    replied
    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.

    Leave a comment:


  • TwinsForMe
    replied
    Bump

    Leave a comment:


  • TwinsForMe
    replied
    ???

    Leave a comment:


  • TwinsForMe
    started a topic Can't login into admincp after URL change

    Can't login into admincp after URL change

    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?

Related Topics

Collapse

Working...
X