Announcement

Collapse
No announcement yet.

Got error 127 from storage engine

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

  • Got error 127 from storage engine

    I got about 400 emails from letting me know of the following.

    Database error in vBulletin 3.5.4:

    Invalid SQL:

    SELECT postid, visible, userid
    FROM post AS post

    WHERE threadid = 233005
    AND visible IN (1
    ,2

    )

    ORDER BY dateline;

    MySQL Error : Got error 127 from storage engine Error Number : 1030
    Date : Monday, April 9th 2007 @ 12:51:16 PM
    Script : http://www.siccness.net/vb/showthread.php?t=233005
    Referrer : http://www.siccness.net/vb/forumdisplay.php?f=59
    IP Address : xx.xxx.xxx.xx
    Username : xxxxx
    Classname : vb_database

  • #2
    Error code 127: Unknown error 127

    127 = Record-file is crashed
    Can be fixed by running optimize and repair on the table.




    Admin Control Panel

    It is possible to repair selected tables within the admin control panel, this assumes that none of the tables affected prevent the admin panel from being accessed.
    The Repair Tables option is under the Maintenance group, only those that need repaired should be ticked as this is a very intensive operation and results in table locking while the repair is run.
    [edit]
    phpMyAdmin / MySQL Command Line

    A repair query can be run directly against the database using the following syntax.
    Code:
    REPAIR TABLE x

    Comment

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