vb.org Archive - Private Message Inbox << Database Error.

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)

- - Private Message Inbox << Database Error. (https://vborg.vbsupport.ru/showthread.php?t=247720)

Exsert

08-01-2010 12:12 PM

Private Message Inbox << Database Error.

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

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

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

kh99	08-01-2010 12:21 PM

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

08-01-2010 12:24 PM

Quote:

Originally Posted by kh99 (Post 2077600)

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	08-01-2010 12:29 PM

Quote:

Originally Posted by Exsert (Post 2077602)

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

08-01-2010 02:13 PM

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

08-02-2010 06:29 AM

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

08-02-2010 12:59 PM

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.

All times are GMT. The time now is 08:23 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01031 seconds Memory Usage 1,726KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (7)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.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/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: