vBulletin Options showing error

[MalluParadise]

Hello guys

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

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]

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

define('DISABLE_HOOKS', true);

[MalluParadise]

edit config.php but can't find 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.....


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

define('DISABLE_HOOKS', true);

[MalluParadise]

I did this Bit still it's showing error

[puertoblack2003]

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

[Lynne]

You will need to either look at the schema and find the info or ask over at vb.com for the query to add the column.

[mcrider]

Just curious, were you doing anything to your forum just before you started receiving these errors?

[MalluParadise]

If any one can help or guide me personal!!!

[Brandon Sheley]

If any one can help or guide me personal!!!

Lynne posted in #11 what to do or at least try ;)

[MalluParadise]

i tried all these way but it's it'showing error

[Lynne]

i tried all these way but it's it'showing error
...
You will need to either look at the schema and find the info or ask over at vb.com for the query to add the column.