ExpressionEngine® 3 User Guide

Legacy Documentation

You are using the documentation for version 3.5.17. Go here for the latest version 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 Developer Tools ‣ Utilities ‣ SQL Manager. Select the tables to repair, then choose Repair selected tables at the bottom and click Submit.

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.