Jump to content

Mysql Failure (help!)


Recommended Posts

http://isaacschlueter.com

 

>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
FROM (
evo_posts
INNER JOIN evo_postcats ON ID = postcat_post_ID
)
INNER JOIN evo_categories ON postcat_cat_ID = cat_ID
WHERE 1 AND (
(
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
LIMIT 8

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.

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

 Share

×
×
  • Create New...