Announcement

Collapse
No announcement yet.

Database error when updating Navigation manager

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

  • [Forum] Database error when updating Navigation manager

    I've recently updated to vB 4.2 and members can no longer mark forums read, they get an error message saying the security token was invalid.

    After a bit of research it looks like it's because the mark forums read link in the navigation manager is incorrect, but when I try to edit it I get this database error message:

    Invalid SQL:

    UPDATE navigation
    SET state = 19,
    displayorder = 90,
    productid = 'vbulletin',
    scripts = '',
    showperm = 'canviewforums',
    url = 'forumdisplay.php?{session.sessionurl}do=markread&markreadhash={bbuserinfo.securitytok en}',
    menuid = ''

    WHERE navid = 76;

    MySQL Error : Unknown column 'menuid' in 'field list'
    Error Number : 1054

    Can anyone figure out how to solve this?

  • #2
    Does this happen if you disable vBSEO?
    MARK.B | vBULLETIN SUPPORT

    TalkNewsUK - My vBulletin 5.5.6 Demo
    AdminAmmo - My Cloud Demo

    Comment


    • #3
      Yeah, it does. I disabled all plug ins and used the default style and it still occurs.

      Comment


      • #4
        Add the following lines to your config.php under the <?php line:
        PHP Code:
        define('SKIP_ALL_ERRORS'true);
        define('DISABLE_HOOKS'true); 

        Also, what versions of php and MySQL are you running?
        MARK.B | vBULLETIN SUPPORT

        TalkNewsUK - My vBulletin 5.5.6 Demo
        AdminAmmo - My Cloud Demo

        Comment


        • #5
          OK, I've done that.

          I'm running version 5.3.27 PHP and 5.0.95 - community MySQL.

          Comment


          • #6
            Did the upgrade script complete fully, right the way to the "Upgrade Complete" message?
            MARK.B | vBULLETIN SUPPORT

            TalkNewsUK - My vBulletin 5.5.6 Demo
            AdminAmmo - My Cloud Demo

            Comment


            • #7
              No, I had trouble with the upgrade so I don't think it did upgrade properly. I've not been able to run the upgrade script though. Even if I upload all the files I get an error message saying the page is missing.

              The upgrade went badly and I asked my hosts to restore from a back up. I wasn't expecting it to be upgraded at all. Will I have to do the install again from the start?

              Comment


              • #8
                If you're using 4.2.2 files but the database is an earlier version then that will explain the error.

                The upgrade script needs to be run in order for a site to be upgraded.

                Close the site, Upload a fresh copy of the 4.2.2 files, then run /install/upgrade.php.
                Once it's complete, reopen the site and remove the /install folder.

                As with all upgrades, backup the database first.
                MARK.B | vBULLETIN SUPPORT

                TalkNewsUK - My vBulletin 5.5.6 Demo
                AdminAmmo - My Cloud Demo

                Comment


                • #9
                  Even though I've uploaded everything when I go to mydomain/forum/install/upgrade.php I get a page not found message.

                  Comment


                  • #10
                    It was the chuffin' vBSEO, even though it was all switched off. I have disabled the rewrites in the .htaccess file and I think I can now do the upgrade. Fingers crossed.

                    Comment


                    • #11
                      OK, everything seems to be working fine now, thanks for your assistance Mark.

                      Comment


                      • #12
                        You're welcome. Glad you got it sorted.
                        MARK.B | vBULLETIN SUPPORT

                        TalkNewsUK - My vBulletin 5.5.6 Demo
                        AdminAmmo - My Cloud Demo

                        Comment

                        widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
                        Working...
                        X