[Can’t create/write to file ‘/var/tmp/#sql_5d6a_0.MYI’ (Errcode: 2)]

That seems like a message you’d definitely want to pass along to your host.

The host does nothing.

I have been on the phone with them twice with the same problem.

I even deleted my themes and changed directories to try and fix the problem.
engloy, I am right there with you!

Yahoo says it is a WP problem.

I get this at the top of my page, and only my “pages” show up, everything else is “sorry, no post matches…”

WordPress database error: [Can’t create/write to file ‘/var/tmp/#sql_62f0_0.MYI’ (Errcode: 2)]
SELECT DISTINCT * FROM wp_posts WHERE 1=1 AND post_date_gmt <= ‘2006-05-12 23:07:59’ AND (post_status = “publish”) AND post_status != “attachment” GROUP BY wp_posts.ID ORDER BY post_date DESC LIMIT 0, 10

I can promise you, this is NOT from WordPress:

'/var/tmp/#sql_62f0_0.MYI' (Errcode: 2)]

Errcode: 2 is, to the best of my recollection, MySQL (the database) telling you it can’t find a necessary file.

Host.

thenoisedotus: When was the last time you contacted the Yahoo team? Wonder whether if I will get any luck with them.

I did a search on the WordPress support forums and this link came up: https://www.ads-software.com/support/topic/40238?replies=12

I wonder if the Yahoo web support will be willing to take a look at that.

I just e-mailed Yahoo! I too use them as my host for https://tf2.org and having the same error. I’m overly tired right now to dig out their phone — which is nicely buried in some dark corner somewhere on their website.

We’ll see…

Seems that Yahoo! has gotten its act together.

Although I didn’t receive a reply from them, my blogs are now working as normal ??

Thanks for the help!

Hmm… seems that no luck with christoball’s and thenoisedotus’ blogs though. Hope Yahoo! continues to pay attention!

My blog is giving me the same error (WordPress database error: [Can’t create/write to file ‘/var/tmp/#sql_12a4f_0.MYI’ (Errcode: 2)]). It has been since last night.

Is this a Yahoo problem or do I need to change something in the mysql database? If this is a Yahoo problem, does anyone have an email address to contact Yahoo?

Thank you in advance for any help getting our blog working again.

gilchrist-electric: Think it is a Yahoo problem. You can contact them under the link “contact us” after you log in to their webhosting website at https://webhosting.yahoo.com

Looks like I spoke too soon. The problem is back! The same message again. Are the yahoo webhosting people tweaking with the settings or what? Yet to get a reply from their web support team and phone calls to the US from Singapore aren’t exactly that cheap too!

Yahoo! Small Business Technical Support 800-318-0783

Okie dokie, phone support seems really limited. I did talk to a really nice lady on my 2nd call. My first call (17mins 2secs) was dropped.

She couldn’t do much, I asked her to do whatever she could to help… she gave me the e-mail address of [email protected] to try as well.

I’d hate to have to switch to another blogging software over this after I really got used to wordpress.

Your host hoses up their db servers and instead of leaving the host, you’d change software? Yikes!

Do keep in mind though, if you DO decide to change, that this is related to the mySQL db on Y!’s servers. I guess you’ll want to find a blog that doesn’t use it.