MyBB Community Forums

I suddenly got this SQL error, and can't connect to my forum. Some of my AdminCP pages are also affected.

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
    1 - Can't create/write to file '/tmp/#sql_49e8_0.MYI' (Errcode: 28)
Query:
    SELECT g.*, COUNT(s.sid) AS settingcount FROM mybb_settinggroups g LEFT JOIN mybb_settings s ON (s.gid=g.gid) GROUP BY g.gid ORDER BY g.disporder 

Please contact the MyBB Group for support.

The forum URL is http://www.Nimania.com. Any and all help would be appreciated.

Does the file stated exist? Take a look in /tmp

This is likely caused by a crashed table.

In your database manager (phpMyAdmin for example), you'll need to execute the following.

REPAIR TABLE `mybb_settinggroups`