MySQL error in file: /engine/modules/random.php at line 12

Error Number: 1021

The Error returned was:
Disk got full writing '.(temporary)' (Errcode: 28 "No space left on device")

SQL query:

SELECT id, category, alt_name FROM dle_post WHERE approve = 1 ORDER BY rand() LIMIT 1