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

[zhihao]

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

[zhihao]

note: root password is in /var/www/html/inc/config.php

[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)