Fatal error: Incorrect key file for table '/tmp/#sql_2e8e1_0.MYI'; try to repair it

Query:
SELECT DISTINCT blog_posts.*, blog_posts.approved AS ThisApproved, files.bigimage, files.adult_content, files.approved, files.type, members.username FROM members INNER JOIN blog_posts ON (blog_posts.uid = members.id) LEFT JOIN files ON files.bigimage = blog_posts.photo WHERE blog_posts.id !=0 AND blog_posts.approved='yes' AND blog_posts.uid = members.id GROUP BY blog_posts.date DESC LIMIT 0,20 in /home/publiccl/public_html/publicpersonals.com/inc/classes/class_mysql.php on line 185