MySQL Error - Can't create/write to file '/tmp/#sql_7d3f_0.MYI' (Errcode: 30)
 

Quote:

Database error in vBulletin 3.7.4:

Invalid SQL:

SELECT pm.*, pmtext.*
, icon.title AS icontitle, icon.iconpath
FROM pm AS pm
LEFT JOIN pmtext AS pmtext ON(pmtext.pmtextid = pm.pmtextid)
LEFT JOIN icon AS icon ON(icon.iconid = pmtext.iconid)
WHERE pm.userid=8666 AND pm.folderid=0
ORDER BY pmtext.dateline DESC
LIMIT 0, 50;

MySQL Error : Can't create/write to file '/tmp/#sql_7d3f_0.MYI' (Errcode: 30)
Error Number : 1
Request Date : Thursday, June 4th 2009 @ 11:47:37 PM
Error Date : Thursday, June 4th 2009 @ 11:47:38 PM
Script : http://www.mysite.com/forum/private.php
Referrer : http://www.mysite.com/forum/index.php
IP Address :
Username : xxxx
Classname : vb_database
MySQL Version : 4.1.18-standard-log
Would an upgrade fix this? I'm not sure what may have caused this.