Alright, got some problem when my users click 'unread private messages'
Code:
Database error in vBulletin 3.8.5:
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=1 AND pm.folderid=0
ORDER BY pmtext.dateline DESC
LIMIT 0, 50;
MySQL Error : Can't create/write to file '/tmp/#sql_58e6_0.MYI' (Errcode: 22)
Error Number : 1
Request Date : Sunday, August 1st 2010 @ 09:08:59 AM
Error Date : Sunday, August 1st 2010 @ 09:08:59 AM
Script : http://www.bobbamarket.net/Forum/private.php
Referrer : http://www.bobbamarket.net/Forum/group.php?do=invitations
IP Address : 84.92.39.104
Username : Dan
Classname : vB_Database
MySQL Version : 5.0.91-community
Would be appreciated if someone could help with this issue, thanks