MyBB Community Forums

SQL Error:

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1194 - Table 's' is marked as crashed and should be repaired
Query:
SELECT s.sid, s.ip, s.uid, s.time, s.location, u.username, u.invisible, u.usergroup, u.displaygroup FROM mybb_sessions s LEFT JOIN mybb_users u ON (s.uid=u.uid) WHERE s.time>'1313418385' ORDER BY u.username ASC, s.time DESC


Anyone know what this means and how to fix?

You have a table named "s"? Or did you just hide the real name?

You need to repair it.

Go to PhpMyAdmin. Repair and optimize all tables.

Not sure...that is the exact error message.

Where to look for table 's' to repair it?

Run this query in phpmyadmin:

repair table mybb_sessions;

OK guys...I used cpanel>phpadmin to repair and optimize the tables. The error is gone now!

Thanks!