Ecommerce
Permalink
I have a developer trying to install a new ecommerce package. When they try to install or uninstall he gets an error in phpmyadmin stating SQLSTATE[HY000} [1226] User 'vendingtown_beta' has exceeded the 'max_user_connections' resource (current value: 30)
Can anyone help us with this? The hosting company is saying the package is too big, but we don't think this is the cause.
Can anyone help us with this? The hosting company is saying the package is too big, but we don't think this is the cause.
Do you have other things on the server (other than concrete5) that connect to their database with the same username vendingtown_beta?
There are two databases, one on the live and one we have for beta test
Sorry, my question was not very clear.
Do you have anything other than Concrete5 installed on that server?
If yes, does that application also connects to a database using the same username vendingtown_beta?
Do you have anything other than Concrete5 installed on that server?
If yes, does that application also connects to a database using the same username vendingtown_beta?
No nothing else :(
Any custom package or block that's not from the marketplace?
Anything out of the ordinary?
Anything out of the ordinary?
Thee are no such issues the site is working fine in localhost
ok so all I can think of is to modify your PHP settings and give max_user_connections a value higher than 30
Maybe check what value you have locally.
Here's the MySql doc explaining it:https://dev.mysql.com/doc/refman/5.5/en/too-many-connections.html...
Maybe check what value you have locally.
Here's the MySql doc explaining it:https://dev.mysql.com/doc/refman/5.5/en/too-many-connections.html...
I have tried
“You can increase this value in main config file (e.g., /etc/my.cnf) using this syntax:
[mysqld]
set-variable=max_connections=250 “
But there is no such file
Etc/my.cnf
“You can increase this value in main config file (e.g., /etc/my.cnf) using this syntax:
[mysqld]
set-variable=max_connections=250 “
But there is no such file
Etc/my.cnf
created that file and tested
Same error
Same error
My understanding is if you are on a shared host you might be out of luck. If you are on a VPS or dedicated server, they should be able to pinpoint the origin of the problem and offer solutions
Ok thank you. My last chance effort will be to ask the hosting company to increase the max connections i guess
