lasto
05-22-2006, 10:17 PM
Database error in vBulletin 3.5.4:
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 f
Error Number : 1064
Date : Monday, May 22nd 2006 @ 06:06:37 PM
Script : *****************/cron.php?&rand=612692
Referrer : ****************/showthread.php?p=234637#post234637
IP Address : **************
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 f
Error Number : 1064
Date : Monday, May 22nd 2006 @ 06:06:37 PM
Script : *****************/cron.php?&rand=612692
Referrer : ****************/showthread.php?p=234637#post234637
IP Address : **************