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

Error Number: 1

The Error returned was:
Can't create/write to file '/tmp/#sql_568_1.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 ('Фееричные ') as score FROM dle_post p INNER JOIN (SELECT DISTINCT(dle_post_extras_cats.news_id) FROM dle_post_extras_cats WHERE cat_id IN ('145','146','184','140','141','142','143','144','145','146','148','151','154','156','162','168','176','177','180','184','191','209','221','222','226','227','229','232','233','234','246','251','257','282','301','309','310','315','320','322','323','324','325','326','327','330','331','332','333','334','335','336','337','339')) c ON (p.id=c.news_id) WHERE MATCH (title, short_story, full_story, xfields) AGAINST ('Фееричные ') AND id != 43757 AND approve=1 ORDER BY score DESC LIMIT 10