Trying to set default in navigation

[betterthanyours]

Database error in vBulletin 4.2.0:

Invalid SQL:

            UPDATE navigation
            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  : Saturday, October 13th 2012 @ 08:43:12 PM
Error Date    : Saturday, October 13th 2012 @ 08:43:12 PM
Script        : http://www.unrealkillers.com/admincp/navigation.php?do=dodefault
Referrer      : http://www.unrealkillers.com/admincp/navigation.php?do=default&navid=34
IP Address    : 81.109.188.17
Username      : SAM
Classname     : vB_Database
MySQL Version : 5.5.24-0ubuntu0.12.04.1

I tried

UPDATE navigation SET state = 2 WHERE name = 'vbtab_forum'

Is there an SQL command I could execute?

[kh99]

You could try this:

UPDATE navigation SET state = (state | 2) | 8 WHERE navid = ID

where that last ID is the id of the tab you want as the default.

[betterthanyours]

Excellent thank you!

--------------- Added [DATE]1350225123[/DATE] at [TIME]1350225123[/TIME] ---------------

Ok now next issue is, the site does not correctly highlight "home"

Please visit the site www.unrealkillers.com to see the issue live.

Any assistance helpful.

Thanks

[kh99]

Try editing your home tab, and at the bottom where it says Tab Script(s) enter "adv_index" (without the quotes).

[betterthanyours]

Worked very well. TY