Pm problems

[almac]

Got error message when tried to send pm

Database error in vBulletin 3.6.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=7910 AND pm.folderid=0
ORDER BY pmtext.dateline DESC
LIMIT 0, 50;

MySQL Error : Can't create/write to file '/tmp/#sql_67a9_0.MYD' (Errcode: 17)
Error Number : 1

What do i do?

[SEOvB]

make the /tmp directory world writable and readable

[snakes1100]

I doubt that there is a need to make the tmp dir writable/readable, if this is a vhost, have your host check the server and send them that error msg.

Please verify your hosting account hasnt ran out of disk space, if you have cpanel or another hosting panel, it should show you how much disk space your using, im guessing you have ran out of disk space on your account.

[Marco van Herwaarden]

Please contact your host. MySQL is trying to write a temporary file that already exists and no permission to overwrite.

Sometimes a reboot of the server will also solve this issue as the /tmp is often emptied on a reboot.

[almac]

Originally Posted by Marco van Herwaarden

Sometimes a reboot of the server will also solve this issue as the /tmp is often emptied on a reboot.

Hey presto! works after reboot.

Thanks!!!!!