The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
![]()
Alright, got some problem when my users click 'unread private messages'
![]() Code:
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 ![]() |
#2
|
|||
|
|||
![]()
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?
|
#3
|
|||
|
|||
![]() Quote:
I was thinking of just re-uploading the private.php file and how is the /tmp/ folder emptied safely? |
#4
|
|||
|
|||
![]()
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.
|
#5
|
|||
|
|||
![]()
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. |
#6
|
|||
|
|||
![]()
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. |
#7
|
||||
|
||||
![]()
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. |
![]() |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|