Announcement

Collapse
No announcement yet.

1017 error and missing postindex.MYI and thread.MYI

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

  • 1017 error and missing postindex.MYI and thread.MYI

    I upgraded to Gold last week and haven't had any problems at all UNTIL last night when my ISP moved our dedicated server to a new database center.

    As soon as they brought our server back online I began receiving the following error e-mails:

    Database error in vBulletin 3.0.0:

    Invalid SQL:
    SELECT NOT ISNULL(deletionlog.primaryid) AS isdeleted, deletionlog.userid AS del_userid,
    deletionlog.username AS del_username, deletionlog.reason AS del_reason,
    threadrate.vote,
    thread.*
    FROM thread AS thread
    LEFT JOIN deletionlog AS deletionlog ON (deletionlog.primaryid = thread.threadid AND deletionlog.type = 'thread')

    LEFT JOIN threadrate AS threadrate ON (threadrate.threadid = thread.threadid AND threadrate.userid = 27)
    WHERE thread.threadid = 20379

    mysql error: Can't find file: 'thread.MYI' (errno: 2)

    mysql error number: 1017

    And when I go to our forums I can see the forum index, but when I enter an individual forum in order to view threads I get this browser error:

    Database error in vBulletin 3.0.0:

    Invalid SQL:
    SELECT COUNT(*) AS threads,
    SUM(IF(lastpost>=1080805552 AND open<>10,1,0)) AS newthread
    FROM thread AS thread

    WHERE forumid = 112
    AND sticky = 0
    AND visible = 1

    AND lastpost >= 1078213923

    mysql error: Can't find file: 'thread.MYI' (errno: 2)
    mysql error number: 1017

    Finally, when I run optimize/repair from the Admin CP I get the following errors:

    postindex Check Error: Can't find file: 'postindex.MYI' (errno: 2)

    thread Check Error: Can't find file: 'thread.MYI' (errno: 2)



    So what happened to "postindex.MYI" and "thread.MYI" ??.

    What can I do to fix this situation?


    Last edited by Eric Blair; Thu 1 Apr '04, 4:32am.

  • #2
    AdminCP > Import & Maitence > Repair / Optmize Tables > Select at least postindex and thread tables, you can select all and just click on continue, continue to run it untill all tables but session report back ok.

    Comment


    • #3
      Zachery, as I stated above, I've already tried that and I get:

      postindex Check Error: Can't find file: 'postindex.MYI' (errno: 2)

      thread Check Error: Can't find file: 'thread.MYI' (errno: 2)

      Comment


      • #4
        Ah, very weird, sorry i didnt notice, then im guessing they database did not properly get moved.

        Comment


        • #5
          Yes, it definitely looks like those tables or files weren't transferred. Contact your host since they did the move.
          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

          Related Topics

          Collapse

          Working...
          X