DB error need fixing. Urgent

[ExTincTi0N]

Okay when I try to import a product I get a db error. Also when I try to go to vBulletin options i also get a db error. I don't know what happened but can someone help?

[SEOvB]

yes, disable all your plguins via the config.php file edit and try again.

Also post the DB error you are getting.

[ExTincTi0N]

I don't know how to disable all of my plugins via the config.php (yes i am stupid).

here is the one for vbulletin options

Database error in vBulletin 3.7.4:

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 'revo_revo.setting.grouptitle' in 'on clause'
Error Number : 1054
Request Date : Saturday, November 15th 2008 @ 08:58:38 AM
Error Date : Saturday, November 15th 2008 @ 08:58:38 AM
Script : http://www.artisticslurpee.com/forums/admincp/options.php?null=0
Referrer : http://www.artisticslurpee.com/forums/admincp/index.php?do=nav
IP Address : 71.53.86.108
Username : .RevO
Classname : vB_Database
MySQL Version : 4.1.22-standard

Here is one for trying to import plugins.
Database error in vBulletin 3.7.4:

Invalid SQL:
DELETE FROM setting WHERE product = 'yaugl' AND volatile = 1;

MySQL Error : Unknown column 'product' in 'where clause'
Error Number : 1054
Request Date : Saturday, November 15th 2008 @ 08:59:47 AM
Error Date : Saturday, November 15th 2008 @ 08:59:47 AM
Script : http://www.artisticslurpee.com/forums/admincp/plugin.php?do=productimport
Referrer : http://www.artisticslurpee.com/forums/admincp/plugin.php?do=productadd
IP Address : 71.53.86.108
Username : .RevO
Classname : vB_Database
MySQL Version : 4.1.22-standard

I am getting others as well but don't want to post to many.

[SEOvB]

Did you recently upgrade vBulletin versions?

Place this after <?php in your config.php file


define('DISABLE_HOOKS', true);

[ExTincTi0N]

No a couple of days ago I uploaded vB 3.7.4 thats all never upgraded.

[SEOvB]

No a couple of days ago I uploaded vB 3.7.4 thats all never upgraded.

You uploaded and never ran an upgrade script? Or you simply installed a new vBulletin forum using 3.7.4??

[ExTincTi0N]

I installed a new one.

[Netunt]

I'm not one for SQL knowlage but I had a problem with vBulletin on that server. I can move your account in a couple of days and see if it fixes itself unless someone else thinks that isn't the problem.

[ExTincTi0N]

Yeah I can wait a couple of days I guess.

[SEOvB]

remove any .xml files that aren't being used from the includes/xml folder and try again