It shows 0 threads for me not sure what is up. DO I need to wait for it to do its cron job?
forced the corn and this is what happens:
Quote:
Database error in vBulletin 3.6.8:
Invalid SQL:
UPDATE allwheeljunkies_user AS user
SET user.threads =
(
SELECT COUNT(threadid)
FROM allwheeljunkies_thread AS thread
LEFT JOIN allwheeljunkies_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 allwheeljunkies_thread AS threa
Error Number : 1064
Date : Tuesday, October 16th 2007 @ 05:12:46 PM
Script : http://allwheeljunkies.com/admincp/c...ncron&cronid=7
Referrer : http://allwheeljunkies.com/admincp/c....php?do=modify
IP Address : 66.75.231.222
Username : AWJunkies
Classname : vb_database
|