I was getting some errors stating the following:
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?
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
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
Comment