Forum back online, new problems

[fotps]

UserCP and viewing profiles comes up with this error:

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 = 351 AND userlist_ignore.relationid = pmtext.fromuserid AND userlist_ignore.type = 'ignore')
LEFT JOIN icon AS icon ON(icon.iconid = pmtext.iconid)
WHERE pm.userid = 351
AND pm.messageread = 0
ORDER BY pmtext.dateline DESC
LIMIT 5;

MySQL Error : Can't create/write to file '/tmp/#sql_11a5_0.MYI' (Errcode: 13)
Error Number : 1
Request Date : Saturday, October 24th 2009 @ 07:36:30 PM
Error Date : Saturday, October 24th 2009 @ 07:36:30 PM
Script : http://forums.flopofthepops.com/usercp.php
Referrer : http://forums.flopofthepops.com/showthread.php?p=58857
IP Address : 60.241.47.142
Username : The HBIC
Classname : vB_Database
MySQL Version : 5.0.81-community

[Mysterious2207]

Have you added any custom modifications or altered any code prior to this happening?

[fotps]

no

and someone just told me they cant sign up either, it comes up with the same error

--------------- Added [DATE]1256394533[/DATE] at [TIME]1256394533[/TIME] ---------------

[snakes1100]

Is this a dedicated/vps server?

What are the owner ship & chmod permissions on the /tmp dir?

If this is a vhosted account, you may need to contact the host to have them fix the issue:

Is the server running safe_mode?