pm is not ok for all members

[mahdiyat`]

this error start appeared when any member click on his pm . what is the problem and how to solve it ?

thanks

-------------------------------------------------
Database error in vBulletin 3.0.7:

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: Got error 28 from table handler

mysql error number: 1030

Date: Friday 24th of June 2005 01:20:59 AM

[calorie]

<a href="http://www.vbulletin.com/forum/showpost.php?p=863064&postcount=11" target="_blank">http://www.vbulletin.com/forum/showp...4&postcount=11</a>

[Marco van Herwaarden]

This is for sure an out of space problem with your tmp-directory. The reason you only (for now) get this with clicking on a pm, is that MySQL for the above query will try to create a temporary file to sort the intermediate results, and fails doing so because there is not enough space left.