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

Error Number: 1

The Error returned was:
Can't create/write to file '/var/tmp/#sql_61b_0.MAI' (Errcode: 28)

SQL query:

SELECT id, date, short_story, xfields, title, category, alt_name, MATCH (title, short_story, full_story, xfields) AGAINST ('Yes, I do... and so much more 4/4 ') as score FROM dle_post WHERE MATCH (title, short_story, full_story, xfields) AGAINST ('Yes, I do... and so much more 4/4 ') AND id != 198964 AND approve=1 ORDER BY score DESC LIMIT 4