AbanteCart Community

Shopping Cart Operations => Support => Topic started by: HADY on August 31, 2020, 05:54:53 AM

Title: contact administrator of this web site to increase 'Connection Timeout
Post by: HADY on August 31, 2020, 05:54:53 AM: H!!

How to fix this issue p[lease??

Request Timeout
This request takes too long to process, it is timed out by the server. If it should not be timed out, please contact administrator of this web site to increase 'Connection Timeout

Thanks
regards
Title: Re: contact administrator of this web site to increase 'Connection Timeout
Post by: Basara on August 31, 2020, 05:56:14 AM: What is the page you working on?
Please check for latest errors in your AbanteCart and server error logs
Title: Re: contact administrator of this web site to increase 'Connection Timeout
Post by: HADY on August 31, 2020, 06:14:18 AM: Quote from: Basara on August 31, 2020, 05:56:14 AM
What is the page you working on?
Please check for latest errors in your AbanteCart and server error logs

this is when I am trying to refresh website panel dashboard after cleaning the (cache memory).
Title: Re: contact administrator of this web site to increase 'Connection Timeout
Post by: HADY on August 31, 2020, 06:29:57 AM: here is the errors log :

2020-08-31 13:20:52 - warning: AbanteCart core v.1.2.16 Use of undefined constant CACHE_DRIVER - assumed 'CACHE_DRIVER' (this will throw an Error in a future version of PHP) in /home/public_html/core/helper/system_check.php on line 126
2020-08-31 13:20:57 - warning: AbanteCart core v.1.2.16 mkdir(): File exists in /home/public_html/core/helper/utils.php on line 1306
2020-08-31 13:20:57 - App Warning: AbanteCart core v.1.2.16 Cannot to create directory /home/public_html/image//thumbnails/18/8d. Please check permissions for /home/public_html/image/ in /home/public_html/core/helper/utils.php on line 1311
2020-08-31 13:22:03 - warning: AbanteCart core v.1.2.16 Use of undefined constant CACHE_DRIVER - assumed 'CACHE_DRIVER' (this will throw an Error in a future version of PHP) in /home/public_html/core/helper/system_check.php on line 126
2020-08-31 13:23:04 - database error: AbanteCart core v.1.2.16 SQL Error: MySQL server has gone away
Error No: 2006
SQL: SELECT p.product_id,
p.subtract,
SUM(COALESCE(pov.subtract,0)) as option_subtract,
p.quantity,
SUM(COALESCE(pov.quantity,0)) as option_quantity
FROM ac_products p
LEFT JOIN ac_product_options po
ON (po.product_id = p.product_id AND po.status = 1)
LEFT JOIN ac_product_option_values pov
ON (po.product_option_id = pov.product_option_id)
WHERE p.product_id IN (935, 936, 937, 938, 939, 934, 932, 933, 923, 924, 925, 926, 927, 928, 929, 930, 909, 910, 911, 912, 913, 914, 891, 882, 883, 884, 879, 880, 881, 860, 861, 862)
GROUP BY p.product_id
PHP call stack:
#0 /home/public_html/core/lib/db.php:100
#1 /home/public_html/core/engine/extensions.php:1176
#2 /home/public_html/core/engine/extensions.php:1127
#3 /home/public_html/core/lib/db.php:67
#4 /home/public_html/storefront/model/catalog/product.php:133
#5 /home/public_html/storefront/controller/blocks/featured.php:63
#6 /home/public_html/core/engine/dispatcher.php:293
#7 /home/public_html/core/engine/dispatcher.php:328
#8 /home/public_html/core/engine/dispatcher.php:328
#9 /home/public_html/core/engine/page.php:108
#10 /home/public_html/core/engine/router.php:176
#11 /home/public_html/core/engine/router.php:80
#12 /home/public_html/index.php:94
in /home/public_html/core/database/amysqli.php on line 119
2020-08-31 13:23:30 - warning: AbanteCart core v.1.2.16 Use of undefined constant CACHE_DRIVER - assumed 'CACHE_DRIVER' (this will throw an Error in a future version of PHP) in /home/public_html/core/helper/system_check.php on line 126
Title: Re: contact administrator of this web site to increase 'Connection Timeout
Post by: abolabo on September 01, 2020, 05:48:56 AM: Quote from: HADY on August 31, 2020, 06:29:57 AM
here is the errors log :

2020-08-31 13:20:52 - warning: AbanteCart core v.1.2.16 Use of undefined constant CACHE_DRIVER - assumed 'CACHE_DRIVER' (this will throw an Error in a future version of PHP) in /home/public_html/core/helper/system_check.php on line 126
2020-08-31 13:20:57 - warning: AbanteCart core v.1.2.16 mkdir(): File exists in /home/public_html/core/helper/utils.php on line 1306
2020-08-31 13:20:57 - App Warning: AbanteCart core v.1.2.16 Cannot to create directory /home/public_html/image//thumbnails/18/8d. Please check permissions for /home/public_html/image/ in /home/public_html/core/helper/utils.php on line 1311
2020-08-31 13:22:03 - warning: AbanteCart core v.1.2.16 Use of undefined constant CACHE_DRIVER - assumed 'CACHE_DRIVER' (this will throw an Error in a future version of PHP) in /home/public_html/core/helper/system_check.php on line 126
2020-08-31 13:23:04 - database error: AbanteCart core v.1.2.16 SQL Error: MySQL server has gone away
Error No: 2006
SQL: SELECT p.product_id,
p.subtract,
SUM(COALESCE(pov.subtract,0)) as option_subtract,
p.quantity,
SUM(COALESCE(pov.quantity,0)) as option_quantity
FROM ac_products p
LEFT JOIN ac_product_options po
ON (po.product_id = p.product_id AND po.status = 1)
LEFT JOIN ac_product_option_values pov
ON (po.product_option_id = pov.product_option_id)
WHERE p.product_id IN (935, 936, 937, 938, 939, 934, 932, 933, 923, 924, 925, 926, 927, 928, 929, 930, 909, 910, 911, 912, 913, 914, 891, 882, 883, 884, 879, 880, 881, 860, 861, 862)
GROUP BY p.product_id
PHP call stack:
#0 /home/public_html/core/lib/db.php:100
#1 /home/public_html/core/engine/extensions.php:1176
#2 /home/public_html/core/engine/extensions.php:1127
#3 /home/public_html/core/lib/db.php:67
#4 /home/public_html/storefront/model/catalog/product.php:133
#5 /home/public_html/storefront/controller/blocks/featured.php:63
#6 /home/public_html/core/engine/dispatcher.php:293
#7 /home/public_html/core/engine/dispatcher.php:328
#8 /home/public_html/core/engine/dispatcher.php:328
#9 /home/public_html/core/engine/page.php:108
#10 /home/public_html/core/engine/router.php:176
#11 /home/public_html/core/engine/router.php:80
#12 /home/public_html/index.php:94
in /home/public_html/core/database/amysqli.php on line 119
2020-08-31 13:23:30 - warning: AbanteCart core v.1.2.16 Use of undefined constant CACHE_DRIVER - assumed 'CACHE_DRIVER' (this will throw an Error in a future version of PHP) in /home/public_html/core/helper/system_check.php on line 126

Please check your sysdtem/config.php file. Does it contains such row?
Code: [Select]
define('CACHE_DRIVER', 'file');
Title: Re: contact administrator of this web site to increase 'Connection Timeout
Post by: HADY on September 01, 2020, 06:22:51 AM: Please check your sysdtem/config.php file. Does it contains such row?
Code: [Select]
define('CACHE_DRIVER', 'file');[/quote]

It wasn't. I added it and will check if that will fix my issue, if ok i will write my feedback anyway during the time afterwhile.
Title: Re: contact administrator of this web site to increase 'Connection Timeout
Post by: HADY on September 04, 2020, 06:30:03 AM: Hello!

Now i see next error log:

2020-09-04 11:33:28 - load error: AbanteCart core v.1.2.16 Error: Cannot create HTML cache for file html_cache.blocks.category.default.0.1.USD.1._42469_d41d8cd98f00b204e9800998ecf8427e! Directory to write cache is not writable
Trace:
#0 /home/public_html/core/engine/view.php on line 379
#1 /home/public_html/core/engine/view.php on line 294
#2 /home/public_html/core/engine/controller.php on line 483
#3 /home/public_html/core/engine/dispatcher.php on line 341
#4 /home/public_html/core/engine/dispatcher.php on line 328
2020-09-04 11:33:29 - load error: AbanteCart core v.1.2.16 Error: Cannot create HTML cache for file html_cache.blocks.menu.default.0.1.USD.1._42495_d41d8cd98f00b204e9800998ecf8427e! Directory to write cache is not writable
Trace:
#0 /home/public_html/core/engine/view.php on line 379
#1 /home/public_html/core/engine/view.php on line 294
#2 /home/public_html/core/engine/controller.php on line 483
#3 /home/public_html/core/engine/dispatcher.php on line 341
#4 /home/public_html/core/engine/dispatcher.php on line 328

What I have to do please to solve this issue?

Thanks
Title: Re: contact administrator of this web site to increase 'Connection Timeout
Post by: abolabo on September 04, 2020, 08:58:41 AM: Quote from: HADY on September 04, 2020, 06:30:03 AM
Hello!

Now i see next error log:

2020-09-04 11:33:28 - load error: AbanteCart core v.1.2.16 Error: Cannot create HTML cache for file html_cache.blocks.category.default.0.1.USD.1._42469_d41d8cd98f00b204e9800998ecf8427e! Directory to write cache is not writable
Trace:
#0 /home/public_html/core/engine/view.php on line 379
#1 /home/public_html/core/engine/view.php on line 294
#2 /home/public_html/core/engine/controller.php on line 483
#3 /home/public_html/core/engine/dispatcher.php on line 341
#4 /home/public_html/core/engine/dispatcher.php on line 328
2020-09-04 11:33:29 - load error: AbanteCart core v.1.2.16 Error: Cannot create HTML cache for file html_cache.blocks.menu.default.0.1.USD.1._42495_d41d8cd98f00b204e9800998ecf8427e! Directory to write cache is not writable
Trace:
#0 /home/public_html/core/engine/view.php on line 379
#1 /home/public_html/core/engine/view.php on line 294
#2 /home/public_html/core/engine/controller.php on line 483
#3 /home/public_html/core/engine/dispatcher.php on line 341
#4 /home/public_html/core/engine/dispatcher.php on line 328

What I have to do please to solve this issue?

Thanks

please disable html-cache. This feature was experimental and removed in v1.2.16
Title: Re: contact administrator of this web site to increase 'Connection Timeout
Post by: HADY on September 05, 2020, 03:34:16 AM: please disable html-cache. This feature was experimental and removed in v1.2.16
[/quote]

I disabled html_cache and now i got this yesterday on Error logs :

2020-09-04 17:29:55 - warning: AbanteCart core v.1.2.16 mysqli::__construct(): (HY000/2002): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /home/public_html/core/database/amysqli.php on line 50
2020-09-04 17:29:55 - App Error: AbanteCart core v.1.2.16 Cannot establish database connection to u6047506_ac2 using u6047506_ac2@localhost
Trace:
#0 /home/public_html/core/database/amysqli.php on line 52
#1 /home/public_html/core/lib/db.php on line 52
#2 /home/public_html/core/init.php on line 322
#3 /home/public_html/index.php on line 55
2020-09-04 17:29:55 - database error: AbanteCart core v.1.2.16 Cannot establish database connection. Check your database connection settings. in /home/public_html/core/database/amysqli.php on line 54
2020-09-04 17:29:56 - warning: AbanteCart core v.1.2.16 mysqli::__construct(): (HY000/2002): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /home/public_html/core/database/amysqli.php on line 50
2020-09-04 17:29:56 - App Error: AbanteCart core v.1.2.16 Cannot establish database connection to u6047506_ac2 using u6047506_ac2@localhost
Trace:
#0 /home/public_html/core/database/amysqli.php on line 52
#1 /home/public_html/core/lib/db.php on line 52
#2 /home/public_html/core/init.php on line 322
#3 /home/public_html/index.php on line 55
2020-09-04 17:29:56 - database error: AbanteCart core v.1.2.16 Cannot establish database connection. Check your database connection settings. in /home/public_html/core/database/amysqli.php on line 54
2020-09-04 17:29:58 - warning: AbanteCart core v.1.2.16 mysqli::__construct(): (HY000/2002): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /home/public_html/core/database/amysqli.php on line 50
2020-09-04 17:29:58 - App Error: AbanteCart core v.1.2.16 Cannot establish database connection to u6047506_ac2 using u6047506_ac2@localhost
Trace:
#0 /home/public_html/core/database/amysqli.php on line 52
#1 /home/public_html/core/lib/db.php on line 52
#2 /home/public_html/core/init.php on line 322
#3 /home/public_html/index.php on line 55
2020-09-04 17:29:58 - database error: AbanteCart core v.1.2.16 Cannot establish database connection. Check your database connection settings. in /home/public_html/core/database/amysqli.php on line 54

any advices please???

Thanks
Title: Re: contact administrator of this web site to increase 'Connection Timeout
Post by: abolabo on September 05, 2020, 09:40:33 AM: Hi.
Your error cannot be related to the cache.
Please open publuc_html/system/config.php and check credentials related to database connection.
Title: Re: contact administrator of this web site to increase 'Connection Timeout
Post by: HADY on September 07, 2020, 05:38:18 AM: Quote from: abolabo on September 05, 2020, 09:40:33 AM
Hi.
Your error cannot be related to the cache.
Please open publuc_html/system/config.php and check credentials related to database connection.

I checked credentials related to database connection and everything is correct.
Title: Re: contact administrator of this web site to increase 'Connection Timeout
Post by: maxter on September 07, 2020, 09:25:22 PM: I clearly see that you have issue with your Mysql server. That could be a reason for timeouts and no connection in your last post.

Check your mysql server.
Try to repare tables as well.
Title: Re: contact administrator of this web site to increase 'Connection Timeout
Post by: HADY on September 10, 2020, 05:33:46 AM: Quote from: maxter on September 07, 2020, 09:25:22 PM
I clearly see that you have issue with your Mysql server. That could be a reason for timeouts and no connection in your last post.

Check your mysql server.
Try to repare tables as well.

I checked them but nothing found.
Title: Re: contact administrator of this web site to increase 'Connection Timeout
Post by: HADY on September 10, 2020, 10:08:41 AM: Can you Tell me guys if there is anything missing in php.ini file please ? Details in the file as next showen

output_buffering = 4096;
magic_quotes_gpc = Off;
register_globals = Off;
default_charset = UTF-8;
memory_limit = 1024M;
max_execution_time = 18000;
upload_max_filesize = 4000M;
post_max_size = 2000M;
safe_mode = Off;
mysql.connect_timeout = 256M;
session.use_cookies = On;
session.use_trans_sid = Off;
session.gc_maxlifetime = 24;
apc.enabled = 0;

Regards...
Title: Re: contact administrator of this web site to increase 'Connection Timeout
Post by: maxter on September 12, 2020, 05:40:52 PM: I do not think the value is right here:
mysql.connect_timeout = 256M;

From PHP manual:
mysql.connect_timeout integer
Connect timeout in seconds. On Linux this timeout is also used for waiting for the first answer from the server.

There is no "M"
Title: Re: contact administrator of this web site to increase 'Connection Timeout
Post by: llegrand on September 12, 2020, 09:34:33 PM: Maxter is correct - the setting is for seconds - and is usually relatively low, most of our installations run well with this setting:

mysql.connect_timeout = 20;

the M, is problematic and the 256 would equate to over 4 minutes waiting time that the mysqld server waits for a connect packet before responding with Bad handshake.