Navigation Manager Set Default Database Error

[Cobra-J82]

Hello,
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 : http://www.wassoufbook.com/fanclub/a...p?do=dodefault
Referrer : http://www.wassoufbook.com/fanclub/a...efault&navid=8
IP Address : 86.98.145.67
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,
Thanks

[BirdOPrey5]

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

http://tracker.vbulletin.com/browse/VBIV-15169

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.

[Cobra-J82]

Thank you, Mr. Joe D., thanks again.