MyBB SQL Error

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1 - Can't create/write to file '/tmp/#sql_4ef1_0.MYI' (Errcode: 122)
Query:
SELECT tag FROM mybb_threads WHERE fid = '8' AND tag != '' ORDER BY RAND() LIMIT 30