Page 1 of 1

Errors in mysqli.php file

Posted: Thu May 23, 2019 3:29 pm
by chrisgwynne
Using version 2.3.0.2 - not added or altered any extensions or modifications in a long while.

I keep getting this in my errorlog

Code: Select all

  thrown in /home/xxx/public_html/system/library/db/mysqli.php on line 40
[22-May-2019 16:03:29 UTC] PHP Warning:  Error while sending QUERY packet. PID=3569 in /home/xxx/public_html/system/library/db/mysqli.php on line 18
[22-May-2019 16:03:29 UTC] PHP Fatal error:  Uncaught exception 'Exception' with message 'Error: MySQL server has gone away<br />Error No: 2006<br />SELECT * FROM oc_setting WHERE `code` = 'timezone'' in /home/xxx/public_html/system/library/db/mysqli.php:40
Stack trace:
#0 /home/xxx/public_html/system/storage/modification/system/library/db.php(17): DB\MySQLi->query('SELECT * FROM o...')
#1 /home/xxx/public_html/vqmod/vqcache/vq2-system_framework.php(161): DB->query('SELECT * FROM `...')
#2 /home/xxx/public_html/vqmod/vqcache/vq2-system_startup.php(124): require_once('/home/melodyjan...')
#3 /home/xxx/public_html/index.php(21): start('catalog')
Any guidance on what could be wrong?

Re: Errors in mysqli.php file

Posted: Thu May 23, 2019 9:01 pm
by grgr
The clue is in the error....

Code: Select all

Error: MySQL server has gone away
It is a hosting issue.

Re: Errors in mysqli.php file

Posted: Mon Jun 01, 2020 9:21 am
by foobarac
Guys, it's not always the Host servers fault in this case.

The DB transaction is inflight so if you have modules/processes that do other things during the process i.e send emails out to confirm an order or confirm the opening of an account, and this hangs - then you are going to get the "PHP Warning: mysqli::query(): MySQL server has gone away" in your error logs.

However the problem could be that your SMTP server is hanging (which was my problem).