Knowledge Base

Can’t open file: ‘exp_online_users.MYI’

MySQL ERROR:

Error Number: 1016

Description
: Can't open file: 'exp_online_users.MYI'. (errno: 145)

An error like this typically means that the file associated with that particular database table has been corrupted and that it needs to be repaired.  You can repair the table in one of two ways:

Through ExpressionEngine

1. Go to Admin > SQL Manager
2. Select ‘Manage Database Tables’
3. Check the box next to the “exp_online_users” table (or whatever table is specified)
4. Scroll to the bottom of the page and select “Repair selected tables” from the dropdown and submit

Outside of ExpressionEngine

If you can’t access the ExpressionEngine Control Panel, then you will need to repair the database table some other way.  Typically, you can simply use another MySQL database administrative utility such as phpMyAdmin.  The general approach is the same: select the appropriate table and then tell the utility to repair it.

Last Updated on Feb 27, 2007 at 10:07   ( Permalink )
Category: Technical Issues, Error Messages