Go Back   vb.org Archive > vBulletin 4 Discussion > vB4 Programming Discussions
  #1  
Old 05-03-2017, 06:45 PM
RichieBoy67's Avatar
RichieBoy67 RichieBoy67 is offline
 
Join Date: Apr 2004
Location: CT - Down in a hole..
Posts: 3,057
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Misc Database Error

Does anyone have any idea as to what this is?

Database error in vBulletin 4.2.5 Beta 4:

Invalid SQL:
SELECT dateline, userid FROM customavatar WHERE userid = 0;

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Wednesday, May 3rd 2017 @ 08:38:15 PM
Error Date : Wednesday, May 3rd 2017 @ 08:39:34 PM
Script : #############/attachment.php?attachmentid=8269&d=1404496272
Referrer :
IP Address : ###########
Username : Unregistered
Classname : vB_Database_MySQLi
MySQL Version :
Server : ###########
User Agent :

Stack Trace:

#0 vB_Database->halt() called in [path]/includes/class_core.php on line 1403
#1 vB_Database_MySQLi->execute_query() called in [path]/includes/class_core.php on line 505
#2 vB_Database->query_first() called in [path]/includes/class_bootstrap.php(433) : eval()'d code on line 96
#3 eval() called in [path]/includes/class_bootstrap.php on line 433
#4 vB_Bootstrap->process_templates() called in [path]/includes/class_core.php on line 4398
#5 vB_Template->__construct() called in [path]/includes/class_core.php on line 4356
#6 vB_Template::create() called in [path]/includes/functions.php on line 3139
#7 construct_navbits() called in [path]/500.php on line 44
Reply With Quote
  #2  
Old 05-03-2017, 07:03 PM
Dave Dave is offline
 
Join Date: May 2010
Posts: 2,583
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Sounds to me like a timeout. Check the wait_timeout and/or max_allowed_packet setting in your MySQL settings file.

--
It's rather odd that it tried to select an entry from the customavatar table with the userid 0.
Reply With Quote
  #3  
Old 05-03-2017, 07:56 PM
RichieBoy67's Avatar
RichieBoy67 RichieBoy67 is offline
 
Join Date: Apr 2004
Location: CT - Down in a hole..
Posts: 3,057
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

The time out is set ok as is the max packet. They are both set pretty high.

I get these very random errors on occasion so they are not a huge issue but this is still bugging me...

The only changes I have made recently that could possibly be related is the addition of redis cache to my server and I also installed DBtech optimization. Everything else is running fine.. I got 2 of these errors yesterday and one today and traffic has not really been a factor at around 1,600 uniques.. load should not be an issue at all..

Thanks
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 07:47 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.06523 seconds
  • Memory Usage 2,168KB
  • 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)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (3)post_thanks_box
  • (3)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (3)post_thanks_postbit_info
  • (3)postbit
  • (3)postbit_onlinestatus
  • (3)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