[acegames]

I have had this installed since release without any problems but now it is giving me database errors on the hourly cleanup cron , any ideas please ?

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