Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
  #1  
Old 09-17-2009, 10:37 AM
Eruantien Eruantien is offline
 
Join Date: Jan 2009
Posts: 187
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Keeping getting this notification...

...and I don't know what it is or how to fix it. This is sent via e-mail relating to my forums. Mods, if there is something that should not included- please edit it out.

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 = 84
                                       AND userlist.type = 'buddy'
                                       AND userlist.friend = 'yes'

                               ORDER BY RAND()
                               LIMIT 0, 1;

MySQL Error   : Got error 28 from storage engine
Error Number  : 1030
Request Date  : Thursday, September 17th 2009 @ 05:24:48 AM
Error Date    : Thursday, September 17th 2009 @ 05:24:48 AM
Script        : http://www.loremaster.org/member.php?action=getinfo&u=84
Referrer      :
IP Address    : XXX.XXX.XXX.XXX
Username      : Unregistered
Classname     : vB_Database
MySQL Version :
Reply With Quote
  #2  
Old 09-17-2009, 11:13 AM
ChopSuey ChopSuey is offline
 
Join Date: Jun 2009
Location: Alaska
Posts: 2,140
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Looks like its something with the avatars. Maybe an avatar mod?
Maybe edit out your IP address man.
Reply With Quote
  #3  
Old 09-17-2009, 11:21 AM
Eruantien Eruantien is offline
 
Join Date: Jan 2009
Posts: 187
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I'm not too sure. I don't believe I have an avatar mod and the errors keep coming from 'unregistered' sources.
Reply With Quote
  #4  
Old 09-17-2009, 12:58 PM
HMBeaty's Avatar
HMBeaty HMBeaty is offline
 
Join Date: Sep 2005
Posts: 4,141
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

This error comes when MySQL doesn't have any free hard disk space to write to. Are you saving your avatars/profile pictures/etc to database or filesystem? If they are in database, I suggest moving them to the filesystem
Reply With Quote
  #5  
Old 09-17-2009, 01:01 PM
Eruantien Eruantien is offline
 
Join Date: Jan 2009
Posts: 187
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Is this done via the avatar section the ACP? Thanks to everyone for the assistance, by the way.
Reply With Quote
  #6  
Old 09-17-2009, 01:08 PM
HMBeaty's Avatar
HMBeaty HMBeaty is offline
 
Join Date: Sep 2005
Posts: 4,141
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Avatars - AdminCP > Avatars > User Picture Storage Type
Albums - AdminCP > User Albums > Album Picture Storage Type
Attachments - AdminCP > Attachments > Attachment Storage Type
Social Groups - AdminCP > Social Groups > Social Group Icon Storage Type
Reply With Quote
  #7  
Old 09-17-2009, 01:32 PM
Eruantien Eruantien is offline
 
Join Date: Jan 2009
Posts: 187
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

From a fellow vet, many thanks HMBeaty!
Reply With Quote
  #8  
Old 09-17-2009, 01:46 PM
HMBeaty's Avatar
HMBeaty HMBeaty is offline
 
Join Date: Sep 2005
Posts: 4,141
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

No problem
Reply With Quote
Reply

Thread Tools
Display Modes

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 12:33 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04377 seconds
  • Memory Usage 2,220KB
  • Queries Executed 11 (?)
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
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (8)post_thanks_box
  • (8)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (8)post_thanks_postbit_info
  • (8)postbit
  • (8)postbit_onlinestatus
  • (8)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_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