Please help us to make AbanteCart Ideal Open Source Ecommerce Solution for everyone.

Support AbanteCart eCommerce

Author Topic: contact administrator of this web site to increase 'Connection Timeout  (Read 5421 times)

Offline HADY

  • Sr. Member
  • ****
  • Posts: 328
  • Karma: +27/-5
    • View Profile
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
« Last Edit: August 31, 2020, 06:17:58 AM by HADY »
Thank you In Advanced
Regards
HADY

Offline Basara

  • Administrator
  • Hero Member
  • *****
  • Posts: 5774
  • Karma: +274/-2
    • View Profile
Re: contact administrator of this web site to increase 'Connection Timeout
« Reply #1 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

Offline HADY

  • Sr. Member
  • ****
  • Posts: 328
  • Karma: +27/-5
    • View Profile
Re: contact administrator of this web site to increase 'Connection Timeout
« Reply #2 on: August 31, 2020, 06:14:18 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).
Thank you In Advanced
Regards
HADY

Offline HADY

  • Sr. Member
  • ****
  • Posts: 328
  • Karma: +27/-5
    • View Profile
Re: contact administrator of this web site to increase 'Connection Timeout
« Reply #3 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 <b>/home/public_html/core/helper/system_check.php</b> on line <b>126</b>
2020-08-31 13:20:57 - warning: AbanteCart core v.1.2.16 mkdir(): File exists in <b>/home/public_html/core/helper/utils.php</b> on line <b>1306</b>
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 <b>/home/public_html/core/helper/system_check.php</b> on line <b>126</b>
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 <b>/home/public_html/core/database/amysqli.php</b> on line <b>119</b>
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 <b>/home/public_html/core/helper/system_check.php</b> on line <b>126</b>
Thank you In Advanced
Regards
HADY

Offline abolabo

  • core-developer
  • Administrator
  • Hero Member
  • *****
  • Posts: 2046
  • Karma: +318/-13
  • web for all, all for web!
    • View Profile
    • AbanteCart
Re: contact administrator of this web site to increase 'Connection Timeout
« Reply #4 on: September 01, 2020, 05:48:56 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 <b>/home/public_html/core/helper/system_check.php</b> on line <b>126</b>
2020-08-31 13:20:57 - warning: AbanteCart core v.1.2.16 mkdir(): File exists in <b>/home/public_html/core/helper/utils.php</b> on line <b>1306</b>
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 <b>/home/public_html/core/helper/system_check.php</b> on line <b>126</b>
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 <b>/home/public_html/core/database/amysqli.php</b> on line <b>119</b>
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 <b>/home/public_html/core/helper/system_check.php</b> on line <b>126</b>

Please check your sysdtem/config.php file. Does it contains such row?
Code: [Select]
define('CACHE_DRIVER', 'file');
“No one is useless in this world who lightens the burdens of another.”
― Charles Dickens

Offline HADY

  • Sr. Member
  • ****
  • Posts: 328
  • Karma: +27/-5
    • View Profile
Re: contact administrator of this web site to increase 'Connection Timeout
« Reply #5 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.

Thank you In Advanced
Regards
HADY

Offline HADY

  • Sr. Member
  • ****
  • Posts: 328
  • Karma: +27/-5
    • View Profile
Re: contact administrator of this web site to increase 'Connection Timeout
« Reply #6 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
Thank you In Advanced
Regards
HADY

Offline abolabo

  • core-developer
  • Administrator
  • Hero Member
  • *****
  • Posts: 2046
  • Karma: +318/-13
  • web for all, all for web!
    • View Profile
    • AbanteCart
Re: contact administrator of this web site to increase 'Connection Timeout
« Reply #7 on: September 04, 2020, 08:58:41 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
“No one is useless in this world who lightens the burdens of another.”
― Charles Dickens

Offline HADY

  • Sr. Member
  • ****
  • Posts: 328
  • Karma: +27/-5
    • View Profile
Re: contact administrator of this web site to increase 'Connection Timeout
« Reply #8 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 <b>/home/public_html/core/database/amysqli.php</b> on line <b>50</b>
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 <b>/home/public_html/core/database/amysqli.php</b> on line <b>54</b>
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 <b>/home/public_html/core/database/amysqli.php</b> on line <b>50</b>
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 <b>/home/public_html/core/database/amysqli.php</b> on line <b>54</b>
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 <b>/home/public_html/core/database/amysqli.php</b> on line <b>50</b>
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 <b>/home/public_html/core/database/amysqli.php</b> on line <b>54</b>




any advices please???

Thanks
Thank you In Advanced
Regards
HADY

Offline abolabo

  • core-developer
  • Administrator
  • Hero Member
  • *****
  • Posts: 2046
  • Karma: +318/-13
  • web for all, all for web!
    • View Profile
    • AbanteCart
Re: contact administrator of this web site to increase 'Connection Timeout
« Reply #9 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.
“No one is useless in this world who lightens the burdens of another.”
― Charles Dickens

Offline HADY

  • Sr. Member
  • ****
  • Posts: 328
  • Karma: +27/-5
    • View Profile
Re: contact administrator of this web site to increase 'Connection Timeout
« Reply #10 on: September 07, 2020, 05:38:18 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.
Thank you In Advanced
Regards
HADY

Offline maxter

  • Full Member
  • ***
  • Posts: 228
  • Karma: +64/-0
    • View Profile
Re: contact administrator of this web site to increase 'Connection Timeout
« Reply #11 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.

Offline HADY

  • Sr. Member
  • ****
  • Posts: 328
  • Karma: +27/-5
    • View Profile
Re: contact administrator of this web site to increase 'Connection Timeout
« Reply #12 on: September 10, 2020, 05:33:46 AM »
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.
Thank you In Advanced
Regards
HADY

Offline HADY

  • Sr. Member
  • ****
  • Posts: 328
  • Karma: +27/-5
    • View Profile
Re: contact administrator of this web site to increase 'Connection Timeout
« Reply #13 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...
Thank you In Advanced
Regards
HADY

Offline maxter

  • Full Member
  • ***
  • Posts: 228
  • Karma: +64/-0
    • View Profile
Re: contact administrator of this web site to increase 'Connection Timeout
« Reply #14 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"

 

Powered by SMFPacks Social Login Mod