Post by chrisgwynne » 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?

New member

Posts

Joined
Fri Nov 11, 2016 7:33 am

Post by grgr » 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.

-
Image Image Image
VIEW ALL EXTENSIONS * EXTENSION SUPPORT * WEBSITE * CUSTOM REQUESTS


User avatar
Active Member

Posts

Joined
Mon Mar 28, 2011 4:08 pm
Location - UK

Post by foobarac » 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).

New member

Posts

Joined
Fri Sep 21, 2018 9:46 pm
Who is online

Users browsing this forum: No registered users and 35 guests