Database errors

[Doctor Death]

Is it ok to have vbulletin database errors infrequently that dont affect the operation of the board?

I get emails from my server every now and then about vbulletin database errors but there never seems to be an operational impact.

Anyone else get these?

[Paul M]

What do the errors actually say ?

[Doctor Death]

Here is one that just came in:

Database error in vBulletin 4.0.8:

Invalid SQL:

SELECT a.attachmentid
FROM vywhbabh_attachment AS a
WHERE
(filedataid = AND userid = 1);

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 'AND userid = 1)' at line 4
Error Number : 1064
Request Date : Sunday, October 31st 2010 @ 11:25:48 AM
Error Date : Sunday, October 31st 2010 @ 11:25:48 AM
Script : http://www.xxxxxxxxx.com/forums/cron...and=1288538721
Referrer : http://www.xxxxxxxxxxxxx.com/forums/...php?5468-Locks
IP Address : 121.51.81.42
Username : Unregistered
Classname : vB_Database
MySQL Version :

[Doctor Death]

Any idea of what mod would cause this and/or how I would go about fixing it?

[Lynne]

It's from a cron job, but I can find no default vbulletin query like that.

[Doctor Death]

Lynne;

Thanks... do you have any suggestions on how I would search for the source of this error within the CRON jobs?

[Lynne]

Look to see what cron jobs you are running that aren't from default vbulletin. Or, even look at the time it ran at and see what jobs run at that time.