Vbulletin Database Error :: 'attachmentpermission'

[masterwebguy]

Database error in vBulletin 3.8.3:

Invalid SQL:

SELECT pm.*, pmtext.*, userlist_ignore.userid AS ignored
,icon.iconpath, icon.title AS icontitle
FROM pm AS pm
INNER JOIN pmtext AS pmtext ON(pmtext.pmtextid = pm.pmtextid)
LEFT JOIN userlist AS userlist_ignore ON
(userlist_ignore.userid = 1 AND userlist_ignore.relationid = pmtext.fromuserid AND userlist_ignore.type = 'ignore')
LEFT JOIN icon AS icon ON(icon.iconid = pmtext.iconid)
WHERE pm.userid = 1
AND pm.messageread = 0
ORDER BY pmtext.dateline DESC
LIMIT 5;

MySQL Error : Can't create/write to file '#sql_1e6a_0.MYD' (Errcode: 17)
Error Number : 1
Request Date : Saturday, September 5th 2009 @ 10:20:59 AM
Error Date : Saturday, September 5th 2009 @ 10:20:59 AM
Script : http://honleague.com/usercp.php
Referrer : http://honleague.com/usercp.php
IP Address : 67.181.59.218
Username : HunteR_
Classname : vB_Database
MySQL Version : 5.0.45

I went to mysql admin to see if it was a database issue, and I got this

Error

SQL query:

SHOW FULL FIELDS FROM `attachmentpermission` ;

MySQL said: Documentation
#1 - Can't create/write to file '#sql_1e6a_0.MYD' (Errcode: 17)

I looked it up everywhere and people said it could be related to the tmp dir not deleting files properly but i deleted them all, even made the directory again and cmod 777

Does not resolve.

Ideas?

[snakes1100]

Set sql to use a custom tmp dir and then restart sql

tmpdir = /home/tmp

or whatever you want to use, make sure to chown it to mysql user as well as 777 it if need be.

Added note:
Make sure you init script doesnt have a tmpdir hard coded in it as well if the temp dir doesnt change.