Database errorDatabase error in vBulletin 3.8.4: Invalid SQL: SELECT COUNT(*) AS
 

I was having a 404 error page when i tried to change some setting in my adminCP, I upgraded from Vbulletin 4.8.4 to 4.8.5 and now I am getting lots of database errors.

Database error in vBulletin 3.8.4:

Invalid SQL:

SELECT COUNT(*) AS count
FROM infraction AS infraction
LEFT JOIN post AS post ON (infraction.postid = post.postid)
LEFT JOIN thread AS thread ON (post.threadid = thread.threadid)
WHERE infraction.userid = 3;

MySQL Error : Table './coradmin_CoradminVb/post' is marked as crashed and should be repaired
Error Number : 145
Request Date : Saturday, May 22nd 2010 @ 10:05:55 AM
Error Date : Saturday, May 22nd 2010 @ 10:05:59 AM
Script : http://www.corruptionx.com/member.php?u=3
Referrer : http://www.corruptionx.com/forum.php
IP Address : 87.65.68.12
Username : Bo
Classname : vB_Database
MySQL Version : 5.1.30


EDIT: ANother one


SELECT COUNT(*) AS count
FROM attachment AS attachment
INNER JOIN post AS post USING (postid)
WHERE attachment.visible = 0;