database error

[asimo]

hi i'm getting lots of emails saying DB error

Database error in vBulletin 3.7.2:

Invalid SQL:

SELECT post.*,
IF(post.visible = 2, 1, 0) AS isdeleted,


editlog.userid AS edit_userid, editlog.dateline AS edit_dateline, editlog.reason AS edit_reason, editlog.hashistory

FROM post AS post

LEFT JOIN editlog AS editlog ON (editlog.postid = post.postid)

WHERE post.postid = 1501;

MySQL Error : Table './zero_vbtrans2/post' is marked as crashed and should be repaired
Error Number : 145
Request Date : Wednesday, April 1st 2009 @ 06:59:20 PM
Error Date : Wednesday, April 1st 2009 @ 06:59:20 PM
Script :
Referrer :
IP Address : 66.249.67.186
Username : Unregistered
Classname : vB_Database
MySQL Version :

[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.

[asimo]

It worked thanks man!