• 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.

Viewing 2 replies - 1 through 2 (of 2 total)
  • i have had this problem just today! no one has responded to this post…

    Thread Starter nicholasjcoleman

    (@nicholasjcoleman)

    I found out that this error was happening because my hosting provider had done maintenance to a server and damaged either their PHP or MySQL installations. I would suggest speaking with your hosting provider, to see if this error is occurring with other customers besides you.

    Best of luck,

    -Nick-

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘WordPress Database Errcode: 30’ is closed to new replies.