Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 08-01-2010, 12:12 PM
Exsert Exsert is offline
 
Join Date: Sep 2009
Posts: 33
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Private Message Inbox << Database Error.

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
Reply With Quote
  #2  
Old 08-01-2010, 12:21 PM
kh99 kh99 is offline
 
Join Date: Aug 2009
Location: Maine
Posts: 13,185
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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?
Reply With Quote
  #3  
Old 08-01-2010, 12:24 PM
Exsert Exsert is offline
 
Join Date: Sep 2009
Posts: 33
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by kh99 View Post
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?
Reply With Quote
  #4  
Old 08-01-2010, 12:29 PM
kh99 kh99 is offline
 
Join Date: Aug 2009
Location: Maine
Posts: 13,185
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Exsert View Post
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.
Reply With Quote
  #5  
Old 08-01-2010, 02:13 PM
Exsert Exsert is offline
 
Join Date: Sep 2009
Posts: 33
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
  #6  
Old 08-02-2010, 06:29 AM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
  #7  
Old 08-02-2010, 12:59 PM
Speysider's Avatar
Speysider Speysider is offline
 
Join Date: Apr 2009
Posts: 1,029
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 06:58 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.03968 seconds
  • Memory Usage 2,221KB
  • Queries Executed 13 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)bbcode_code
  • (2)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (7)post_thanks_box
  • (7)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (7)post_thanks_postbit_info
  • (7)postbit
  • (7)postbit_onlinestatus
  • (7)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete