Code:
Database error in vBulletin 3.7.2:
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 = 1)
LEFT JOIN forumread AS forumread ON (forumread.forumid = forum.forumid AND forumread.userid = 1)
WHERE thread.forumid IN(01,2,70,78,17,19,79,76,75,15,67,74,18,31,24,26,29,14,21,65,54,63,61,49,51,48,56,66,55,52,62,60,59,53,64,58,57,50,16,22,32,33,68,35,3,13,9,10,72,11,12,4,5,6,7,8,71,69,34) AND thread.forumid NOT IN(0) AND thread.visible IN (0,1,2)
AND post.dateline > IF(threadread.readtime IS NULL, 1217888417, threadread.readtime)
AND post.dateline > IF(forumread.readtime IS NULL, 1217888417, forumread.readtime)
AND post.dateline > 1217888417
AND thread.lastpost > IF(threadread.readtime IS NULL, 1217888417, threadread.readtime)
AND thread.lastpost > IF(forumread.readtime IS NULL, 1217888417, forumread.readtime)
AND thread.lastpost > 1217888417;
MySQL Error : Table './fniv_board/forumread' is marked as crashed and should be repaired
Error Number : 145
Request Date : Tuesday, August 5th 2008 @ 12:43:29 AM
Error Date : Tuesday, August 5th 2008 @ 12:43:29 AM
Script : http://www.fniv.it/board/index.php
Referrer :
IP Address : xxxxxxxxxx
Username : KURTZ
Classname : vB_Database
MySQL Version : 5.0.51a
what's up? pls help ... :S