MySQL error in file: /engine/modules/show.full.php at line 1241

Error Number: 1

The Error returned was:
Can't create/write to file '/tmp/#sql-temptable-1-1bcfa-16a.MAI' (Errcode: 28 "No space left on device")

SQL query:

SELECT id, date, short_story, xfields, title, category, alt_name, MATCH (title, short_story, full_story, xfields) AGAINST ('Вежливый Отказ - Пролетарий [attachment=23:2yxa_ru_vezhlivyy_otkaz_-_letargicheskiy_son_ckkifhyhbhu_342431.mp3]') as score FROM bsm_post p INNER JOIN (SELECT DISTINCT(bsm_post_extras_cats.news_id) FROM bsm_post_extras_cats WHERE cat_id IN ('69','28')) c ON (p.id=c.news_id) WHERE MATCH (title, short_story, full_story, xfields) AGAINST ('Вежливый Отказ - Пролетарий [attachment=23:2yxa_ru_vezhlivyy_otkaz_-_letargicheskiy_son_ckkifhyhbhu_342431.mp3]') AND id != 25 AND approve=1 ORDER BY score DESC LIMIT 5