i234i Posted March 31, 2007 Posted March 31, 2007 Hi, I keep getting an error when viewing my online store or using the admin panel Warning: mysql_pconnect() [function.mysql-pconnect]: User weeatmus_mark has already more than 'max_user_connections' active connections in /home/weeatmus/public_html/store/catalog/includes/functions/database.php on line 17 Unable to connect to database server! Also it is happening if customers "more than one" go on the store at once. im not sure how i can resolve this problem as it is a pain.. -- also if someone types my admin panel web domain in can they get into my admin panel without a log in?
Jack_mcs Posted March 31, 2007 Posted March 31, 2007 Your host has set a limit on how many connections can be made to the database. Until those settings are changed or the number of connections goes down, you won't be able to connect. You need to password protect your admin. Check your hosts control panel for password protection options. Jack Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. All of My Addons Get the latest versions of my addons Recommended SEO Addons
i234i Posted March 31, 2007 Author Posted March 31, 2007 thanks for the first bit. ive contacted them about that. what should i be looking for in the cpanel on my hosting to protect it?
i234i Posted March 31, 2007 Author Posted March 31, 2007 ive been onto my host. they said my max user connections are set to 15. But the site hasnt opened yet and i still have the message. they said if they are told (hopefully you can tell me) they will fix the problem. most pro looking sites dont get this hassle!
Jack_mcs Posted April 1, 2007 Posted April 1, 2007 thanks for the first bit. ive contacted them about that. what should i be looking for in the cpanel on my hosting to protect it? Password protection. Jack Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. All of My Addons Get the latest versions of my addons Recommended SEO Addons
Jack_mcs Posted April 1, 2007 Posted April 1, 2007 ive been onto my host. they said my max user connections are set to 15. But the site hasnt opened yet and i still have the message. they said if they are told (hopefully you can tell me) they will fix the problem. most pro looking sites dont get this hassle! If your host can't figure out how to make such a setting change, I'm afraid you are in for rough hosting experience. Tell them they can find the answer here. Jack Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. All of My Addons Get the latest versions of my addons Recommended SEO Addons
vasttech Posted April 1, 2007 Posted April 1, 2007 With such a small limit on connections make sure that: define('USE_PCONNECT', 'false'); is set to false in your configure.php files (both the catalog and admin ones). osCommerce Knowledge Base osCommerce Documentation Contributions
Recommended Posts
Archived
This topic is now archived and is closed to further replies.