Please assist with this database error, is causing my forum not to function properly. New users can't register, people can't access PMs, and people can't view profiles...
Here it is:
PHP Code:
Database error in vBulletin 3.8.4:
Invalid SQL:
SELECT user.*, (user.options & 512) AS invisible , avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustom, customavatar.dateline AS avatardateline, customavatar.filedata_thumb, customavatar.height AS avheight, customavatar.width AS avwidth, customavatar.width_thumb AS avwidth_thumb, customavatar.height_thumb AS avheight_thumb
FROM userlist AS userlist
INNER JOIN user AS user ON (user.userid = userlist.relationid)
LEFT JOIN avatar AS avatar ON (avatar.avatarid = user.avatarid)
LEFT JOIN customavatar AS customavatar ON (customavatar.userid = user.userid)
WHERE userlist.userid = 16236
AND userlist.type = 'buddy'
AND userlist.friend = 'yes'
ORDER BY RAND()
LIMIT 0, 8;
MySQL Error : Can't create/write to file '/tmp/#sql_10c6_0.MYI' (Errcode: 13)
Error Number : 1
Request Date : Sunday, January 10th 2010 @ 02:24:42 PM
Error Date : Sunday, January 10th 2010 @ 02:24:42 PM
Script : http://www.egamingsupply.com/forum/member.php?action=getinfo&u=16236
Referrer : http://www.egamingsupply.com/forum/index.php
IP Address : 68.39.148.100
Username : Monarch
Classname : vB_Database
MySQL Version : 5.0.51a-community
01-10-2010, 05:28 PM
Database Error
Linear Mode
