[acegames]

Hope somebody can help me fix this problem , I am getting emails with a database error from a cron job and need help tracing what is causing it

Database error in vBulletin 3.6.8:

Invalid SQL:

UPDATE user AS user
SET user.threads =
(
SELECT COUNT(threadid)
FROM thread AS thread
LEFT JOIN forum AS forum ON forum.forumid = thread.forumid
WHERE visible = 1
AND (forum.options & 4096)
AND user.userid=postuserid
);

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 'SELECT COUNT(threadid)
FROM thread AS thread
LEFT JO
Error Number : 1064
Date : Thursday, October 18th 2007 @ 02:13:36 AM
Script : http://www.acegames.us/forum/cron.php?&rand=256860
Referrer : http://www.acegames.us/forum/
IP Address : 195.93.21.5
Username : Unregistered
Classname : vb_database