[idalis]

Database error in vBulletin 3.6.5:

Invalid SQL:

SELECT
IF(votenum >= 1, votenum, 0) AS votenum,
IF(votenum >= 1 AND votenum > 0, votetotal / votenum, 0) AS voteavg,
post.pagetext AS preview,
thread.threadid, thread.title AS threadtitle, thread.forumid, pollid, open, replycount, postusername, postuserid, thread.iconid AS threadiconid,
thread.lastpost, thread.lastposter, thread.lastpostid, thread.dateline, IF(views<=replycount, replycount+1, views) AS views, notes, thread.visible, sticky, votetotal, thread.attach,
hiddencount, deletedcount
, NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed
, deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason
, threadread.readtime AS threadread
, threadredirect.expires

FROM vb3_thread AS thread
LEFT JOIN vb3_deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND deletionlog.type = 'thread')
LEFT JOIN vb3_subscribethread AS subscribethread ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 6 AND canview = 1)
LEFT JOIN vb3_threadread AS threadread ON (threadread.threadid = thread.threadid AND threadread.userid = 6)
LEFT JOIN vb3_post AS post ON(post.postid = thread.firstpostid)

LEFT JOIN vb3_threadredirect AS threadredirect ON(thread.open = 10 AND thread.threadid = threadredirect.threadid)

WHERE thread.threadid IN (0,42214,42213,42114,42145,42047,42094,42135,42013 ,42141,42076,42154,29967,42056,42073,42148,42126,4 2118,42091,42054,42113,41991,33239,41992,42028,420 92,42123,41907,35394,42082,42111,9187,2041,14920,1 3917,32160,347,13763,27970,4282)
ORDER BY sticky DESC, lastpost DESC;

MySQL Error : Table 'threadread' is marked as crashed and should be repaired
Error Number : 1194
Date : Sunday, August 26th 2007 @ 07:02:44 PM
Script : http://www.authenticforum.com/forumdisplay.php?f=4
Referrer : http://www.authenticforum.com/
IP Address :
Username :
Classname : vb_database

Everything was fine until around an hour ago. The site went down (i think the server was down, other sites on it were down as well) for about 30 minutes. It came back up and was totally fine, then suddenly every page started showing database error, for all the users, just like i posted up there.

PM'ing works, CP works