No announcement yet.

mysql error number: 1016

  • Filter
  • Time
  • Show
Clear All
new posts

  • mysql error number: 1016

    hi ive been getting the following error message emailed to me the past few days:

    Database error in vBulletin 3.0.7:
    Invalid SQL: SELECT attachmentid, COUNT(*) AS views FROM attachmentviews GROUP BY attachmentid
    mysql error: Can't open file: 'attachmentviews.MYI'. (errno: 145)
    mysql error number: 1016
    Date: Thursday 27th of July 2006 08:10:16 AM
    Username: War Eagle
    IP Address: **.***.1**.61

    any idea what caused this and how i can resolve it?


  • #2
    MySQL error: 145 = Table was marked as crashed and should be repaired

    This error means that table has 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 -> Import & Maintenance -> Repair/Optimize Tables -> Check All -> Continue

    If you cannot open your Admin CP then you can repair tables with phpMyAdmin.
    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.


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