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_593_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 ('86','87','88','89','94','95','96','98','99','100','104','106','116','128','129','133','135','139','160','163','178','181','182','183','189','198','214','219','239','240','248','253','272','283','286','303','305','307','314','316','317','321','94','182','262','214','178')) c ON (p.id=c.news_id) WHERE MATCH (title, short_story, full_story, xfields) AGAINST ('Гиппократ ') AND id != 1573 AND approve=1 ORDER BY score DESC LIMIT 10