After a server crash and restarting, MyBB reports a SQL Error as follows:
MyBB SQL Error MyBB has experienced an internal SQL error and cannot continue. SQL Error: 145 - Table './mybb/mybb_sessions' is marked as crashed and should be repaired Query: SELECT * FROM mybb_sessions WHERE sid='40021925bd0494ea31...' AND ip='x.x.x.x' LIMIT 1
The dababase is MySQL. Please help. Thank you!
You can repair the table following these steps:
Connect to the MySQL management console (through the mysql command) to the MySQL DB.
Choose the DB by executing:
repair the mybb_sessions table by executing:
repair table mybb_sessions;
If you can not use the console, you can execute the SQL in phpMyAdmin:
Select your the mybb database
Click on the “SQL” tab on the right side
Type in the following SQL and execute it
repair table mybb_session;