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.