MyBB Community Forums

Every time i select a section I get this error.

yBB has experienced an internal SQL error and cannot continue.

SQL Error:
1 - Can't create/write to file '/tmp/#sql_3872_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

Updated the site today

Probably your settings table is marked as crashed. Run the following query ion phpmyadmin;

REPAIR_TABLE `mybb_settinggroups`;

If its not solved, then its host issue, can't create or write to the database file, nothing we can do anything about.

so i should contact the host site?

Yes, you'll need to contact your host regarding this issue if repairing the table, as Yaldaram suggested, did not work.

where do i run it in?
myphpadmin?

Yes, in the "SQL" tab of phpMyAdmin.

ok ty so i need to download phpmyadmin?
Im not the owner of the site but an admin

No, just contact your host. It's not a crashed table, if it was then it'd say "Table ... has crashed and needs to be repaired."

Your tables haven't crashed, I have no idea why you were told to repair them.
The problem is your server can't write to a temporary file, so you have to contact your host.