Retired Documentation:  You are using the documentation for version 1.7.3 which was retired in 2013. Go here for the latest version documentation or check here for your available upgrades to the latest version.

Can’t open file: exp_online_users.MYI

ExpressionEngine returns the following error: "Can't open file: exp_online_users.MYI."

Troubleshooting

In these cases, MySQL usually returns "Error 145" which means that a "table is marked as crashed and should be repaired." This is usually caused by a file associated with that particular database becoming corrupted so that the database needs to be repaired.

Repairing the database through ExpressionEngine

If ExpressionEngine's Control Panel is still accessible, the database can be repaired via the built-in SQL Manager at Admin > SQL Manager > Manage Database Tables > Repair Selected Tables.

Repairing the database by other means

If the Control Panel is no longer accessible the database must be repaired by some other means. This can be done by using the MySQL command line tools, or some external application such as phpMyAdmin. If these attempts fails, or the error occurs with some frequency, the database administrator should be notified.

Top of Page