PMs borked?
Richard
Administrators, Vanilla Admin Posts: 19,967 moderator
Is anyone else having problems using private messages? Everything else on Dgrin appears normal but I'm getting a MySQL error when I go to PMs. :scratch
0
Comments
Right. Interestingly, I just got a notification that Ivar sent me a PM and the unread message count shows one message, but when I try to open PMs, I get the same error:
Invalid SQL:
SELECT pm.*, pmtext.*
, icon.title AS icontitle, icon.iconpath
FROM vb3_pm AS pm
LEFT JOIN vb3_pmtext AS pmtext ON(pmtext.pmtextid = pm.pmtextid)
LEFT JOIN vb3_icon AS icon ON(icon.iconid = pmtext.iconid)
WHERE pm.userid=2831 AND pm.folderid=0
ORDER BY pmtext.dateline DESC
LIMIT 0, 50;
MySQL Error : Can't create/write to file '/tmp/#sql_16ff_0.MYI' (Errcode: 30)
Error Number : 1
Date : Sunday, February 28th 2010 @ 05:39:12 AM
Script : http://www.dgrin.com/private.php
Referrer : http://www.dgrin.com/search.php?searchid=5637
IP Address : 10.9.0.20
Username : Richard
Classname : vB_Database
Portfolio • Workshops • Facebook • Twitter
Let me know if you continue to have problems.
-Trav
Looks good, Trav. Thanks.