PHP Warning: Error while sending QUERY packet

[buildingblocks]

Hi

zen cart v 1.5.5e upgraded from 1.5.4 using a fresh zen cart file set

Server OS: Linux 2.6.32-673.26.1.lve1.4.18.el6.x86_64
Server Date: 06/10/2017 05:04:08
Server Up Time: Disabled/Unavailable
HTTP Server: Apache
PHP Version: 7.0.19 (Zend: 3.0.0)
PHP File Uploads: On
Upload Max Size: 2M
PHP Memory Limit: 128M
POST Max Size: 64M
Database: MySQL 5.5.5-10.1.24-MariaDB
Database Host: localhost (127.0.0.1)
Database Date: 06/10/2017 05:04:08
Database Data Size: 11,176 kB
Database Index Size: 3,358 kB
MySQL Slow Query Log Status: On
MySQL Slow Query Log File: sl-508-1-slow.log
MySQL Mode: NO_AUTO_CREATE_USER, NO_ENGINE_SUBSTITUTION


I found an error file in the log folder this morning. There don't appear to be any visible functional problems as yet. I haven't been able to replicate the error.

I am trying to understand the exact source of the error. Is it stemming from db/mysql/query_factory.php (which is a stock file) or is it something to do with ultimate seo mod which is this file, classes/query_cache.php:34] Or would the problem be further down in the over-rides?

The only difference between the stock query_cache.php file and ultimate seo file is at line 18

stock file

