WordPress Database Errcode: 30 (3 posts)

  1. nicholasjcoleman
    Posted 8 years ago #

    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.

  2. Kevin Kwok
    Posted 8 years ago #

    i have had this problem just today! no one has responded to this post...

  3. nicholasjcoleman
    Posted 8 years ago #

    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,


Topic Closed

This topic has been closed to new replies.

About this Topic