1
Templates / Re: error log on V.1.4.1
« on: February 07, 2025, 04:07:07 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:
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.