ERROR: Unable to execute query

SELECT ad_code FROM adverts WHERE ad_zone = '1' AND status= '1' ORDER BY RAND() LIMIT 1

Disk full (/var/tmp/#sql_525_0); waiting for someone to free some space...