Mysql Failure (help!)

[IsaacSchlueter]

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?

[Allbuffs]

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

[IsaacSchlueter]

Ok, this must be something system-level then.

 

I 777'ed my tmp folder - still got the error.

Tried manually creating the file, and 777ing that, too. Same error.

 

Then I made the folder back to 700, and deleted the file.

[Allbuffs]

It's been fixed. Woohooo Rock Sign

[IsaacSchlueter]

WOW, that was fast! Thumbs Up