Jump to content

Mysql Failure (help!)

Recommended Posts



>SQL-query : 

SELECT DISTINCT ID, post_author, post_issue_date, post_mod_date, post_status, post_locale, post_content, post_title, post_urltitle, post_url, post_category, post_autobr, post_flags, post_wordcount, post_comments, post_renderers, post_karma
INNER JOIN evo_postcats ON ID = postcat_post_ID
INNER JOIN evo_categories ON postcat_cat_ID = cat_ID
post_status = 'private' AND post_author =1
) OR post_status
IN (
'published', 'protected'
) AND post_issue_date <= '2004-06-21 14:18:26'
ORDER BY post_issue_date DESC

MySQL said:
#1 - Can't create/write to file '/tmp/#sql_62f1_0.MYI' (Errcode: 30)


The Query is valid. Get the same results in phpMyAdmin. Looks like anything and everything MySQL just stopped working. What's up?

Link to comment
Share on other sites

I'm getting the same error. Sent in a help ticket not too long ago.


>mySQL query error: SELECT f.*, c.id as cat_id, c.position as cat_position, c.state as cat_state, c.name as cat_name, c.description as cat_desc,
            c.image, c.url, m.member_name as mod_name, m.member_id as mod_id, m.is_group, m.group_id, m.group_name, m.mid
            FROM ibf_forums f, ibf_categories c
              LEFT JOIN ibf_moderators m ON (f.id=m.forum_id)
            WHERE c.id=f.category
            ORDER BY c.position, f.position

mySQL error: Can't create/write to file '/tmp/#sql_62f1_0.MYI' (Errcode: 30)
mySQL error code: 
Date: Monday 21st of June 2004 05:25:02 PM

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Create New...