No announcement yet.

Navigation Manager Set Default Database Error

  • Filter
  • Time
  • Show
Clear All
new posts

  • Navigation Manager Set Default Database Error

    When I try to set a Default Tab in the Navigation Manager, I get this Database Error:

    Database error in vBulletin 4.2.0:

    Invalid SQL:

    UPDATE vbnavigation
    SET state = (state | 2) & ~8

    WHERE navid =;

    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 '' at line 4
    Error Number : 1064
    Request Date : Tuesday, March 12th 2013 @ 07:54:15 AM
    Error Date : Tuesday, March 12th 2013 @ 07:54:15 AM
    Script :
    Referrer :
    IP Address :
    Username : samo
    Classname : vB_Database
    MySQL Version : 5.0.96-log

    Keep in mind I have deleted a Tab that was set to default.
    Please Help,

  • #2
    This is a known bug that will be fixed in 4.2.1.

    The fix for now is to manually edit your navigation table in the database.

    Always make a backup before editing the database.

    Run this query:

    UPDATE `navigation` SET `state` = 27 WHERE `name` = 'vbtab_forum'
    That assumes no table prefix is used in your database, if you use a prefix put it before the word navigation.

    Run that query in phpmyadmin or any other MySQL tool you have. It should set the Forums as the default tab and you can make further edits through Navigation manager as needed. Do not delete the default tab in 4.2.0 to avoid this issue.


    • #3
      Thank you, Mr. Joe D., thanks again.


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