mybb_sessions crashed and need repaired

[zhihao]

rar meets table crashed

Code:

MyBB SQL Error

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
    145 - Table './tests/mybb_sessions' is marked as crashed and should be repaired
Query:
    SELECT * FROM mybb_sessions WHERE sid='89436e8043247b0d666cac55e895cf49' AND ip='183.17.230.152' LIMIT 1

Please contact the MyBB Group for support.

fix it

Code:

mysql> use tests
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> repair table mybb_sessions;
+---------------------+--------+----------+------------------------------------------+
| Table               | Op     | Msg_type | Msg_text                                 |
+---------------------+--------+----------+------------------------------------------+
| tests.mybb_sessions | repair | warning  | Number of rows changed from 9918 to 9917 |
| tests.mybb_sessions | repair | status   | OK                                       |
+---------------------+--------+----------+------------------------------------------+
2 rows in set (0.29 sec)