vBulletin Options showing error

[MalluParadise]

Hello guys

When i try to log in acp then VB option it's showing data base error

PHP Code:

Database error in vBulletin 3.7.2:

Invalid SQL:

        SELECT setting.*, settinggroup.grouptitle
        FROM settinggroup AS settinggroup
        LEFT JOIN setting AS setting USING(grouptitle)
        WHERE settinggroup.displayorder <> 0
        ORDER BY settinggroup.displayorder, setting.displayorder;

MySQL Error   : Unknown column 'grouptitle' in 'from clause'
Error Number  : 1054
Request Date  : Thursday, March 26th 2009 @ 01:35:18 PM
Error Date    : Thursday, March 26th 2009 @ 01:35:18 PM
Script        : http://XXXXXXXXXX.com/forums/admincp/options.php?null=0
Referrer      : 
IP Address    : 
Username      :
Classname     : vB_Database
MySQL Version : 5.0.75-community-log 


[Brandon Sheley]

Do you still see the error if you disable the plugins?

[MalluParadise]

Do you still see the error if you disable the plugins?

i did't disable any plugins so which i have to disable

[puertoblack2003]

hope you have a db backup you missing the "grouptitle" column

[Lynne]

Originally Posted by MalluParadise

Do you still see the error if you disable the plugins?

i did't disable any plugins so which i have to disable

Since you can't get into the admin cp, you need to disable them globally:
Note: To temporarily disable the plugin system, edit config.php and add this line right under <?php

PHP Code:

define('DISABLE_HOOKS', true); 


[MalluParadise]

edit config.php but can't find

PHP Code:

define('DISABLE_HOOKS', true); 


this line Not only my vb Option

[mcrider]

You have to add that line to your config file just as Lynne stated.....

Originally Posted by Lynne

edit config.php and add this line right under <?php

PHP Code:

define('DISABLE_HOOKS', true); 


[MalluParadise]

I did this Bit still it's showing error

[puertoblack2003]

Originally Posted by MalluParadise

I did this Bit still it's showing error

like i stated on post #4 you missing that grouptitle column. two things can happen either insert it or if you have any good backup then do it that way.If you decide to insert you have to be careful and actually know where to put it.

[MalluParadise]

like i stated on post #4 you missing that grouptitle column. two things can happen either insert it or if you have any good backup then do it that way.If you decide to insert you have to be careful and actually know where to put it.

I don't How to use insert option