MyBB Community Forums
[Error Message] MyBB SQL Error 145 Table sessions' is marked as crashed - Printable Version

+- MyBB Community Forums (https://community.mybb.com)
+-- Forum: 1.8 Support (https://community.mybb.com/forum-175.html)
+--- Forum: General Support (https://community.mybb.com/forum-176.html)
+--- Thread: [Error Message] MyBB SQL Error 145 Table sessions' is marked as crashed (/thread-226292.html)



MyBB SQL Error 145 Table sessions' is marked as crashed - Steven321 - 2020-01-29

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


RE: MyBB SQL Error 145 Table sessions' is marked as crashed - .m. - 2020-01-29

you can try changing the database table engine to memory

SQL query:
ALTER TABLE `mybbqz_sessions` ENGINE = memory

[common SQL queries guidance]