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

Error Number: 1021

The Error returned was:
Disk full (/tmp/#sql-temptable-ae82c-29b742d-583b9.MAI); waiting for someone to free some space... (errno: 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 ('ZOYA - TARINER ') as score FROM dle_post WHERE MATCH (title, short_story, full_story, xfields) AGAINST ('ZOYA - TARINER ') AND id != 12912 AND approve=1 AND date < '2024-10-09 05:20:45' ORDER BY score DESC LIMIT 5