killakhan4 Posted January 19, 2005 Posted January 19, 2005 When many people are on my site i get this error: Warning: mysql_pconnect(): User kicksonfire has already more than 'max_user_connections' active connections in /home/www/kicksonfire/admin/includes/functions/database.php on line 17 Unable to connect to database server! I have been doing alot of research around the web and on the forums looking for answers but no help. I found somewhere that it could be becasue i have persistent connection ON.... So after that i turned them off from my configuration files. When I call my hosting company, they tell me the problem is the there are alotta scripts being run and the connection to the database are not being closed... Please check your coding to see if the connection are being closed properly. They said its not their fault and its the coding. I don't know wat to do. I am losing alotta money.. i need a fix for this problem fast.... Please help me!!
Rob123 Posted January 19, 2005 Posted January 19, 2005 You said that you made the appropiate changes to the configure.php files. There are ways to reduce the number of queries that osC uses however, if you're losing "$1000s of dollars"... I suggest that you upgrade your hosting plan or get a better host. HTH, Robert
Guest Posted January 19, 2005 Posted January 19, 2005 Turn the option to use pconnect off... Edit includes/configure.php define('USE_PCONNECT', 'false'); // use persistent connections? Bobby
killakhan4 Posted January 19, 2005 Author Posted January 19, 2005 OK maybe i exaggerated with the 1000s of dollars but still i am losing money... people get the error while making orders..... as for the persistant connection i turned it off already but NO USE
♥Vger Posted January 19, 2005 Posted January 19, 2005 All hosting companies limit the number of connections you can have open at any one time - and the cheaper the hosting, the fewer the connections. Vger
ozcsys Posted January 19, 2005 Posted January 19, 2005 Look at upgrading your hosting and at Bobby's contrbutions for cutting down on your sql queries as that will help quite a bit. The Knowledge Base is a wonderful thing. Do you have a problem? Have you checked out Common Problems? There are many very useful osC Contributions Are you having trouble with a installed contribution? Have you checked out the support thread found Here BACKUP BACKUP BACKUP!!! You did backup, right??
Guest Posted January 19, 2005 Posted January 19, 2005 All hosting companies limit the number of connections you can have open at any one time - and the cheaper the hosting, the fewer the connections. Vger <{POST_SNAPBACK}> We should all put that in our sigs: "You get what you pay for..." :) Bobby
Dragonmom Posted January 19, 2005 Posted January 19, 2005 We should all put that in our sigs: "You get what you pay for..." :) Bobby <{POST_SNAPBACK}> NOt a good idea... This being an *ahem* FREE shopping cart and all! psst... wanna buy a wand?
Guest Posted January 19, 2005 Posted January 19, 2005 the hosting part is critical, and most people opt to save $15 - $30 cuz they get tons of space however most typical stores dont go over a few hundred megabytes. what you do lose on the less expensive hosts is band width, thenumber of connections, lack of control on the php.ini, etc so you do get what you pay for. as for oscommerce being FREE withwhat you have posted Shawn, it may be GPL but to get it working to a point where it looks good, etc you have a great investment. i couldnt tell u how many hours per site i put in. know it doesnt work out to be free!
Guest Posted January 19, 2005 Posted January 19, 2005 the hosting part is critical, and most people opt to save $15 - $30... A much better solution is to use your own server and then you never run into these sorts of problems (or if you do, you can actually do something about it). And everything is more secure, and much easier to administer too. Warning: mysql_pconnect(): User kicksonfire has already more than 'max_user_connections' As for the database connection problem, it might not be you causing the problem ! It could be a global limit on the database that is being reached. Maybe the host just has too many users hanging off the same database or someone else on the same host is hogging the connections. If you can avoid it, I wouldn't switch off permanent connections. It can slow things down quite a bit. Rich.
househead Posted January 19, 2005 Posted January 19, 2005 This is a global mysql issue, you need to edit you mysql config file and increas the number of allowed connections. In *nix, I believe it will most likely be somewhere is /etc/mysql/. If this server is not owned by yourself, you will probably need to request this, and it may not be granted. [blatent plug] I operate a server which could host your site, I have an immense amount of bandwidth, and it's a very stable Gentoo server. PM for more details. [/blatent plug]
Dragonmom Posted January 19, 2005 Posted January 19, 2005 the hosting part is critical, and most people opt to save $15 - $30 cuz they get tons of space however most typical stores dont go over a few hundred megabytes.what you do lose on the less expensive hosts is band width, thenumber of connections, lack of control on the php.ini, etc so you do get what you pay for. <{POST_SNAPBACK}> Hmm, that's a good point. For instance, my host has globals enabled so he can host oscommerce sites. I would like top use the disable globals contrib on the new site I'm building, but I don't have any control over his desision (I think- I should really ask him) as for oscommerce being FREE withwhat you have posted Shawn, it may be GPL but to get it working to a point where it looks good, etc you have a great investment. i couldnt tell u how many hours per site i put in. know it doesnt work out to be free!HUNDREDS of hours!And I am putting in hundreds of hours once again, trying to upgrade my new version. And I am having to learn what to do- all over again. Very frustrating, more so this time than the first, I don't know why, except that I am trying to add much more functionality than I did before. I don't have the money, I gotta spend the time, i guess... psst... wanna buy a wand?
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.