eCommerce construction > Templates
error log on V.1.4.1
abolabo:
--- Quote from: G. O. on February 07, 2025, 02:11:43 AM ---here what i get in the error log when i just click on delete cache memory:
2025-02-07 9:51:53 - App Error: AbanteCart core v.1.4.1 Cannot establish database connection to u6047506_lnqm1 using u6047506_lnqm1@localhost
User u6047506_lnqm1 already has more than 'max_user_connections' active connections
Trace:
#0 /home/u6047506/public_html/core/lib/db.php on line 64
#1 /home/u6047506/public_html/core/init.php on line 354
#2 /home/u6047506/public_html/index.php on line 60
2025-02-07 9:53:14 - 1226: User 'u6047506_lnqm1' has exceeded the 'max_user_connections' resource (current value: 50)
SELECT SQL_CALC_FOUND_ROWS DISTINCT p.*,
#11 /home/u6047506/public_html/index.php:101
in /home/u6047506/public_html/core/database/amysqli.php on line 162
website intreface has next error as in the screenshot:
--- End quote ---
this huge sql error is NOT a cause. Cause is in high load of web-server.
max_user_connections directive is MYSQL directive. This is not an AbanteCart code.
For example your mysql server have limitation for 100 connections at the same time. This mean 100 customers opened your cart at the same time. And next 101 will be a cause of error in the your log file.
Sql-query is not a cause.
How many users do you have?
Can you look into table customer_sessions?
Do you have enabled google analitycs? Did you see some spikes on report plots?
Probably mysql server have a glitch and do not automatic close of lost connections. have no ideas anymore.
I think you should your hosting provider support about this situation.
G. O.:
--- Quote from: abolabo on February 07, 2025, 04:07:07 AM ---
--- Quote from: G. O. on February 07, 2025, 02:11:43 AM ---here what i get in the error log when i just click on delete cache memory:
2025-02-07 9:51:53 - App Error: AbanteCart core v.1.4.1 Cannot establish database connection to u6047506_lnqm1 using u6047506_lnqm1@localhost
User u6047506_lnqm1 already has more than 'max_user_connections' active connections
Trace:
#0 /home/u6047506/public_html/core/lib/db.php on line 64
#1 /home/u6047506/public_html/core/init.php on line 354
#2 /home/u6047506/public_html/index.php on line 60
2025-02-07 9:53:14 - 1226: User 'u6047506_lnqm1' has exceeded the 'max_user_connections' resource (current value: 50)
SELECT SQL_CALC_FOUND_ROWS DISTINCT p.*,
#11 /home/u6047506/public_html/index.php:101
in /home/u6047506/public_html/core/database/amysqli.php on line 162
website intreface has next error as in the screenshot:
--- End quote ---
this huge sql error is NOT a cause. Cause is in high load of web-server.
max_user_connections directive is MYSQL directive. This is not an AbanteCart code.
For example your mysql server have limitation for 100 connections at the same time. This mean 100 customers opened your cart at the same time. And next 101 will be a cause of error in the your log file.
Sql-query is not a cause.
How many users do you have?
Can you look into table customer_sessions?
Do you have enabled google analitycs? Did you see some spikes on report plots?
Probably mysql server have a glitch and do not automatic close of lost connections. have no ideas anymore.
I think you should your hosting provider support about this situation.
--- End quote ---
is there any way to increase the 'max_user_connections' value ?
Basara:
--- Quote from: G. O. on February 07, 2025, 06:27:44 AM ---is there any way to increase the 'max_user_connections' value ?
--- End quote ---
Hello.
Yes, it is possible to increase that value, but it is not related to AbanteCart. Instead, it depends on the hosting service provider or server configuration.
abolabo:
--- Quote from: G. O. on January 24, 2025, 06:57:47 AM ---that ok but now i get next error:
2025-01-24 14:55:41 - Unknown Error: AbanteCart core v.1.4.1 Call to undefined method db_result_meta::fetch_object()
Trace:
#0 /home/u6047506/public_html/core/lib/db.php(119): AMySQLi->query()
#1 /home/u6047506/public_html/core/engine/extensions.php(1159): ADB->_query()
#2 /home/u6047506/public_html/core/engine/extensions.php(390): ExtensionsApi->__ExtensionsApiCall()
#3 /home/u6047506/public_html/core/lib/db.php(85): ExtensionsApi->__call()
#4 /home/u6047506/public_html/core/lib/dataset.php(89): ADB->query()
#5 /home/u6047506/public_html/core/lib/menu_control_storefront.php(36): ADataset->__construct()
#6 /home/u6047506/public_html/extensions/novator/storefront/controller/blocks/mega_menu.php(187): AMenu_Storefront->__construct()
#7 /home/u6047506/public_html/extensions/novator/storefront/controller/blocks/mega_menu.php(49): ControllerBlocksMegaMenu->buildMenu()
#8 /home/u6047506/public_html/core/engine/dispatcher.php(306): ControllerBlocksMegaMenu->main()
#9 /home/u6047506/public_html/core/engine/dispatcher.php(341): ADispatcher->dispatch()
#10 /home/u6047506/public_html/core/engine/dispatcher.php(341): ADispatcher->dispatch()
#11 /home/u6047506/public_html/core/engine/page.php(110): ADispatcher->dispatch()
#12 /home/u6047506/public_html/core/engine/router.php(204): APage->build()
#13 /home/u6047506/public_html/core/engine/router.php(86): ARouter->route()
#14 /home/u6047506/public_html/index.php(101): ARouter->processRoute()
#15 {main} in /home/u6047506/public_html/core/database/amysqli.php on line 136
--- End quote ---
solved. Please apply this patch to core/database/amysqli.php file
https://github.com/abantecart/abantecart-src/commit/5d2206dc3f1d29454c86d39ce7938d66a245d4d4
G. O.:
--- Quote from: abolabo on February 28, 2025, 07:20:04 AM ---
--- Quote from: G. O. on January 24, 2025, 06:57:47 AM ---that ok but now i get next error:
2025-01-24 14:55:41 - Unknown Error: AbanteCart core v.1.4.1 Call to undefined method db_result_meta::fetch_object()
Trace:
#0 /home/u6047506/public_html/core/lib/db.php(119): AMySQLi->query()
#1 /home/u6047506/public_html/core/engine/extensions.php(1159): ADB->_query()
#2 /home/u6047506/public_html/core/engine/extensions.php(390): ExtensionsApi->__ExtensionsApiCall()
#3 /home/u6047506/public_html/core/lib/db.php(85): ExtensionsApi->__call()
#4 /home/u6047506/public_html/core/lib/dataset.php(89): ADB->query()
#5 /home/u6047506/public_html/core/lib/menu_control_storefront.php(36): ADataset->__construct()
#6 /home/u6047506/public_html/extensions/novator/storefront/controller/blocks/mega_menu.php(187): AMenu_Storefront->__construct()
#7 /home/u6047506/public_html/extensions/novator/storefront/controller/blocks/mega_menu.php(49): ControllerBlocksMegaMenu->buildMenu()
#8 /home/u6047506/public_html/core/engine/dispatcher.php(306): ControllerBlocksMegaMenu->main()
#9 /home/u6047506/public_html/core/engine/dispatcher.php(341): ADispatcher->dispatch()
#10 /home/u6047506/public_html/core/engine/dispatcher.php(341): ADispatcher->dispatch()
#11 /home/u6047506/public_html/core/engine/page.php(110): ADispatcher->dispatch()
#12 /home/u6047506/public_html/core/engine/router.php(204): APage->build()
#13 /home/u6047506/public_html/core/engine/router.php(86): ARouter->route()
#14 /home/u6047506/public_html/index.php(101): ARouter->processRoute()
#15 {main} in /home/u6047506/public_html/core/database/amysqli.php on line 136
--- End quote ---
solved. Please apply this patch to core/database/amysqli.php file
https://github.com/abantecart/abantecart-src/commit/5d2206dc3f1d29454c86d39ce7938d66a245d4d4
--- End quote ---
Thank you Sir, are you planning to upgrade this file in next version too or i should upgrade it now?
Navigation
[0] Message Index
[#] Next page
[*] Previous page
Go to full version