Db error

[nyqnzguju999]

I am getting a DB error:s

Database Error  	Database error
The xx database has encountered a problem.
Please try the following:

    * Load the page again by clicking the Refresh button in your web browser.
    * Open the www.xxx.com home page, then try to open another page.
    * Click the Back button to try another link.

The www.xxx.com forum technical staff have been notified of the error, though you may contact them if the problem persists.
 
We apologise for any inconvenience.

[Lynne]

When you get the error, view the page source for that page and you will see the actual database error near the bottom of that page. It will have some information like this:

The actual mysql query/code/problem....

MySQL Error : some sort of something here
Error Number : another something here
Date : Sunday, April 13th 2008 @ 11:16:43 AM
Script : http://address.path.path/page.php
Referrer :
IP Address : **.***.**.***
Username : username
Classname : database

[nyqnzguju999]

Database error in vBulletin 3.8.3:

Invalid SQL:

SELECT count(*)as cnt,max(dateline) as lastupdate
FROM groupmessage
WHERE groupid='1';

MySQL Error : Unknown column 'groupid' in 'where clause'
Error Number : 1054
Request Date : Friday, September 4th 2009 @ 02:00:21 AM
Error Date : Friday, September 4th 2009 @ 02:00:23 AM
Script : http://www.xxxt.com/forums/cron.php?rand=1252022411
Referrer :
http://www.xxxcom/forums/login.php?d...69d0003ab9109b
IP Address : 59.103.213.251
Username : Unregistered
Classname : vB_Database
MySQL Version :

[Lynne]

There is no column groupid in the groupmessage table, so I'd say this problem is from a modification. Try disabling your modifications/plugins and see if you still have this problem.
Note: To temporarily disable the plugin system, edit config.php and add this line right under <?php

PHP Code:

define('DISABLE_HOOKS', true); 


[nyqnzguju999]

Thanks worked like a charm