WordPress database error:

On the following websites,

http://www.preerp.com

http://www.seomkt.com

I randomly get this error!

WordPress database error: [Can't create/write to file '#sql_7cd1_2.MYD' (Errcode: 17)]

SELECT wp_sfgroups.group_id, group_name, group_desc, group_rss, group_icon, forum_id, forum_name, forum_slug, forum_desc, forum_status, forum_icon, forum_rss_private, post_id FROM wp_sfgroups LEFT JOIN wp_sfforums ON wp_sfgroups.group_id = wp_sfforums.group_id ORDER BY group_seq, forum_seq;

Code (markup):

Any ideals on how to fix this issue?

 

It seems trying to write into an existing file without permission. You can check the permission of temp folder, make sure it's correctly

 

Where is this temp folder?

 

On a shared Linux server, generally it is /tmp partition of the server. If you have shared hosting account, contact your host immediately as soon as you receive this error.

Kailash

 

I have a virtual dedicated server!

Should I still contact the host?

 

If they provide manage service with your VPS then you can contact them. It seems that you are getting the error because MySQL table is not created in temporary folder.

Kailash

 

no managed I have to fix it myself!

Seems it might be easier to delete the wordpress forums!

Can anyone help me fix this here in this thread?