Errors in mysqli.php file

Quote

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?
chrisgwynne
New member
Posts
98
Joined
Fri Nov 11, 2016 7:33 am
Top

Re: Errors in mysqli.php file

Quote

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 Image Image Image Image Image

User avatar
grgr
Active Member
Posts
1328
Joined
Mon Mar 28, 2011 4:08 pm
Location - UK
Top

Re: Errors in mysqli.php file

Quote

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).
foobarac
New member
Posts
38
Joined
Fri Sep 21, 2018 9:46 pm
Top
Post Reply
Return to “General Support”
Who is online

Users browsing this forum: No registered users and 19 guests