OpenCart Community

Posted: **Thu May 23, 2019 3:29 pm**

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?

Posted: **Thu May 23, 2019 9:01 pm**

The clue is in the error....

Code: Select all

Error: MySQL server has gone away

It is a hosting issue.

Posted: **Mon Jun 01, 2020 9:21 am**

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).

OpenCart Community

Errors in mysqli.php file

Errors in mysqli.php file

Re: Errors in mysqli.php file

Re: Errors in mysqli.php file