No announcement yet.

Can't Open File User.MYI

  • Filter
  • Time
  • Show
Clear All
new posts

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

    REPAIR TABLE user;

    Leave a comment:

  • LostOnline
    started a topic Can't Open File User.MYI

    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...

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