Database error in vBulletin 2.3.0 mysql error number: 1016

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Borderline
    New Member
    • Jul 2002
    • 18

    Database error in vBulletin 2.3.0 mysql error number: 1016

    i have NO idea what this means or where to start to fix it.

    forum URL is http://nsro.com/forums

    the error says:

    Database error in vBulletin 2.3.0:
    Invalid SQL: SELECT COUNT(*) AS threads FROM thread
    mysql error: Can't open file: 'thread.MYI'. (errno: 145)
    mysql error number: 1016
    Date: Monday 05th of May 2003 07:14:45 PM
    Script: http://nsro.com/forums/forums/index.php?s=
    Referer:


    any ideas what to do or where to start?

    thanks in advance
  • Steve Machol
    Former Customer Support Manager
    • Jul 2000
    • 154488

    #2
    1. Upload repair.php (it's in the 'extras' folder of the zip file) to your admin directory. Close your forums, then run it from your browser with this syntax:

    http://www.yourdomain.com/forum/admin/repair.php?html=1&check=1

    [Of course change the exact URL as appropriate for your forums.]

    If everything reports 'Ok' then reopen your forums. If not, then run it again. The second time everything should report Ok.

    2. Read this thread:

    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    Comment

    • Borderline
      New Member
      • Jul 2002
      • 18

      #3
      Originally posted by Steve Machol
      1. Upload repair.php (it's in the 'extras' folder of the zip file) to your admin directory. Close your forums, then run it from your browser with this syntax:

      http://www.yourdomain.com/forum/admin/repair.php?html=1&check=1

      [Of course change the exact URL as appropriate for your forums.]

      If everything reports 'Ok' then reopen your forums. If not, then run it again. The second time everything should report Ok.

      2. Read this thread:

      http://www.vbulletin.com/forum/showt...threadid=69803
      Thank you!! this worked apparantly the first time around.

      saw one table "forums.session" that returned a "The handler for the table doesn't support check" error. and the table that seemed to be the prob was the "forums.thread" table, it repaired fine.

      we are back up and running.

      once again thank you. another good reason to be using vBulletin

      Comment

      • CeleronXT
        Senior Member
        • Mar 2002
        • 3217

        #4
        I think the session table should be ignored in repair.php by default, because it only creates confusion among everyone else...
        "63,000 bugs in the code, 63,000 bugs, you get 1 whacked with a service pack, now there's 63,005 bugs in the code."
        "Before you critisize someone, walk a mile in their shoes. That way, when you critisize them, you're a mile away and you have their shoes."
        Utopia Software - Current Software: Utopia News Pro (news management system)

        Comment

        • DWZ
          Senior Member
          • Jan 2002
          • 985
          • 2.2.9

          #5
          Originally posted by CeleronXT
          I think the session table should be ignored in repair.php by default, because it only creates confusion among everyone else...
          Agreed. On another note, the file says it's totaly unsupported by vBulletin/Jelsoft, yet they keep telling us to use it... shoudn't it become "supported"?

          Comment

          • Steve Machol
            Former Customer Support Manager
            • Jul 2000
            • 154488

            #6
            When have we ever refused to support repair.php?
            Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
            Change CKEditor Colors to Match Style (for 4.1.4 and above)

            Steve Machol Photography


            Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


            Comment

            • eron19
              Member
              • Mar 2007
              • 31
              • 3.6.x

              #7
              file updated for latest version?

              Comment

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