MSQL Error

[Bruce1952]

Hi All,

Running version 1.58a on a linux server running PHP Version: 8.1.31

Template Bootstrap Version 3.7.4

CKEditor version 5

Image Handler version 5

I have not been getting any error logs for a while on the live site and was wanting to confirm that this message is just related to the MYSQL that I had in the past where it was saying MySQL server has gone away. Meaning that the MYSQL server was not contactable causing all the file errors shown in the error log.

[20-May-2025 16:14:50 Australia/Sydney] Request URI: /index.php?main_page=index&manufacturers_id=2&sort=20a&filter_id=178&action=multi ple_products_add_product, IP address: 114.77.145.119, 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(324): queryFactory->set_error()
#4 /includes/modules/bootstrap/centerboxes/new_products.php(49): queryFactory->ExecuteRandomMulti()
#5 /includes/templates/bootstrap/centerboxes/tpl_modules_whats_new.php(14): require('/home/a1ntacdk3...')
#6 /includes/templates/bootstrap/templates/tpl_index_product_list.php(239): require('/home/a1ntacdk3...')
#7 /includes/modules/pages/index/main_template_vars.php(231): require('/home/a1ntacdk3...')
#8 /includes/templates/bootstrap/common/tpl_main_page.php(233): require('/home/a1ntacdk3...')
#9 /index.php(94): require('/home/a1ntacdk3...')
--> PHP Fatal error: 2006:MySQL server has gone away :: SELECT DISTINCT p.products_id, p.products_image, pd.products_name, p.products_price, p.master_categories_id
FROM products p, products_description pd
WHERE p.products_id = pd.products_id
AND pd.language_id = 1
AND p.products_status = 1 ==> (as called by) /includes/modules/bootstrap/centerboxes/new_products.php on line 49 <== in /includes/classes/db/mysql/query_factory.php on line 667.

Any assistance would be appreciated if I need to do anything or not with files.

[royaldave]

Hi All,

Running version 1.58a on a linux server running PHP Version: 8.1.31

Template Bootstrap Version 3.7.4

CKEditor version 5

Image Handler version 5

I have not been getting any error logs for a while on the live site and was wanting to confirm that this message is just related to the MYSQL that I had in the past where it was saying MySQL server has gone away. Meaning that the MYSQL server was not contactable causing all the file errors shown in the error log.

[20-May-2025 16:14:50 Australia/Sydney] Request URI: /index.php?main_page=index&manufacturers_id=2&sort=20a&filter_id=178&action=multi ple_products_add_product, IP address: 114.77.145.119, 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(324): queryFactory->set_error()
#4 /includes/modules/bootstrap/centerboxes/new_products.php(49): queryFactory->ExecuteRandomMulti()
#5 /includes/templates/bootstrap/centerboxes/tpl_modules_whats_new.php(14): require('/home/a1ntacdk3...')
#6 /includes/templates/bootstrap/templates/tpl_index_product_list.php(239): require('/home/a1ntacdk3...')
#7 /includes/modules/pages/index/main_template_vars.php(231): require('/home/a1ntacdk3...')
#8 /includes/templates/bootstrap/common/tpl_main_page.php(233): require('/home/a1ntacdk3...')
#9 /index.php(94): require('/home/a1ntacdk3...')
--> PHP Fatal error: 2006:MySQL server has gone away :: SELECT DISTINCT p.products_id, p.products_image, pd.products_name, p.products_price, p.master_categories_id
FROM products p, products_description pd
WHERE p.products_id = pd.products_id
AND pd.language_id = 1
AND p.products_status = 1 ==> (as called by) /includes/modules/bootstrap/centerboxes/new_products.php on line 49 <== in /includes/classes/db/mysql/query_factory.php on line 667.

Any assistance would be appreciated if I need to do anything or not with files.

Yes, its the same error - whether or not its caused by the same issue I can't comment because we don't know what you've done to rectify.

[Bruce1952]

Yes, its the same error - whether or not its caused by the same issue I can't comment because we don't know what you've done to rectify.

Have not done anything at this stage. Just want to be pointed in the right direction to try to fix it or not.

I was assuming that it is all related to not being able to connect the the MYSQL server

[mprough]

Have not done anything at this stage. Just want to be pointed in the right direction to try to fix it or not.

I was assuming that it is all related to not being able to connect the the MYSQL server

Most likely too many queries for your hoster's limits.

[Bruce1952]

Most likely too many queries for your hoster's limits.

Thanks for what I thought it might be it is appreciated.