Got error 127 from table handler

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Bat21
    Senior Member
    • Jan 2003
    • 291
    • 4.2.X

    Got error 127 from table handler

    I was receiving a load of these last night, so I ran a repair and optimise but, although it fixed the problematic thread (showthread.php?t=69893) it caused loads of other threads to do strange things i.e. the thread title was there but the content had vanished.. any ideas?

    Database error in vBulletin 3.0.8:

    Invalid SQL:
    SELECT postid FROM post AS post
    LEFT JOIN deletionlog AS deletionlog ON(post.postid = deletionlog.primaryid AND type = 'post')
    WHERE threadid = 69893 AND visible = 1 AND deletionlog.primaryid IS NULL
    ORDER BY dateline
    LIMIT 48, 16

    mysql error: Got error 127 from table handler

    mysql error number: 1030

    Date: Wednesday 12th of April 2006 09:17:38 PM
    Script: http://www.path_to_thread/showthread.php?t=69893&page=4
    Referer: http://www.*******/forumdisplay.php?f=4
    Username: ******
    IP Address: **.**.**.**
  • Colin F
    Senior Member
    • May 2004
    • 17689

    #2
    You may have to run REPAIR/OPTIMIZE multiple times.
    Best Regards
    Colin Frei

    Please don't contact me per PM.

    Comment

    • Bat21
      Senior Member
      • Jan 2003
      • 291
      • 4.2.X

      #3
      Hi Colin,

      Thanks for that, but after running it twice it said that the status was ok.

      It's really strange, a post with multiple pages of replies is showing the multiple pages in the thread view but only has 6 or so replies when going into the thread?

      My next plan is to go into PHPMyAdmin and drop all the tables and then re-import from a backup earlier yesterday.... I know I would loose posts but would that sort it, is it ok to drop all the tables first?

      Comment

      • Colin F
        Senior Member
        • May 2004
        • 17689

        #4
        Yes, if your backup is of both the structure and the data.
        Best Regards
        Colin Frei

        Please don't contact me per PM.

        Comment

        • Bat21
          Senior Member
          • Jan 2003
          • 291
          • 4.2.X

          #5
          I'm 99% sure it is, I use this command:-

          mysqldump --opt --user=****** --password=****** database_name > /path_to_file/dump.sql

          Comment

          • Bat21
            Senior Member
            • Jan 2003
            • 291
            • 4.2.X

            #6
            Just noticed that this was the first error that I received yesterday.

            There is a file called cache in the /tmp/analog directory that is .25GB big with the same time and date stamp as the first error email report.. what's is it?

            Database error in vBulletin 3.0.8:

            Invalid SQL:
            SELECT MIN(postid) AS postid
            FROM post
            WHERE threadid = 69893 AND visible = 1 AND dateline > 1144848883
            LIMIT 1

            mysql error: Got error 127 from table handler

            mysql error number: 1030

            Comment

            • Colin F
              Senior Member
              • May 2004
              • 17689

              #7
              Generally, error 127 means that the record table crashed. I'm not sure why a temp file would be generated because of that, but if repair doesn't work, you'll most likely have to restore your backup.
              Best Regards
              Colin Frei

              Please don't contact me per PM.

              Comment

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