PDA

View Full Version : HELP! Urgent, board completely down ...

KURTZ
08-04-2008, 09:45 PM
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
08-04-2008, 09:51 PM
MySQL Error : Table './fniv_board/forumread' is marked as crashed and should be repaired

PHPmyAdmin: Run
REPAIR TABLE forumread
KURTZ
08-04-2008, 10:05 PM
now runs! thx John ;)

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

--------------- Added 1217891402 at 1217891402 ---------------

i found THIS (http://bugs.mysql.com/bug.php?id=36145) ... a mysql 5 bug ... it's correct? it's really possible?

thx
Zachariah
08-04-2008, 11:27 PM
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
08-04-2008, 11:58 PM
You can also repair/optimize tables through the AdminCP. Its listed under the Maintenance section.
KURTZ
08-05-2008, 09:41 AM
i know thx guys for the hand :)