function __construct() {

ultimate seo file

function QueryCache() {

To see what would come up I did a google search using

PHP Warning: mysqli_data_seek() expects parameter 1 to be mysqli_result, boolean given in ***/includes/classes/query_cache.php on line 34

results came up with a few zen cart shops showing the same warning and the thing they seem to have in common looks to be ultimate seo.

Thanks for any input. :)


Below is the content of the debug log:


[10-Jun-2017 03:01:15 America/Denver] Request URI: /theProductURL-p-10460.html, IP address: 144.76.176.195
#1 mysqli_query() called at [/home/userID/public_html/includes/classes/db/mysql/query_factory.php:45]
#2 queryFactory->query() called at [/home/userID/public_html/includes/classes/db/mysql/query_factory.php:257]
#3 queryFactory->Execute() called at [/home/userID/public_html/includes/functions/functions_lookups.php:701]
#4 zen_get_show_product_switch() called at [/home/userID/public_html/includes/modules/pages/product_info/main_template_vars.php:160]
#5 require(/home/userID/public_html/includes/modules/pages/product_info/main_template_vars.php) called at [/home/userID/public_html/includes/templates/responsive_avonlee_contempo/common/tpl_main_page.php:197]
#6 require(/home/userID/public_html/includes/templates/responsive_avonlee_contempo/common/tpl_main_page.php) called at [/home/userID/public_html/index.php:97]

[10-Jun-2017 03:01:15 America/Denver] PHP Warning: Error while sending QUERY packet. PID=334154 in /home/userID/public_html/includes/classes/db/mysql/query_factory.php on line 45
[10-Jun-2017 03:01:15 America/Denver] Request URI: /theProductURL-p-10460.html, IP address: 144.76.176.195
#1 mysqli_data_seek() called at [/home/userID/public_html/includes/classes/query_cache.php:34]
#2 QueryCache->getFromCache() called at [/home/userID/public_html/includes/classes/db/mysql/query_factory.php:39]
#3 queryFactory->query() called at [/home/userID/public_html/includes/classes/db/mysql/query_factory.php:257]
#4 queryFactory->Execute() called at [/home/userID/public_html/includes/functions/functions_lookups.php:701]
#5 zen_get_show_product_switch() called at [/home/userID/public_html/includes/modules/pages/product_info/main_template_vars.php:161]
#6 require(/home/userID/public_html/includes/modules/pages/product_info/main_template_vars.php) called at [/home/userID/public_html/includes/templates/responsive_avonlee_contempo/common/tpl_main_page.php:197]
#7 require(/home/userID/public_html/includes/templates/responsive_avonlee_contempo/common/tpl_main_page.php) called at [/home/userID/public_html/index.php:97]

[10-Jun-2017 03:01:15 America/Denver] PHP Warning: mysqli_data_seek() expects parameter 1 to be mysqli_result, boolean given in /home/userID/public_html/includes/classes/query_cache.php on line 34
[10-Jun-2017 03:01:15 America/Denver] Request URI: /theProductURL-p-10460.html, IP address: 144.76.176.195
#1 mysqli_data_seek() called at [/home/userID/public_html/includes/classes/query_cache.php:34]
#2 QueryCache->getFromCache() called at [/home/userID/public_html/includes/classes/db/mysql/query_factory.php:39]
#3 queryFactory->query() called at [/home/userID/public_html/includes/classes/db/mysql/query_factory.php:257]
#4 queryFactory->Execute() called at [/home/userID/public_html/includes/functions/functions_lookups.php:701]
#5 zen_get_show_product_switch() called at [/home/userID/public_html/includes/modules/pages/product_info/main_template_vars.php:162]
#6 require(/home/userID/public_html/includes/modules/pages/product_info/main_template_vars.php) called at [/home/userID/public_html/includes/templates/responsive_avonlee_contempo/common/tpl_main_page.php:197]
#7 require(/home/userID/public_html/includes/templates/responsive_avonlee_contempo/common/tpl_main_page.php) called at [/home/userID/public_html/index.php:97]

[10-Jun-2017 03:01:15 America/Denver] PHP Warning: mysqli_data_seek() expects parameter 1 to be mysqli_result, boolean given in /home/userID/public_html/includes/classes/query_cache.php on line 34
[10-Jun-2017 03:01:15 America/Denver] Request URI: /theProductURL-p-10460.html, IP address: 144.76.176.195
#1 mysqli_data_seek() called at [/home/userID/public_html/includes/classes/query_cache.php:34]
#2 QueryCache->getFromCache() called at [/home/userID/public_html/includes/classes/db/mysql/query_factory.php:39]
#3 queryFactory->query() called at [/home/userID/public_html/includes/classes/db/mysql/query_factory.php:257]
#4 queryFactory->Execute() called at [/home/userID/public_html/includes/functions/functions_lookups.php:701]
#5 zen_get_show_product_switch() called at [/home/userID/public_html/includes/modules/pages/product_info/main_template_vars.php:163]
#6 require(/home/userID/public_html/includes/modules/pages/product_info/main_template_vars.php) called at [/home/userID/public_html/includes/templates/responsive_avonlee_contempo/common/tpl_main_page.php:197]
#7 require(/home/userID/public_html/includes/templates/responsive_avonlee_contempo/common/tpl_main_page.php) called at [/home/userID/public_html/index.php:97]

[10-Jun-2017 03:01:15 America/Denver] PHP Warning: mysqli_data_seek() expects parameter 1 to be mysqli_result, boolean given in /home/userID/public_html/includes/classes/query_cache.php on line 34
[10-Jun-2017 03:01:15 America/Denver] Request URI: /theProductURL-p-10460.html, IP address: 144.76.176.195
#1 mysqli_data_seek() called at [/home/userID/public_html/includes/classes/query_cache.php:34]
#2 QueryCache->getFromCache() called at [/home/userID/public_html/includes/classes/db/mysql/query_factory.php:39]
#3 queryFactory->query() called at [/home/userID/public_html/includes/classes/db/mysql/query_factory.php:257]
#4 queryFactory->Execute() called at [/home/userID/public_html/includes/functions/functions_lookups.php:701]
#5 zen_get_show_product_switch() called at [/home/userID/public_html/includes/modules/pages/product_info/main_template_vars.php:164]
#6 require(/home/userID/public_html/includes/modules/pages/product_info/main_template_vars.php) called at [/home/userID/public_html/includes/templates/responsive_avonlee_contempo/common/tpl_main_page.php:197]
#7 require(/home/userID/public_html/includes/templates/responsive_avonlee_contempo/common/tpl_main_page.php) called at [/home/userID/public_html/index.php:97]

[10-Jun-2017 03:01:15 America/Denver] PHP Warning: mysqli_data_seek() expects parameter 1 to be mysqli_result, boolean given in /home/userID/public_html/includes/classes/query_cache.php on line 34
[10-Jun-2017 03:01:15 America/Denver] Request URI: /theProductURL-p-10460.html, IP address: 144.76.176.195
#1 mysqli_data_seek() called at [/home/userID/public_html/includes/classes/query_cache.php:34]
#2 QueryCache->getFromCache() called at [/home/userID/public_html/includes/classes/db/mysql/query_factory.php:39]
#3 queryFactory->query() called at [/home/userID/public_html/includes/classes/db/mysql/query_factory.php:257]
#4 queryFactory->Execute() called at [/home/userID/public_html/includes/functions/functions_lookups.php:701]
#5 zen_get_show_product_switch() called at [/home/userID/public_html/includes/modules/pages/product_info/main_template_vars.php:165]
#6 require(/home/userID/public_html/includes/modules/pages/product_info/main_template_vars.php) called at [/home/userID/public_html/includes/templates/responsive_avonlee_contempo/common/tpl_main_page.php:197]
#7 require(/home/userID/public_html/includes/templates/responsive_avonlee_contempo/common/tpl_main_page.php) called at [/home/userID/public_html/index.php:97]

[10-Jun-2017 03:01:15 America/Denver] PHP Warning: mysqli_data_seek() expects parameter 1 to be mysqli_result, boolean given in /home/userID/public_html/includes/classes/query_cache.php on line 34
[10-Jun-2017 03:01:15 America/Denver] Request URI: /theProductURL-p-10460.html, IP address: 144.76.176.195
#1 mysqli_data_seek() called at [/home/userID/public_html/includes/classes/query_cache.php:34]
#2 QueryCache->getFromCache() called at [/home/userID/public_html/includes/classes/db/mysql/query_factory.php:39]
#3 queryFactory->query() called at [/home/userID/public_html/includes/classes/db/mysql/query_factory.php:257]
#4 queryFactory->Execute() called at [/home/userID/public_html/includes/functions/functions_lookups.php:701]
#5 zen_get_show_product_switch() called at [/home/userID/public_html/includes/modules/pages/product_info/main_template_vars.php:166]
#6 require(/home/userID/public_html/includes/modules/pages/product_info/main_template_vars.php) called at [/home/userID/public_html/includes/templates/responsive_avonlee_contempo/common/tpl_main_page.php:197]
#7 require(/home/userID/public_html/includes/templates/responsive_avonlee_contempo/common/tpl_main_page.php) called at [/home/userID/public_html/index.php:97]

[10-Jun-2017 03:01:15 America/Denver] PHP Warning: mysqli_data_seek() expects parameter 1 to be mysqli_result, boolean given in /home/userID/public_html/includes/classes/query_cache.php on line 34
[10-Jun-2017 03:01:15 America/Denver] Request URI: /theProductURL-p-10460.html, IP address: 144.76.176.195
#1 mysqli_data_seek() called at [/home/userID/public_html/includes/classes/query_cache.php:34]
#2 QueryCache->getFromCache() called at [/home/userID/public_html/includes/classes/db/mysql/query_factory.php:39]
#3 queryFactory->query() called at [/home/userID/public_html/includes/classes/db/mysql/query_factory.php:257]
#4 queryFactory->Execute() called at [/home/userID/public_html/includes/functions/functions_lookups.php:701]
#5 zen_get_show_product_switch() called at [/home/userID/public_html/includes/modules/pages/product_info/main_template_vars.php:167]
#6 require(/home/userID/public_html/includes/modules/pages/product_info/main_template_vars.php) called at [/home/userID/public_html/includes/templates/responsive_avonlee_contempo/common/tpl_main_page.php:197]
#7 require(/home/userID/public_html/includes/templates/responsive_avonlee_contempo/common/tpl_main_page.php) called at [/home/userID/public_html/index.php:97]

[10-Jun-2017 03:01:15 America/Denver] PHP Warning: mysqli_data_seek() expects parameter 1 to be mysqli_result, boolean given in /home/userID/public_html/includes/classes/query_cache.php on line 34
[10-Jun-2017 03:01:15 America/Denver] Request URI: /theProductURL-p-10460.html, IP address: 144.76.176.195
#1 mysqli_data_seek() called at [/home/userID/public_html/includes/classes/query_cache.php:34]
#2 QueryCache->getFromCache() called at [/home/userID/public_html/includes/classes/db/mysql/query_factory.php:39]
#3 queryFactory->query() called at [/home/userID/public_html/includes/classes/db/mysql/query_factory.php:257]
#4 queryFactory->Execute() called at [/home/userID/public_html/includes/functions/functions_lookups.php:701]
#5 zen_get_show_product_switch() called at [/home/userID/public_html/includes/modules/pages/product_info/main_template_vars.php:168]
#6 require(/home/userID/public_html/includes/modules/pages/product_info/main_template_vars.php) called at [/home/userID/public_html/includes/templates/responsive_avonlee_contempo/common/tpl_main_page.php:197]
#7 require(/home/userID/public_html/includes/templates/responsive_avonlee_contempo/common/tpl_main_page.php) called at [/home/userID/public_html/index.php:97]

[10-Jun-2017 03:01:15 America/Denver] PHP Warning: mysqli_data_seek() expects parameter 1 to be mysqli_result, boolean given in /home/userID/public_html/includes/classes/query_cache.php on line 34
[10-Jun-2017 03:01:15 America/Denver] Request URI: /theProductURL-p-10460.html, IP address: 144.76.176.195
#1 mysqli_data_seek() called at [/home/userID/public_html/includes/classes/query_cache.php:34]
#2 QueryCache->getFromCache() called at [/home/userID/public_html/includes/classes/db/mysql/query_factory.php:39]
#3 queryFactory->query() called at [/home/userID/public_html/includes/classes/db/mysql/query_factory.php:257]
#4 queryFactory->Execute() called at [/home/userID/public_html/includes/functions/functions_lookups.php:701]
#5 zen_get_show_product_switch() called at [/home/userID/public_html/includes/modules/pages/product_info/main_template_vars.php:169]
#6 require(/home/userID/public_html/includes/modules/pages/product_info/main_template_vars.php) called at [/home/userID/public_html/includes/templates/responsive_avonlee_contempo/common/tpl_main_page.php:197]
#7 require(/home/userID/public_html/includes/templates/responsive_avonlee_contempo/common/tpl_main_page.php) called at [/home/userID/public_html/index.php:97]

[10-Jun-2017 03:01:15 America/Denver] PHP Warning: mysqli_data_seek() expects parameter 1 to be mysqli_result, boolean given in /home/userID/public_html/includes/classes/query_cache.php on line 34
[10-Jun-2017 03:01:15 America/Denver] Request URI: /theProductURL-p-10460.html, IP address: 144.76.176.195
#1 mysqli_data_seek() called at [/home/userID/public_html/includes/classes/query_cache.php:34]
#2 QueryCache->getFromCache() called at [/home/userID/public_html/includes/classes/db/mysql/query_factory.php:39]
#3 queryFactory->query() called at [/home/userID/public_html/includes/classes/db/mysql/query_factory.php:257]
#4 queryFactory->Execute() called at [/home/userID/public_html/includes/functions/functions_lookups.php:701]
#5 zen_get_show_product_switch() called at [/home/userID/public_html/includes/modules/pages/product_info/main_template_vars.php:170]
#6 require(/home/userID/public_html/includes/modules/pages/product_info/main_template_vars.php) called at [/home/userID/public_html/includes/templates/responsive_avonlee_contempo/common/tpl_main_page.php:197]
#7 require(/home/userID/public_html/includes/templates/responsive_avonlee_contempo/common/tpl_main_page.php) called at [/home/userID/public_html/index.php:97]

[10-Jun-2017 03:01:15 America/Denver] PHP Warning: mysqli_data_seek() expects parameter 1 to be mysqli_result, boolean given in /home/userID/public_html/includes/classes/query_cache.php on line 34
[10-Jun-2017 03:01:15 America/Denver] Request URI: /theProductURL-p-10460.html, IP address: 144.76.176.195
#1 mysqli_data_seek() called at [/home/userID/public_html/includes/classes/query_cache.php:34]
#2 QueryCache->getFromCache() called at [/home/userID/public_html/includes/classes/db/mysql/query_factory.php:39]
#3 queryFactory->query() called at [/home/userID/public_html/includes/classes/db/mysql/query_factory.php:257]
#4 queryFactory->Execute() called at [/home/userID/public_html/includes/functions/functions_lookups.php:701]
#5 zen_get_show_product_switch() called at [/home/userID/public_html/includes/modules/pages/product_info/main_template_vars.php:171]
#6 require(/home/userID/public_html/includes/modules/pages/product_info/main_template_vars.php) called at [/home/userID/public_html/includes/templates/responsive_avonlee_contempo/common/tpl_main_page.php:197]
#7 require(/home/userID/public_html/includes/templates/responsive_avonlee_contempo/common/tpl_main_page.php) called at [/home/userID/public_html/index.php:97]

[10-Jun-2017 03:01:15 America/Denver] PHP Warning: mysqli_data_seek() expects parameter 1 to be mysqli_result, boolean given in /home/userID/public_html/includes/classes/query_cache.php on line 34
[10-Jun-2017 03:01:15 America/Denver] Request URI: /theProductURL-p-10460.html, IP address: 144.76.176.195
#1 mysqli_data_seek() called at [/home/userID/public_html/includes/classes/query_cache.php:34]
#2 QueryCache->getFromCache() called at [/home/userID/public_html/includes/classes/db/mysql/query_factory.php:39]
#3 queryFactory->query() called at [/home/userID/public_html/includes/classes/db/mysql/query_factory.php:257]
#4 queryFactory->Execute() called at [/home/userID/public_html/includes/functions/functions_lookups.php:701]
#5 zen_get_show_product_switch() called at [/home/userID/public_html/includes/modules/pages/product_info/main_template_vars.php:172]
#6 require(/home/userID/public_html/includes/modules/pages/product_info/main_template_vars.php) called at [/home/userID/public_html/includes/templates/responsive_avonlee_contempo/common/tpl_main_page.php:197]
#7 require(/home/userID/public_html/includes/templates/responsive_avonlee_contempo/common/tpl_main_page.php) called at [/home/userID/public_html/index.php:97]

[10-Jun-2017 03:01:15 America/Denver] PHP Warning: mysqli_data_seek() expects parameter 1 to be mysqli_result, boolean given in /home/userID/public_html/includes/classes/query_cache.php on line 34
[10-Jun-2017 03:01:16 America/Denver] Request URI: /theProductURL-p-10460.html, IP address: 144.76.176.195
#1 mysqli_data_seek() called at [/home/userID/public_html/includes/classes/query_cache.php:34]
#2 QueryCache->getFromCache() called at [/home/userID/public_html/includes/classes/db/mysql/query_factory.php:39]
#3 queryFactory->query() called at [/home/userID/public_html/includes/classes/db/mysql/query_factory.php:257]
#4 queryFactory->Execute() called at [/home/userID/public_html/includes/functions/functions_lookups.php:668]
#5 zen_get_products_allow_add_to_cart() called at [/home/userID/public_html/includes/functions/functions_general.php:1171]
#6 zen_get_buy_now_button() called at [/home/userID/public_html/includes/templates/responsive_avonlee_contempo/templates/tpl_product_info_display.php:134]
#7 require(/home/userID/public_html/includes/templates/responsive_avonlee_contempo/templates/tpl_product_info_display.php) called at [/home/userID/public_html/includes/modules/pages/product_info/main_template_vars.php:178]
#8 require(/home/userID/public_html/includes/modules/pages/product_info/main_template_vars.php) called at [/home/userID/public_html/includes/templates/responsive_avonlee_contempo/common/tpl_main_page.php:197]
#9 require(/home/userID/public_html/includes/templates/responsive_avonlee_contempo/common/tpl_main_page.php) called at [/home/userID/public_html/index.php:97]

[10-Jun-2017 03:01:16 America/Denver] PHP Warning: mysqli_data_seek() expects parameter 1 to be mysqli_result, boolean given in /home/userID/public_html/includes/classes/query_cache.php on line 34

[mc12345678]

Typically the issue first encountered in a mydebug file is the one that sparks all of the remaining issues, which in this case is the related to:

PHP Warning: Error while sending QUERY packet

And supposedly is related to the size of data being sent to the database for processing... but... as of php 7.0 and the php docs, a class' constructor should be __construct(... not CLASS_NAME(... where CLASS_NAME is the name of the class as provided at the declaration of the class...

Basically it looks in part like there was an error (warning) early on in processing that didn't stop execution, but also didn't provide the data that was expected and therefore the returned data (possibly shortened or otherwise incorrect) when fed to another function also was or had an error that generated the associated warning(s). Not sure though the relationship between the SEO mod not being uipdated to support php 7.0 and the results of searching the initial warning as it relates to the amount of data fed to the database for processing if there even is a relationship...

[lat9]

I've seen those errors being logged when a site's webhost is having "difficulties" with their database servers.

[buildingblocks]

Thanks mc12345678. Not sure what to do with this.

lat9 is this something you would approach a webhost with? My experience is often a host will tell me it's a problem with zen cart until it's proved otherwise. In this case I don't know which. The seo mod has been on this site for a number of years so to take it off would mess up their links in search results. I don't think they'll be too keen on it.

[DrByte]

I agree. The "Error while sending QUERY packet" problem is the real issue.


When that happens, no query response is returned, but then the caching system is being asked to process the returned query response, and since it isn't a valid query response, it's giving you that "mysqli_data_seek() expects parameter 1 to be mysqli_result, boolean given" reaction.

It's caused by the database being non-responsive for "some" reason ... could be maintenance, could be overload of traffic, could be misconfiguration, could be hard-drive failures on the server, could be dozens of things. None of them Zen Cart. None of them you. None of them in your control.

If it's happening all the time, talk to your host and show them the logs of it happening at multiple times every day. Show them the pattern of it being chronic.
If they don't know about it, they can't investigate.
If they won't "own" fixing it, get them to move your site to a more reliable server. (at no cost to you).
If they still can't/won't fix it, find another host.

In the meantime, take daily backups of your database. And be sure to have a backup of all the files you've got on the server.

[buildingblocks]

Thanks for your input lat9 :) DrByte thanks for your comment. Just what I needed to know.