Private Message Inbox << Database Error.

[Exsert]

Alright, got some problem when my users click 'unread private messages'


https://vborg.vbsupport.ru/external/2010/08/171.png



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 :)

[kh99]

I can't see the full error message, but it looks like it starts with "can't create/write to file '/tmp...", so maybe the /tmp file system is full?

[Exsert]

I can't see the full error message, but it looks like it starts with "can't create/write to file '/tmp...", so maybe the /tmp file system is full?

possibly :P

I was thinking of just re-uploading the private.php file and how is the /tmp/ folder emptied safely?

[kh99]

I was thinking of just re-uploading the private.php file and how is the /tmp/ folder emptied safely?

That I don't know - I'm not even sure the problem is that it's full, I suppose it could be some other issue.

[Exsert]

Okay well it does look like theres something wrong with the /tmp/ folder on my site,

would be great if i had confirmation from someone if it would be safe to delete it.

[Marco van Herwaarden]

It could be either a permission or a space issue. You will need to consult your host about this. Sometimes a reboot can also solve this problem.

PS OS error code 1 indicates that is most likely a permission error.

[Speysider]

Can't create/write to file '/tmp/#sql_58e6_0.MYI'

MySQL cannot write to this file. You need to talk to your host about this.