The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
|
#1
|
|||
|
|||
Database Error from cron jobs
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 |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|