Can't login into admincp after URL change

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • TwinsForMe
    Senior Member
    • Oct 2004
    • 130
    • 4.0.0

    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?
  • TwinsForMe
    Senior Member
    • Oct 2004
    • 130
    • 4.0.0

    #2
    ???

    Comment

    • TwinsForMe
      Senior Member
      • Oct 2004
      • 130
      • 4.0.0

      #3
      Bump

      Comment

      • glennrocksvb
        Former vBulletin Developer
        • Mar 2011
        • 4011
        • 5.7.X

        #4
        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.

        Flag Icon Postbit Insert GIPHY Impersonate User BETTER INITIALS AVATAR Better Name Card Quote Selected Text Bookmark Posts Post Footer Translate Stop Links in Posts +MORE!

        Comment

        • TwinsForMe
          Senior Member
          • Oct 2004
          • 130
          • 4.0.0

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

          Comment

          • Duke49th
            New Member
            • Sep 2014
            • 26
            • 4.2.x

            #6
            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

            Comment

            • glennrocksvb
              Former vBulletin Developer
              • Mar 2011
              • 4011
              • 5.7.X

              #7
              Originally posted by Duke49th
              @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.

              Flag Icon Postbit Insert GIPHY Impersonate User BETTER INITIALS AVATAR Better Name Card Quote Selected Text Bookmark Posts Post Footer Translate Stop Links in Posts +MORE!

              Comment

              • Wayne Luke
                vBulletin Technical Support Lead
                • Aug 2000
                • 73976

                #8
                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.
                Translations provided by Google.

                Wayne Luke
                The Rabid Badger - a vBulletin Cloud demonstration site.
                vBulletin 5 API

                Comment

                • glennrocksvb
                  Former vBulletin Developer
                  • Mar 2011
                  • 4011
                  • 5.7.X

                  #9
                  Originally posted by Wayne Luke
                  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';

                  Flag Icon Postbit Insert GIPHY Impersonate User BETTER INITIALS AVATAR Better Name Card Quote Selected Text Bookmark Posts Post Footer Translate Stop Links in Posts +MORE!

                  Comment

                  • holymannn
                    Senior Member
                    • Oct 2018
                    • 123
                    • 5.3.x

                    #10
                    Originally posted by Wayne Luke
                    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:	487
Size:	23.6 KB
ID:	4434849
                    Attached Files
                    Hosting: HostGator dedicated server
                    cloudflare enabled
                    PHP: 7.4
                    MySQL: 5.7
                    Vb5: 5.6.3

                    Comment

                    • Wayne Luke
                      vBulletin Technical Support Lead
                      • Aug 2000
                      • 73976

                      #11
                      That would have the same effect.
                      Translations provided by Google.

                      Wayne Luke
                      The Rabid Badger - a vBulletin Cloud demonstration site.
                      vBulletin 5 API

                      Comment

                      Related Topics

                      Collapse

                      Working...