MyBB Documentation

Repair mybb_sessions

The 1.6 Documentation is no longer maintained and some information may be outdated.

The MyBB 1.6 series reached end of life on October 1, 2015.

This means there will be no more security or maintenance releases for these series and forums running these versions of MyBB may be at risk of unfixed security issues. All administrators are strongly encouraged to upgrade their forums to the latest release of MyBB as soon as possible.

Users may experience a MySQL error saying that the mybb_sessions table is marked as crashed and should be repaired.

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

The Fix

Run the following query in phpMyAdmin. Replace "mybb_" with your table prefix.

REPAIR TABLE `mybb_sessions`

Permanent Fix

If you want a permanent fix to this problem run this query in phpMyAdmin. Replace "mybb_" with your table prefix.

ALTER TABLE `mybb_sessions` engine = `memory`

How?

Visit this thread for help running MySQL Queries: Common SQL queries and how to run them

Edit this page on GitHub