vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   Database Error (https://vborg.vbsupport.ru/showthread.php?t=232724)

King Justice 01-10-2010 05:28 PM
Database Error
 
Please assist with this database error, is causing my forum not to function properly. New users can't register, people can't access PMs, and people can't view profiles...

Here it is:

PHP Code:
Database error in vBulletin 3.8.4:

Invalid SQL:

                SELECT user.*, (user.options & 512) AS invisible , avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustom, customavatar.dateline AS avatardateline, customavatar.filedata_thumb, customavatar.height AS avheight, customavatar.width AS avwidth, customavatar.width_thumb AS avwidth_thumb, customavatar.height_thumb AS avheight_thumb
                    
                FROM userlist AS userlist
                INNER JOIN user AS user ON (user.userid = userlist.relationid)
                LEFT JOIN avatar AS avatar ON (avatar.avatarid = user.avatarid)
                LEFT JOIN customavatar AS customavatar ON (customavatar.userid = user.userid) 
                
                WHERE userlist.userid = 16236
                    AND userlist.type = 'buddy'
                    AND userlist.friend = 'yes'
                    
                ORDER BY RAND()
                LIMIT 0, 8;

MySQL Error   : Can't create/write to file '/tmp/#sql_10c6_0.MYI' (Errcode: 13)
Error Number  : 1
Request Date  : Sunday, January 10th 2010 @ 02:24:42 PM
Error Date    : Sunday, January 10th 2010 @ 02:24:42 PM
Script        : http://www.egamingsupply.com/forum/member.php?action=getinfo&u=16236
Referrer      : http://www.egamingsupply.com/forum/index.php
IP Address    : 68.39.148.100
Username      : Monarch
Classname     : vB_Database
MySQL Version : 5.0.51a-community 

kh99 01-10-2010 05:36 PM
I'm not an expert, but my guess would be that you've run out of disk space for /tmp. So I guess if that's not something you know how to check or deal with yourself you'd need to contact whoever does server-type stuff for you.

King Justice 01-20-2010 10:05 PM
The tmp directory is empty. And it is 777 permissions. How do I fix this? I have more than enough disk space for the site...

kh99 01-21-2010 01:36 AM
Well, the directory could be empty but the partition full. I think "df" command shows what's going on with disk space. If there's no /tmp in the "mounted on" column then look at the row for / (unless it's linked somewhere else?)

Or maybe it's something else. Anyone?

Lynne 01-21-2010 03:07 AM
See this - http://dev.mysql.com/doc/refman/5.0/...ot-create.html It sounds to me like kh99 is correct about there being no space left. It's either that or a permissions thing.


All times are GMT. The time now is 02:28 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.01111 seconds
  • Memory Usage 1,735KB
  • 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_php_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (5)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