Database Error

[nokidding]

Database error in vBulletin 3.7.1:

Invalid SQL:

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

MySQL Error : Can't create/write to file '/tmp/#sql_555_0.MYI' (Errcode: 30)
Error Number : 1
Request Date : Wednesday, November 5th 2008 @ 01:51:24 PM
Error Date : Wednesday, November 5th 2008 @ 01:51:24 PM
Script : http://arabicmusicforums.com/forums/private.php
Referrer : http://arabicmusicforums.com/forums/...ead.php?t=3861
IP Address : 194.126.21.5
Username : The Punisher
Classname : vB_Database
MySQL Version : 5.0.51a-community

[SEOvB]

Are you on a shared or dedicated/VPS host.

If shared, contact your hosting provider.

If dedicated/VPS make sure mysql has permission to write to the /tmp folder, if not you an chmod the folder to 777 and change the owner of the folder to mysql

[Brandon Sheley]

what mod do you have that's trying to write to your tmp folder?

[nokidding]

Its fixed.. Thanks mates