mybb_sessions crashed and need repaired

[amoners]

error info is

Code:

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='df61d039ab5d004dcafabfe0e136252b' AND ip='183.17.230.93' LIMIT 1

The error like below:
   


How to fix it:

1. log in on host of mybb forum

2. log in(e.g. user: test, password: test) mysql of mybb forum

Code:

mysql -u  test -p test

3. change to database(e.g. test) which it use.

Code:

use test;

4. repair it by command like below:

Code:

repair table `mybb_sessions`;

The results of this command like below:

Code:

mysql> repair table `mybb_sessions`;
+--------------------+--------+----------+--------------------------------------------+
| Table              | Op     | Msg_type | Msg_text                                   |
+--------------------+--------+----------+--------------------------------------------+
| test.mybb_sessions | repair | warning  | Number of rows changed from 10489 to 10486 |
| test.mybb_sessions | repair | status   | OK                                         |
+--------------------+--------+----------+--------------------------------------------+
2 rows in set (0.26 sec)

You can try to access website again to test it work or not.

note: root password is in /var/www/html/inc/config.php
---
20210804/zhihao: update root password location
20210804/zhihao: add error info