MyBB Community Forums

MyBB SQL Error

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1 - Can't create/write to file '/tmp/#sql_d7d_0.MYI' (Errcode: 13)
Query:
SELECT t.*, p.displaystyle AS threadprefix, (t.totalratings/t.numratings) AS averagerating, r.uid AS rated, t.username AS threadusername, u.username FROM mybb_threads t LEFT JOIN mybb_users u ON (u.uid = t.uid) LEFT JOIN mybb_threadratings r ON(r.tid=t.tid AND r.uid='1') LEFT JOIN mybb_threadprefixes p ON (p.pid = t.prefix) WHERE t.fid='28' AND (t.visible='1' OR t.visible='0') GROUP BY t.tid ORDER BY t.sticky DESC, t.lastpost desc LIMIT 0, 10

Please contact the MyBB Group for support.

That's host issue. You've to contact them to resolve. There server is not creating or writing to the database.

no?

i can write into threads

http://www.ediksa.com/showthread.php?tid=2

but not able to open forum

---

ijust tried restore back up home page now home page and everything giving error..

admin panel is working only

The error means that mysql could not write to the temporary file (not the database). Unfortunately, this is not something we can help you with, you will need to ask your host to check and fix mysql for you.