MySQL error in file: /engine/modules/show.short.php at line 53

Error Number: 126

The Error returned was:
Incorrect key file for table '/tmp/#sql_59c_0.MYI'; try to repair it

SQL query:

SELECT p.*, e.* FROM cms_post p INNER JOIN cms_category_to_post pc ON p.id = pc.post_id LEFT JOIN cms_post_extras e ON (p.id=e.news_id) WHERE pc.category_id IN ('896') AND approve=1 ORDER BY fixed desc, sorting ASC, title ASC LIMIT 240,20