Database error "Error Number : 1"

[RichM]

We keep getting this error on our forum when we try to view a members profile.

Database error in vBulletin 3.8.1:

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

MySQL Error : Can't create/write to file '/tmp/#sql_21a6_0.MYI' (Errcode: 30)
Error Number : 1
Request Date : Monday, February 2nd 2009 @ 11:30:11 AM
Error Date : Monday, February 2nd 2009 @ 11:30:13 AM
Script : http://www.slicedthread.com/usercp.php
Referrer : http://www.slicedthread.com/showthread.php?t=80706
IP Address : 62.31.***.*
Username : ******
Classname : vB_Database
MySQL Version :

Any ideas? I've tried running the database repair script.

Cheers

- Rich

[Steve Machol]

OS error code 30: Read-only file system

It looks like your server's /tmp directory is read-only. You need to contact your host about this.