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 ('65','115','10','11','12','13','25','26','28','38','45','57','65','69','70','76','85','101','115','121','158','172','202','203','249','255')) c ON (p.id=c.news_id) WHERE MATCH (title, short_story, full_story, xfields) AGAINST ('Мой счастливый брак ') AND id != 61723 AND approve=1 ORDER BY score DESC LIMIT 10