MySQL error in file: /engine/modules/add-modules/authors_static.php at line 29

Error Number: 3

The Error returned was:
Error writing file '/tmp/MYfd=72' (OS errno 28 - No space left on device)

SQL query:

SELECT a.name, a.alt_name, COUNT(DISTINCT p.id) AS books FROM `dle_author` a LEFT JOIN `dle_post` p ON p.id_author = a.id AND p.approve = 1 GROUP BY a.id, a.name, a.alt_name HAVING books > 0 ORDER BY books DESC, a.name ASC LIMIT 8