MySQL error in file: /engine/modules/serialy/classes/newdb.class.php at line 123

Error Number: 1021

The Error returned was:
Disk full (/tmp/#sql-temptable-375-1ce-22.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")

SQL query:

SELECT * FROM ((SELECT * FROM dle_post LEFT JOIN dle_post_extras ON (dle_post.id=dle_post_extras.news_id) WHERE approve='1' AND (category LIKE '34,%' OR category = '34') AND id<'122321' ORDER BY id DESC LIMIT 2) UNION (SELECT * FROM dle_post LEFT JOIN dle_post_extras ON (dle_post.id=dle_post_extras.news_id) WHERE approve='1' AND (category LIKE '34,%' OR category = '34') AND id>'122321' ORDER BY id ASC LIMIT 8)) as r ORDER BY r.id ASC