Announcement

Collapse
No announcement yet.

3.7.4 problems, whole forum is missing?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • 3.7.4 problems, whole forum is missing?

    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?
    www.amacny.com
    sigpic

  • #2
    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 :
    www.amacny.com
    sigpic

    Comment


    • #3
      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.
      Translations provided by Google.

      Wayne Luke
      The Rabid Badger - a vBulletin Cloud demonstration site.
      vBulletin 5 API

      Comment

      widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
      Working...
      X