vb.org Archive - Trying to set default in navigation

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB4 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=251)

- - Trying to set default in navigation (https://vborg.vbsupport.ru/showthread.php?t=289054)

betterthanyours

10-14-2012 12:11 PM

Trying to set default in navigation

Code:



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

Code:

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

Is there an SQL command I could execute?

kh99	10-14-2012 12:36 PM

You could try this:

Code:

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

10-14-2012 01:24 PM

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	10-14-2012 02:01 PM

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

betterthanyours

10-14-2012 02:36 PM

Worked very well. TY

All times are GMT. The time now is 04:00 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01172 seconds Memory Usage 1,716KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (3)bbcode_code_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (5)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: