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

Error Number: 1021

The Error returned was:
Disk full (/var/tmp/#sql-temptable-189181-91c3-1c02.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 ('\"Сүйіспеншілік -өмір негізі\" ') as score FROM dle_post WHERE MATCH (title, short_story, full_story, xfields) AGAINST ('\"Сүйіспеншілік -өмір негізі\" ') AND id != 43 AND approve=1 AND date < '2025-07-18 07:33:47' ORDER BY score DESC LIMIT 5