I have a problem after install
Code:
Datenbankfehler in vBulletin 4.1.0:
Invalid SQL:
SELECT COUNT(*) AS posts, post.threadid
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 = 67)
LEFT JOIN forumread AS forumread ON (forumread.forumid = forum.forumid AND forumread.userid = 67)
WHERE thread.visible IN (1)
AND thread.forumid NOT IN(106,107,108,109,110,99,100,)
AND post.dateline > IF(threadread.readtime IS NULL, 1352086208, threadread.readtime)
AND thread.lastpost > IF(threadread.readtime IS NULL, 1352086208, threadread.readtime)
AND post.dateline > IF(forumread.readtime IS NULL, 1352086208, forumread.readtime)
AND thread.lastpost > IF(forumread.readtime IS NULL, 1352086208, forumread.readtime)
AND post.dateline > 1352086208 AND thread.lastpost > 1352086208
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, 1352086208, threadre' at line 8
Fehler-Nr. : 1064
Fehler-Zeit : Monday, November 5th 2012 @ 03:27:08 PM
Datum : Monday, November 5th 2012 @ 03:27:09 PM
Skript : http://new/vb4/misc.php?show=vsaanp_newposts
Referrer : http://new/vb4/forum.php