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 |
#2
|
|||
|
|||
What MySQL version are you using?
You should be able to determine the Scheduled Task causing this problem, by comparing the time the error occurs and the time set for each Scheduled Task. |
#3
|
|||
|
|||
Hello thankyou for the quick reply , I am using MySQL Version 4.0.27-standard
I have just ran my cron jobs one by one and found it is from : Hourly Cleanup This script performs various cleanup tasks once per hour. How can I fix this please ? |
#4
|
||||
|
||||
That code is being run by a modification you have installed, and is using syntax that will not work on the version of mysql you have installed. You can either disable the modification or upgrade mysql.
|
#5
|
|||
|
|||
Thankyou , found it and its Zoints Thread Tags causing it , I have had that installed from the time it was released though
--------------- Added [DATE]1192706309[/DATE] at [TIME]1192706309[/TIME] --------------- After disabling zoints trags it fixed the error but now an hour later its back |
#6
|
|||
|
|||
The standard "Hourly Cleanup" does not contain this query. It might be a modification that uses a plugin at the 'cron_script_cleanup' hook location.
And as Paul already mentioned, that query is not valid for MySQL 4.0. |
#7
|
|||
|
|||
ok thankyou will investigate further
|
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|