MyBB Community Forums

MyBB Community Forums > Community Archive > Archived Forums > Archived Development and Support > MyBB 1.6 > 1.6 General Support > MyBB SQL Error -how can i fix this?
Full Version: MyBB SQL Error -how can i fix this?
You're currently viewing a stripped down version of our content. View the full version with proper formatting.

enhu

2011-10-01, 06:33 AM
Quote:MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
145 - Table './***/mybb_sessions' is marked as crashed and should be repaired
Query:
DELETE FROM mybb_sessions WHERE ip='125.60.248.132'

how can i fix this?

The4G

2011-10-01, 06:37 AM
same here please help us

enhu

2011-10-01, 06:45 AM
managed to repair it thru following this instruction.

http://community.mybb.com/thread-32115-p...#pid214357
why is this happening by the way?

crazy4cs

2011-10-01, 07:33 AM
Tables seems to crash all the time, especially sessions table, in such cases, to repair them, login to your PHPMyAdmin and go to SQL area and run the below query:

REPAIR TABLE `mybb_sessions`

Replace mybb if you've some other prefix of tables.
MyBB Community Forums > Community Archive > Archived Forums > Archived Development and Support > MyBB 1.6 > 1.6 General Support > MyBB SQL Error -how can i fix this?