MyBB Community Forums

Full Version: how to fix this mysql crash
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
i just tryed to get onto my fourm

and i get this messege
Quote:MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
145 - Table './user_cms643A/fourm8jsS_sessions' is marked as crashed and should be repaired
Query:
DELETE FROM fourm8jsS_sessions WHERE ip='user ip'


how would i got about fixing this and what made this happen

thank you for your help

Run the following query in your phpmyadmin;
REPAIR TABLE `fourm8jsS_sessions`;
Great that worked thank you

wonder how that table crashed
Change the sessions table to either Heap or Memory. A sessions table usually crashes more often than any other.
Most welcome Wink