[jdeveaux]

I'm testing with 4.2 and getting the same MySQLi error, below:

Note - I've noticed that it only happens if a user logs out or comes to the site and does not have cached login credentials. Once they log-in everything appears to be ok.


Database error in vBulletin 4.2.0:

Invalid SQL:

SELECT COUNT(*) AS posts, post.threadid
FROM vb_post as post /*FORCE INDEX (dateline)*/
INNER JOIN vb_thread as thread USING (threadid)
INNER JOIN vb_forum AS forum USING (forumid)
LEFT JOIN vb_threadread AS threadread ON (threadread.threadid = thread.threadid AND threadread.userid = 0)
LEFT JOIN vb_forumread AS forumread ON (forumread.forumid = forum.forumid AND forumread.userid = 0)
WHERE thread.visible IN (1)
AND thread.forumid NOT IN(7,16,24,8,33,21,136,127,115,138,5,110,25,28,29, 42,80,3,12,134,139,36,131,130,30,99,91,32,82,69,31 ,20,27,26,117,)
AND post.dateline > IF(threadread.readtime IS NULL, 1338082997, threadread.readtime)
AND thread.lastpost > IF(threadread.readtime IS NULL, 1338082997, threadread.readtime)
AND post.dateline > IF(forumread.readtime IS NULL, 1338082997, forumread.readtime)
AND thread.lastpost > IF(forumread.readtime IS NULL, 1338082997, forumread.readtime)
AND post.dateline > 1338082997 AND thread.lastpost > 1338082997
GROUP BY post.threadid;

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 ')
AND post.dateline > IF(threadread.readtime IS NULL, 1338082997, threadre' at line 8 Error Number : 1064 Request Date : Saturday, May 26th 2012 @ 08:44:21 PM
Error Date : Saturday, May 26th 2012 @ 08:44:22 PM
Script : http://site/misc.php?show=vsaanp_newposts
Referrer : http://site/login.php?do=logout&logo...6f538d64af7e12
IP Address :
Username : Unregistered
Classname : vB_Database_MySQLi
MySQL Version :

Regards,

John