No announcement yet.

Updating from 4.1.11

  • Filter
  • Time
  • Show
Clear All
new posts

  • Updating from 4.1.11

    Hello, I'm trying to update my vbulletin from 4.1.11 to the latest version. I backed up my DB, Uploaded the consents of the upload dir to the proper folder after deleting the install.php. When navigating to to the update.php file I get the following error:

    Database error in vBulletin 4.1.11:

    Invalid SQL:

    SELECT *
    FROM alpha_navigation
    WHERE state & = 0
    ORDER BY navtype, displayorder;

    MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= 0
    ORDER BY navtype, displayorder' at line 3
    Error Number : 1064
    Request Date : Sunday, January 11th 2015 @ 05:50:32 PM
    Error Date : Sunday, January 11th 2015 @ 05:50:32 PM
    Script :
    Referrer :
    IP Address :
    Username : Ben
    Classname : vB_Database
    MySQL Version : 5.5.32-log

  • #2
    seems I was going to the wrong php file, sorry for the post!


    • #3
      Upgrade.php instead of update.php. The error message you were getting was caused by having not run the upgrader yet.


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