No announcement yet.

Can't Open File User.MYI

  • Filter
  • Time
  • Show
Clear All
new posts

  • Can't Open File User.MYI

    I am getting this error when I try to access the messageboard, this is the first time I have ever seen it...(and I was just about to upgrade to 3.0.8..this always happens to me when I set time aside to do the upgrade...something happens to the database......)

    Anyways, this is the error I am getting when trying to access the front page of the messageboard:

    <html><head><title>Shania Boards Database Error</title><style>P,BODY{FONT-FAMILY:tahoma,arial,sans-serif;FONT-SIZE:11px;}</style><body>

    <!-- Database error in vBulletin 2.3.7:

    Invalid SQL: SELECT COUNT(*) AS users,MAX(userid) AS max FROM user
    mysql error: Can't open file: 'user.MYI'. (errno: 145)

    mysql error number: 1016

    What should I do to fix this? When I look at the database using PhpMyadmin I see all the tables, but for the table "user" it states "in use"...which I had never seen before...??

    Please help.. so that I can finally start the upgrade tonight...


  • #2
    'In use' means that the table has crashed. Run this query to fix it:

    REPAIR TABLE user;
    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.