Error Log message

[Bruce1952]

Hi All,

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

I am getting this error message which has just started today for some reason. I have not been getting any error logs for a couple of days.

Anyway this is the message that is showing in the log.

[15-Mar-2025 10:20:57 Australia/Sydney] Request URI: /index.php?main_page=index%27&manufacturers_id=157, IP address: 103.108.6.78, 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/xxxx...')
#6 /includes/templates/bootstrap/templates/tpl_index_product_list.php(239): require('/home/xxxx')
#7 /includes/modules/pages/index/main_template_vars.php(231): require('/home/xxxx')
#8 /includes/templates/bootstrap/common/tpl_main_page.php(233): require('/home/xxxx')
#9 /index.php(94): require('/home/xxxx')
--> 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.

The database was supposed to be fixed by running the database fix module on this site.

Note that I have not made any changes to the site except for the fix I was told to do for the Free shipping options module (which is no disabled) but even after that change I did not get errors.

I now have about 66 error logs that have shown up.

Any help would be appreciated on how this can be correcred.

[royaldave]

Hi All,

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

I am getting this error message which has just started today for some reason. I have not been getting any error logs for a couple of days.

Anyway this is the message that is showing in the log.

[15-Mar-2025 10:20:57 Australia/Sydney] Request URI: /index.php?main_page=index%27&manufacturers_id=157, IP address: 103.108.6.78, 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/xxxx...')
#6 /includes/templates/bootstrap/templates/tpl_index_product_list.php(239): require('/home/xxxx')
#7 /includes/modules/pages/index/main_template_vars.php(231): require('/home/xxxx')
#8 /includes/templates/bootstrap/common/tpl_main_page.php(233): require('/home/xxxx')
#9 /index.php(94): require('/home/xxxx')
--> 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.

The database was supposed to be fixed by running the database fix module on this site.

Note that I have not made any changes to the site except for the fix I was told to do for the Free shipping options module (which is no disabled) but even after that change I did not get errors.

I now have about 66 error logs that have shown up.

Any help would be appreciated on how this can be correcred.

You posted a similar error on another thread, the key again being ':MySQL server has gone away'.

This is a server issue and shouldn't be related to fixes you mention.

[Bruce1952]

I received this reply from Godaddy:

It looks like you don't have the necessary privileges to change this setting directly through phpMyAdmin due to shared hosting restrictions. Instead, try adding the following line to your application's database connection file, often found in your project's configuration files:

```php
ini_set('mysql.connect_timeout', 300);
ini_set('default_socket_timeout', 300);
```

This code attempts to increase the timeout duration for your database connection. Can you locate and adjust your database connection file with this code?

What file do I need to adjust please as I have no idea where it would be located.

[Bruce1952]

Hi All,

It only took a bit over a hour but got Godaddy to run the SQL command and now errors as yet but will know more in 24 hours as I have cleared all errors and will see what happens now.

Thanks for your assistance with this I will keep my fingers and everything else crossed that it is fixed.