[dlewisr]

This is an error that I get with only one particular member. It doesn't happen all the time, sometimes he can log on no problem and others he can't log on at all. Any ideas as to what may be causing it and how to rectify the issue.

Thanks in advance.

Database error in vBulletin 4.2.0:

Invalid SQL:

SELECT COUNT(post.postid) as unread
FROM post as post /*FORCE INDEX (dateline)*/
INNER JOIN thread as thread USING (threadid)
INNER JOIN forum AS forum USING (forumid)
LEFT JOIN threadread AS threadread ON (threadread.threadid = thread.threadid AND threadread.userid = 70)
LEFT JOIN forumread AS forumread ON (forumread.forumid = forum.forumid AND forumread.userid = 70)
WHERE thread.forumid IN(0) AND thread.visible IN (1)
AND post.dateline > IF(threadread.readtime IS NULL, , threadread.readtime)
AND post.dateline > IF(forumread.readtime IS NULL, , forumread.readtime)
AND post.dateline >
AND thread.lastpost > IF(threadread.readtime IS NULL, , threadread.readtime)
AND thread.lastpost > IF(forumread.readtime IS NULL, , forumread.readtime)
AND thread.lastpost >;

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 ' threadread.readtime)
AND post.dateline > IF(forumread.readtime IS NULL, ,' at line 8
Error Number : 1064