MySQL error in file: /engine/modules/icomm.php at line 43

Error Number: 3

The Error returned was:
Error writing file '/tmp/MYN5Gqz3' (Errcode: 28 - No space left on device)

SQL query:

SELECT c.id as comid, c.post_id, c.date, c.user_id, c.is_register, c.text, c.autor, c.email, c.approve, p.id, p.date as newsdate, p.title, p.category, p.comm_num, p.alt_name, u.foto, u.user_group, u.user_id FROM dle_comments as c, dle_post as p, dle_users as u WHERE p.id=c.post_id AND c.user_id = u.user_id AND c.approve = 1 ORDER BY c.date DESC LIMIT 0, 10