New error log message

[Bruce1952]

Hi All,

Running on a linux server (zencart version 1.58a) with php version 8.1

This is the error message that I am getting:

[06-Mar-2025 00:42:18 Australia/Sydney] Request URI: /index.php?main_page=search_result&keyword=shindaiwa%20757%20bucking%20spike, IP address: 180.150.80.181, Language id 1
#0 [internal function]: zen_debug_error_handler()
#1 /includes/classes/db/mysql/query_factory.php(667): trigger_error()
#2 /includes/classes/db/mysql/query_factory.php(634): queryFactory->show_error()
#3 /includes/classes/db/mysql/query_factory.php(275): queryFactory->set_error()
#4 /includes/classes/split_page_results.php(105): queryFactory->Execute()
#5 /includes/modules/pages/search_result/header_php.php(459): splitPageResults->__construct()
#6 /index.php(35): require('/home/xxxx...')
--> PHP Fatal error: 2006:MySQL server has gone away :: select count(distinct p.products_id) as total FROM (products p LEFT JOIN manufacturers m USING(manufacturers_id), products_description pd, categories c, products_to_categories p2c ) LEFT JOIN meta_tags_products_description mtpd ON (mtpd.products_id= p2c.products_id AND mtpd.language_id = 1) WHERE (p.products_status = 1 AND p.products_id = pd.products_id AND pd.language_id = 1 AND p.products_id = p2c.products_id AND p2c.categories_id = c.categories_id AND ( ( pd.products_name LIKE '%shindaiwa%' OR p.products_model LIKE '%shindaiwa%' OR m.manufacturers_name LIKE '%shindaiwa%' OR mtpd.metatags_keywords LIKE '%shindaiwa%' OR mtpd.metatags_description LIKE '%shindaiwa%') AND ( pd.products_name LIKE '%757%' OR p.products_model LIKE '%757%' OR m.manufacturers_name LIKE '%757%' OR mtpd.metatags_keywords LIKE '%757%' OR mtpd.metatags_description LIKE '%757%') AND ( pd.products_name LIKE '%bucking%' OR p.products_model LIKE '%bucking%' OR m.manufacturers_name LIKE '%bucking%' OR mtpd.metatags_keywords LIKE '%bucking%' OR mtpd.metatags_description LIKE '%bucking%') AND ( pd.products_name LIKE '%spike%' OR p.products_model LIKE '%spike%' OR m.manufacturers_name LIKE '%spike%' OR mtpd.metatags_keywords LIKE '%spike%' OR mtpd.metatags_description LIKE '%spike%') )) ==> (as called by) /includes/classes/split_page_results.php on line 105 <== in /includes/classes/db/mysql/query_factory.php on line 667.

Any help in trying to correct this would be appreciated because it is costing me quite a lot of money to get these logs fixed but they keep coming back with errors each time something is done.

[royaldave]

Hi All,

Running on a linux server (zencart version 1.58a) with php version 8.1

This is the error message that I am getting:

[06-Mar-2025 00:42:18 Australia/Sydney] Request URI: /index.php?main_page=search_result&keyword=shindaiwa%20757%20bucking%20spike, IP address: 180.150.80.181, Language id 1
#0 [internal function]: zen_debug_error_handler()
#1 /includes/classes/db/mysql/query_factory.php(667): trigger_error()
#2 /includes/classes/db/mysql/query_factory.php(634): queryFactory->show_error()
#3 /includes/classes/db/mysql/query_factory.php(275): queryFactory->set_error()
#4 /includes/classes/split_page_results.php(105): queryFactory->Execute()
#5 /includes/modules/pages/search_result/header_php.php(459): splitPageResults->__construct()
#6 /index.php(35): require('/home/xxxx...')
--> PHP Fatal error: 2006:MySQL server has gone away :: select count(distinct p.products_id) as total FROM (products p LEFT JOIN manufacturers m USING(manufacturers_id), products_description pd, categories c, products_to_categories p2c ) LEFT JOIN meta_tags_products_description mtpd ON (mtpd.products_id= p2c.products_id AND mtpd.language_id = 1) WHERE (p.products_status = 1 AND p.products_id = pd.products_id AND pd.language_id = 1 AND p.products_id = p2c.products_id AND p2c.categories_id = c.categories_id AND ( ( pd.products_name LIKE '%shindaiwa%' OR p.products_model LIKE '%shindaiwa%' OR m.manufacturers_name LIKE '%shindaiwa%' OR mtpd.metatags_keywords LIKE '%shindaiwa%' OR mtpd.metatags_description LIKE '%shindaiwa%') AND ( pd.products_name LIKE '%757%' OR p.products_model LIKE '%757%' OR m.manufacturers_name LIKE '%757%' OR mtpd.metatags_keywords LIKE '%757%' OR mtpd.metatags_description LIKE '%757%') AND ( pd.products_name LIKE '%bucking%' OR p.products_model LIKE '%bucking%' OR m.manufacturers_name LIKE '%bucking%' OR mtpd.metatags_keywords LIKE '%bucking%' OR mtpd.metatags_description LIKE '%bucking%') AND ( pd.products_name LIKE '%spike%' OR p.products_model LIKE '%spike%' OR m.manufacturers_name LIKE '%spike%' OR mtpd.metatags_keywords LIKE '%spike%' OR mtpd.metatags_description LIKE '%spike%') )) ==> (as called by) /includes/classes/split_page_results.php on line 105 <== in /includes/classes/db/mysql/query_factory.php on line 667.

Any help in trying to correct this would be appreciated because it is costing me quite a lot of money to get these logs fixed but they keep coming back with errors each time something is done.

I suspect the key bit of this error message is 'MySQL server has gone away'.

I'd google that and see what responses are relevant to your situation.

[barco57]

if the "PHP Fatal error: 2006:MySQL server has gone away" happens a lot then it is the "my server sucks error". if it only happens once and a while, then your server may have an issue or only sucks a little bit...