MyBB Community Forums

Full Version: MyBB SQL Error 145 Table sessions' is marked as crashed
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
MyBB SQL Error

MyBB has experienced an internal SQL error and cannot continue.
SQL Error:145 - Table './admin_mybb526/mybbqz_sessions' is marked as crashed and should be repairedQuery:SELECT * FROM mybbqz_sessions WHERE sid='6ced38dc5395f9eef6fa25bbc8ce5c46' AND ip=X'b7532448'
Please contact the MyBB Group for technical support.

This is very frequently happening. Is there any permanent fix to resolve it in future.
Now, what is the best solution to fix it?

Additional info
MyBB Version 1.8.21
PHP Version 7.3.13
SQL Engine MySQLi 5.5.62
Server Load 1.83
you can try changing the database table engine to memory

SQL query:
ALTER TABLE `mybbqz_sessions` ENGINE = memory

[common SQL queries guidance]