can someone help me out with this mySQL error?

[anarchystar]

Database error in vBulletin 3.0.7:

Invalid SQL:
SELECT IF(votenum >= 1, votenum, 0) AS votenum, IF(votenum >= 1 AND votenum != 0, votetotal / votenum, 0) AS voteavg,
thread.threadid, thread.title, replycount, postusername, postuserid, thread.dateline AS postdateline, thread.lastposter, thread.lastpost, IF(views<=replycount, replycount+1, views) AS views, forumid, post.postid, pagetext, allowsmilie
, showsignature, usertextfield.signature
,thread.iconid AS threadiconid, iconpath AS threadiconpath
, avatarpath, NOT ISNULL(avatardata) AS hascustom, customavatar.dateline AS avatardateline, avatarrevision

, attachment.filename, attachment.filesize, attachment.visible, attachmentid, counter, thumbnail, LENGTH(thumbnail) AS thumbnailsize
FROM anarchystar_thread AS thread
LEFT JOIN anarchystar_post AS post ON (post.postid = thread.firstpostid)
LEFT JOIN anarchystar_icon USING (iconid)
LEFT JOIN anarchystar_attachment AS attachment ON (post.postid = attachment.postid)
LEFT JOIN anarchystar_user AS user ON (user.userid = post.userid)

LEFT JOIN anarchystar_usertextfield AS usertextfield ON (post.userid = usertextfield.userid)

LEFT JOIN anarchystar_avatar as avatar ON (avatar.avatarid = user.avatarid)
LEFT JOIN anarchystar_customavatar as customavatar ON (customavatar.userid = user.userid)


LEFT JOIN anarchystar_deletionlog AS deletionlog ON (thread.threadid = deletionlog.primaryid AND type = 'thread')
WHERE forumid IN(28) AND thread.visible = 1 AND thread.open != 10 AND deletionlog.primaryid IS NULL
GROUP BY post.postid
ORDER BY postdateline DESC
LIMIT 7
mysql error: Can't create/write to file '/tmp/#sql5cc7_413_1.MYI' (Errcode: 13)

mysql error number: 1

[Paul M]

That looks like a temp table problem - have you run out of disk space ?

[anarchystar]

I should'nt have, I have about 60gigs of total server space ... could it be that one folder it is referenceing? '/tmp/#sql5cc7_413_1.MYI' ?

I also get this error when I try to modify settings in the admincp

Database error in vBulletin 3.0.7:

Invalid SQL:
SELECT setting.*, settinggroup.grouptitle
FROM anarchystar_settinggroup AS settinggroup
LEFT JOIN anarchystar_setting AS setting USING(grouptitle)
WHERE settinggroup.displayorder <> 0
ORDER BY settinggroup.displayorder, setting.displayorder

mysql error: Can't create/write to file '/tmp/#sql5cc7_52a_0.MYI' (Errcode: 13)

mysql error number: 1

Date: Sunday 15th of May 2005 09:49:30 AM
Script: http://forums.anarchystar.com/anarchycp/options.php?null=0
Referer: http://forums.anarchystar.com/anarchycp/index.php?do=nav

[Marco van Herwaarden]

Error code 13: Permission denied

You are getting a permission denied when MySQL is trying to write to a temp table used to sort the query.

[anarchystar]

Do you know why I would be getting this error, and is it fixable?

Or am I going to have to restore my entire database?

[Marco van Herwaarden]

No you should check the permissions on your /tmp directory and check it still have enough free space.

[anarchystar]

Disk space should'nt be an issue, I have plenty. When I checked earlier the permissions were set at 600 ... I don't know if that is the correct setting or not.

Of course all was working a.o.k 10 hours ago, and I have no idea what could of changed between the time I went to bed and now. :rolleyes:

[Marco van Herwaarden]

600 don't sound correct for /tmp to me. Think it should be 666 or 777 even.

[anarchystar]

I emailed my webhost, they fixed whatever the problem was. Thanks for all your responses! :D