HELP! Urgent, board completely down ...

[KURTZ]

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

[Zachariah]

MySQL Error : Table './fniv_board/forumread' is marked as crashed and should be repaired

PHPmyAdmin: Run
REPAIR TABLE forumread

[KURTZ]

now runs! thx John

but the question is: why this happens? i never saw an error like this ...

--------------- Added [DATE]1217891402[/DATE] at [TIME]1217891402[/TIME] ---------------

i found THIS ... a mysql 5 bug ... it's correct? it's really possible?

thx

[Zachariah]

If the server hard rebooted (loss power), it could crash tables in use.
Same thing happens w/ Windows OS (lost allocation tables, FAT tables)

All you are doing is running a maintenance command to repair the problem.
If it happens a lot report the problem to your host. There may need to be some server maintenance done.

[Opserty]

You can also repair/optimize tables through the AdminCP. Its listed under the Maintenance section.

[KURTZ]

i know thx guys for the hand