PDA

View Full Version : Misc Database Error


RichieBoy67
05-03-2017, 06:45 PM
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

Dave
05-03-2017, 07:03 PM
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.

RichieBoy67
05-03-2017, 07:56 PM
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