MySQL Error : Got error 127 from storage engine

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • BIGMONAY2K
    Senior Member
    • Mar 2004
    • 191

    MySQL Error : Got error 127 from storage engine

    I have about 10,000 e-mail,help me...
    Database error in vBulletin 3.6.1:

    Invalid SQL:
    SELECT userid, usergroupid, IF(displaygroupid=0, usergroupid,
    displaygroupid) AS displaygroupid, username, posts FROM user ORDER BY posts DESC
    LIMIT 0, 10;

    MySQL Error : Got error 127 from storage engine
    Error Number : 1030
    Date : Saturday, March 24th 2007 @ 02:03:59 AM
    Script : http://www.****/forums/index.php
    Referrer :
    IP Address : 152.163.100.135
    Username : jason1
    Classname : vb_database
  • Steve Machol
    Former Customer Support Manager
    • Jul 2000
    • 154488

    #2
    This error means:

    MySQL error: 127 = Record-file is crashed

    To fix this run Repair/Optimize in the Admin CP. You may need to run it more than once to fix all errors:

    Admin CP -> Maintenance -> Repair/Optimize Tables -> Check All -> Continue
    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

    • BIGMONAY2K
      Senior Member
      • Mar 2004
      • 191

      #3
      thanks

      Comment

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