MySQL error in file: /engine/classes/comments.class.php at line 792

Error Number: 1021

The Error returned was:
Disk full (/var/tmp/#sql_64a_1); waiting for someone to free some space...

SQL query:

SELECT dle_comments.id, post_id, dle_comments.user_id, dle_comments.date, dle_comments.autor as gast_name, dle_comments.email as gast_email, text, ip, is_register, dle_comments.rating, dle_comments.vote_num, name, dle_users.email, news_num, dle_users.comm_num, user_group, lastdate, reg_date, signature, foto, fullname, land, dle_users.xfields, dle_post.title, dle_post.date as newsdate, dle_post.alt_name, dle_post.category FROM dle_comments LEFT JOIN dle_post ON dle_comments.post_id=dle_post.id LEFT JOIN dle_users ON dle_comments.user_id=dle_users.user_id INNER JOIN (SELECT dle_comments.id FROM dle_comments ORDER BY id desc LIMIT 124140, 30 ) as sub ON sub.id = dle_comments.id ORDER BY id desc