Private Message Inbox << Database Error.

[Exsert]

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

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]

Originally Posted by 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?

possibly :P

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

[kh99]

Originally Posted by Exsert

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.