No announcement yet.

mysql error #:1016

  • Time
  • Show
Clear All
new posts

  • mysql error #:1016

    Hey Im having a problem with my VBulletin. It seems that the host upgraded the PhP to the new version. Any help would be appreciated!

    EDIT: Also I run the repair.php and it repairs it fine, just like an hour later I get the same error again, and need to go back to the repair.

    Here is the error I recieve

    Database error in vBulletin 3.0.9:
    Invalid SQL: SELECT COUNT(*) AS count FROM post WHERE dateline >= '1138488233'
    mysql error: Can't open file: 'post.MYI' (errno: 144)
    mysql error number: 1016
    Date: Saturday 28th of January 2006 05:31:37 PM

  • #2
    Hi there,

    Can't open file: '<table>.MYI'. (errno: 144)

    Error 144 = Table is crashed and last repair failed

    You should run optimize & repair on your database tables. You can upload the tools.php file from the vbulletin .zip file do_not_upload/ folder into your forumdir/admincp/ directory and run it through the browser, there's a switch there to run optimize and repair. Run it a few times for best result.

    If this repair fails you have to ask your hosting provider to take a look.


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