HELP - something is wrong with my forum

[kimmie-99]

I can get to my forums but can't open any threads. I can open PM's but no threads. When I try, I keep getting :

Database error in vBulletin 3.6.8:

Invalid SQL:

SELECT post.postid, post.visible, post.userid
FROM post AS post

WHERE post.threadid = 27983
AND post.visible IN (1
,2
,0
)

ORDER BY post.dateline;

MySQL Error : Sort aborted
Error Number : 1028
Date : Monday, March 16th 2009 @ 05:33:01 AM
Script : http://www.wovenfriendships.net/showthread.php?t=27983
Referrer : http://www.wovenfriendships.net/forumdisplay.php?f=8
IP Address : 168.67.1.19
Username : kimmie
Classname : vB_Database


(wanted to add I got this from my Cron:

mysqldump: Error 1194: Table 'post' is marked as crashed and should be repaired when dumping table `post` at row: 417812


How do I fix it? I run backups - can I restore just that table or what?

[Marco van Herwaarden]

Most likely this is a problem with either permissions, file size/quota or MySQL config when creating temporary sort files. Please contact your host to verify this.

Also which MySQL version are you running?

[kimmie-99]

Running ver 3.6.8 Pl2

--------------- Added 1237200567 at 1237200567 ---------------

I tried to do a repair/optimize from my admincp and got:

Results
Table Action Message
post Check Error: Size of indexfile is: 75899904 Should be: 83005440
post Check Error: Size of datafile is: 111726692 Should be: 111731540
post Check Error: Corrupt
post

[snakes1100]

Use phpmyadmin and try to repair the post table.

If thats not successful do you have ssh access to the server?

[kimmie-99]

I'm running a repair on the table from within Vbulletin admincp - so far that's got things coming back to normal!

Thanks for the suggestions/help - things are coming back ...slowly