Announcement

Collapse
No announcement yet.

Can't login into admincp after URL change

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

  • 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?

  • #2
    ???

    Comment


    • #3
      Bump

      Comment


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

        GIPHY for vB5 AutoLinker Auto-Create Flag Report Topic Social Icons in Postbit Clear Cache Cron DragDrop Upload Topic AJAX AutoUpdate Custom Avatars Selector Stop Links in Posts...and more!

        Comment


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

          Comment


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


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

              GIPHY for vB5 AutoLinker Auto-Create Flag Report Topic Social Icons in Postbit Clear Cache Cron DragDrop Upload Topic AJAX AutoUpdate Custom Avatars Selector Stop Links in Posts...and more!

              Comment


              • #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 customization and demonstration site.
                vBulletin 5 Documentation - Updated every Friday. Report issues here.
                vBulletin 5 API - Full / Mobile
                I am not currently available for vB Messenger Chats.

                Comment


                • #9
                  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='frontendurl_login';

                  GIPHY for vB5 AutoLinker Auto-Create Flag Report Topic Social Icons in Postbit Clear Cache Cron DragDrop Upload Topic AJAX AutoUpdate Custom Avatars Selector Stop Links in Posts...and more!

                  Comment

                  Related Topics

                  Collapse

                  Working...
                  X