[Mystery Man]

Originally Posted by Andyucs

i get this when the cron runs

PHP Code:

Database error in vBulletin 3.6.7:

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 JOIN 
Error Number : 1064
Date         : Tuesday, July 10th 2007 @ 07:37:11 PM
Script       : 


I'm receiving the exact same error and I've tried re uploading the xml and also made sure it was overwriteable but to no avail. I'm running 3.6.8 anybody else having this issue or better yet a way to fix it?