Hello,
dont know if this error is known.
But i have the follow error, and this after installation thousand times
Code:
Invalid SQL:
SELECT COUNT(*) AS posts, post.threadid
FROM vb3_post as post /*FORCE INDEX (dateline)*/
INNER JOIN vb3_thread as thread USING (threadid)
INNER JOIN vb3_forum AS forum USING (forumid)
LEFT JOIN vb3_threadread AS threadread ON (threadread.threadid = thread.threadid AND threadread.userid = 1530)
LEFT JOIN vb3_forumread AS forumread ON (forumread.forumid = forum.forumid AND forumread.userid = 1530)
WHERE thread.visible IN (1)
AND thread.forumid NOT IN(64,16,52,22,24,)
AND post.dateline > IF(threadread.readtime IS NULL, 1285316613, threadread.readtime)
AND thread.lastpost > IF(threadread.readtime IS NULL, 1285316613, threadread.readtime)
AND post.dateline > IF(forumread.readtime IS NULL, 1285316613, forumread.readtime)
AND thread.lastpost > IF(forumread.readtime IS NULL, 1285316613, forumread.readtime)
AND post.dateline > 1285316613 AND thread.lastpost > 1285316613
GROUP BY post.threadid;
MySQL-Fehler : 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, 1285316613, threadre' at line 8
Thanks a lot
Andr?