alexbaysu Posted November 3, 2016 Share Posted November 3, 2016 Hello, When I try to create a new product on admin panel, I received that error. Link to database cannot be established: SQLSTATE[HY000] [1203] User "username" already has more than 'max_user_connections' active connections I talked with my hosting and they said "We can not increase your max_user_connections limit. It is 6. You have problems in your code files.You need to fix it." Is there any solutions to fix that problem guys? Link to comment Share on other sites More sharing options...
PrestaHeroes USA Posted November 3, 2016 Share Posted November 3, 2016 Hi, you should find new hosting that does not create low limit like this. Link to comment Share on other sites More sharing options...
alexbaysu Posted November 3, 2016 Author Share Posted November 3, 2016 Thanks for replying. They said me if it is connecting more than 7 connections that means my prestashop codes have problems. Is that true? And is it possible to increase max_user_connections limit with php.ini file? Hi, you should find new hosting that does not create low limit like this. Link to comment Share on other sites More sharing options...
PrestaHeroes USA Posted November 3, 2016 Share Posted November 3, 2016 hosting when there is issue like this where they will not accommodate increase to say 20, will blame whatever application is running in space. here is search for issue, maybe you find a work around, but I do not have much hope it will help. https://www.google.com/webhp?sourceid=chrome-instant&ion=1&espv=2&ie=UTF-8#q=prestashop+best+max_user_connections+site:www.prestashop.com Link to comment Share on other sites More sharing options...
andrew Posted January 2, 2020 Share Posted January 2, 2020 Hi We have this same issue The number of connections has been increased to 100 - but the error still shows 30 The host says it is a bug in prestashop Any thoughts? - Andrew Link to comment Share on other sites More sharing options...
JuanjoG Posted January 2, 2020 Share Posted January 2, 2020 You can try to delete connections, empty cars from the database and verify that it works, if you should not look for a new hosting 1 Link to comment Share on other sites More sharing options...
JuanjoG Posted January 2, 2020 Share Posted January 2, 2020 It also checks the PHP version of the server, it can also generate these problems. Link to comment Share on other sites More sharing options...
TCB-Netherlands Posted January 3, 2020 Share Posted January 3, 2020 The latest php version php 7.3.13 will not work, please use 7.2.26 instead. Also what El Patron said, get the F out of there, hosting with such a low limit is not worth any penny. Get a proper hosting provider or get your own server or VPS. Link to comment Share on other sites More sharing options...
andrew Posted January 3, 2020 Share Posted January 3, 2020 Thanks for the thoughts, They're a good host - lightning fast and excellent 24x7 support (which isn't needed as there have been no issues other than this one) Who would you recommend? - Andrew Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now