3.7.4 problems, whole forum is missing?

[GTOOOOOH]

I was getting some errors stating the following:

Database error in vBulletin 3.7.4:
Invalid SQL:
SELECT thread.threadid, thread.forumid, thread.title, thread.prefixid, thread.taglist, postusername, postuserid,
thread.lastpost, thread.replycount,
forum.title AS forumtitle
,post.pagetext AS preview
, NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed
FROM limmac_thread AS thread
INNER JOIN limmac_forum AS forum ON (forum.forumid = thread.forumid)
LEFT JOIN limmac_post AS post ON (post.postid = thread.firstpostid)
LEFT JOIN limmac_subscribethread AS subscribethread ON (subscribethread.threadid = thread.threadid AND subscribethread.userid = 144 AND canview = 1)

WHERE thread.threadid IN (1080, 4276, 4255, 4611, 4649) AND thread.visible = 1
AND thread.postuserid NOT IN (205)
ORDER BY lastpost DESC;
MySQL Error : Table 'forum' is marked as crashed and should be repaired
Error Number : 1194
Request Date : Wednesday, December 10th 2008 @ 07:46:55 AM
Error Date : Wednesday, December 10th 2008 @ 07:46:55 AM
Script : http://www.amacny.com/vb/showthread.php?t=4617&page=2
Referrer : http://www.amacny.com/vb/forumdisplay.php?f=3
IP Address : OMITTED
Username : Pete
Classname : vB_Database
MySQL Version : 5.0.67-community-log

So, I went into maintenance, repair optimize tables. At first, all sorts of errors/warnings. I ran it a 2nd time, perfect. Ok.. I look at my forums, almost all of them are gone. I do an Update Counters, rebuild forum information, and they come back, minus at least one and I can't get it back. Our main General Discussion forum is gone, and I can't see it in the Admin Panel either?

[GTOOOOOH]

And the problems are back...

Database error in vBulletin 3.7.4:
Invalid SQL:
SELECT thread.threadid, thread.forumid, thread.title, thread.prefixid, thread.taglist, postusername, postuserid,
thread.lastpost, thread.replycount,
forum.title AS forumtitle
,post.pagetext AS preview

FROM limmac_thread AS thread
INNER JOIN limmac_forum AS forum ON (forum.forumid = thread.forumid)
LEFT JOIN limmac_post AS post ON (post.postid = thread.firstpostid)

WHERE thread.threadid IN (1080, 4359, 4649, 4255, 4276) AND thread.visible = 1
AND forum.password = ''
AND thread.postuserid NOT IN (205)
ORDER BY lastpost DESC;
MySQL Error : Table 'forum' is marked as crashed and should be repaired
Error Number : 1194
Request Date : Wednesday, December 10th 2008 @ 06:38:26 AM
Error Date : Wednesday, December 10th 2008 @ 06:38:27 AM
Script : http://www.amacny.com/vb/showthread.php?t=4644
Referrer :
IP Address : 208.99.195.54
Username : Unregistered
Classname : vB_Database
MySQL Version :

[Wayne Luke]

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

Admin Control Panel -> Maintenance -> Repair/Optimize Tables -> Check All -> Continue

If you cannot access the Admin CP, then you can 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/showt...threadid=44909

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