WordPress database error:

[pt49]

I get this error message on all my WordPress blogs installed with Fantastico on Host Gator.

I don't know whether it's a Hostgator or WordPress problem

WordPress database error: [Can't create/write to file '/tmp/mysql/#sql_1023_0.MYI' (Errcode: 2)]
SELECT DISTINCT * FROM wp_posts WHERE 1=1 AND post_date_gmt <= '2006-07-11 02:13:59' AND (post_status = "publish") AND post_status != "attachment" GROUP BY wp_posts.ID ORDER BY post_date DESC LIMIT 0, 10

This error appears above the Header on a displayed blog