On my site (http://ncoleman.com) I use two WordPress installations (http://ncoleman.com/blog and http://ncoleman.com/news). Until recently, the /blog installation was WP 1.5 (I didn't feel like redoing the template for various reasons). The /news installation has always been WP 2.1
At some point in the past month, my /blog install started throwing an error. I assumed it was something I had done, so I revamped my template and upgraded to WP 2.2
The error remained.
I dumped the database and imported everything to my local XAMPP install, tested it, and everything works fine. I have tried deleting the database and importing the tables, nothing seems to work.
Now when I look at the /news install, it too throws an error--but only when you click on a category link.
The error on my /blog install:
WordPress database error: [Can't create/write to file '/tmp/#sql_3a2a_0.MYI' (Errcode: 30)] SELECT * , IF (DATE_ADD(link_updated, INTERVAL 120 MINUTE) >= NOW(), 1,0) as recently_updated FROM walrus_links LEFT JOIN walrus_link2cat ON (walrus_links.link_id = walrus_link2cat.link_id) WHERE 1=1 AND link_visible = 'Y' AND ( category_id = 19 ) ORDER BY link_name ASC
The error on my /news install:
WordPress database error: [Can't create/write to file '/tmp/#sql_3a2a_0.MYI' (Errcode: 30)] SELECT SQL_CALC_FOUND_ROWS news_posts.* FROM news_posts LEFT JOIN news_post2cat ON (news_posts.ID = news_post2cat.post_id) LEFT JOIN news_categories ON (news_post2cat.category_id = news_categories.cat_ID) WHERE 1=1 AND category_id IN (5) AND (post_type = 'post' AND (post_status = 'publish' OR post_status = 'private')) GROUP BY news_posts.ID ORDER BY post_date DESC LIMIT 0, 10
I have found no solutions doing Google searches, but I have found that MANY other blogs are experiencing the same error.
I've contacted my host, hoping it is an issue on their end, but I have received no news yet.