post table crash while repairing

[zodehala]

my db is approximately 300MB . after repair db post table is crashed ( i am using following command to repair)

mysqlcheck -u root -p123 -a -c -o -r -f  --auto-repair forum

after run above command

Database error in vBulletin 3.7.3:

Invalid SQL:

 SELECT IF(votenum >= 1, votenum, 0) AS votenum, IF(votenum >= 1 AND votenum != 0, votetotal / votenum, 0) AS voteavg, votetotal, user.*, thread.threadid, post.title, thread.replycount, postusername, postuserid, thread.dateline AS postdateline, sticky, thread.attach, thread.lastpostid, thread.lastposter, thread.lastpost, IF(views<=thread.replycount, thread.replycount+1, views) AS views, thread.forumid, post.postid, pagetext
, allowsmilie, pagetext_html, postparsed.hasimages, thread.iconid AS threadiconid, iconpath AS threadiconpath, NOT ISNULL(subscribethread.subscribethreadid) AS subscribed
			FROM thread AS thread
			LEFT JOIN post AS post ON (post.postid = thread.firstpostid)
			LEFT JOIN user AS user ON (user.userid = post.userid)
LEFT JOIN postparsed AS postparsed ON (postparsed.postid = post.postid AND postparsed.styleid = 1 AND postparsed.languageid = 2) LEFT JOIN icon AS icon ON (icon.iconid = thread.iconid) LEFT JOIN subscribethread AS subscribethread ON (subscribethread.threadid = thread.threadid AND subscribethread.userid = '1')
			WHERE thread.threadid IN(51569,51571,51590,51591)
			AND thread.dateline > 1217029599
			
			
			ORDER BY sticky DESC, thread.dateline DESC
			LIMIT 10;

MySQL Error   : Table './zode/post' is marked as crashed and last (automatic?) repair failed
Error Number  : 144
Request Date  : Tuesday, September 23rd 2008 @ 05:46:39 PM
Error Date    : Tuesday, September 23rd 2008 @ 05:46:39 PM
Script        : http://www.xxx.org/
Referrer      : 
IP Address    : 
Username      : admin
Classname     : vB_Database
MySQL Version : 5.0.45-community-log

[Kinneas]

Are you able to run a repair through AdminCP (Or phpMyAdmin if you have it)?

[zodehala]

anybody knows ?

[Steve Machol]

To fix this run Repair/Optimize in the Admin CP. You may need to run it more than once to fix all errors:

Admin CP -> Maintenance -> Repair/Optimize Tables -> Check All -> Continue

If you cannot access the Admin CP you can also use phpMyAdmin to repair tables.

If that doesn't work then this may be too damaged to fix with the normal methods. Please check out this thread for other ways to repair a db, particularly items #2 and 3:

http://www.vbulletin.com/forum/showthread.php?s=&threadid=44909

You may have to ask your host to try and repair this for you.