Urgent help please!

[idalis]

My whole site is down and everything you click on gives 'database error'. The homepage still opens and i can get to the control panel. Help!
www.authenticforum.com

[blogtorank]

If your whole site is down, you can't get to your domain.... So if you are having database errors perhaps you should put those up to see what sort of errors you are having to help you out...

[Kirk Y]

Seems to be working now?

[blogtorank]

I'm able to navigate all around your domain without problems... Perhaps you may have a limit on mysql connections, or whatever? So show some errors here that you experienced to see what it could be.

[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

[Kirk Y]

Try repairing all your tables as the error suggests.

[blogtorank]

MySQL Error : Table 'threadread' is marked as crashed and should be repaired

This is why... repair the table there...

[idalis]

Thanks everyone! That did it!

Any idea what could have caused this

[Kirk Y]

It can be caused by several factors. Are you nearing your database's disk capacity?

[Marco van Herwaarden]

If the server crashed, then it could leave tables that are not updated correctly and need a repair.