To many connections Error Issue?(NOT A BUG)

[grafx2g]

Can you please tell me what this means and how i can resolve the issue.

Warning: Too many connections in /mysite/mysite/mysite/mysite/mysite/mysite/mysite/pp-inc.php on line 126

Warning: MySQL Connection Failed: Too many connections in /mysite/mysite/mysite/mysite/mysite/mysite/mysite/pp-inc.php on line 126
I cannot connect to the PhotoPost database. []


Best regards,

Rob

[Chuck S]

This would depend on your host. it looks to me they are limiting your mysql connections so maybe your site is getting too busy for them. Contact your host about what they are limiting you to in mysql

[helkoryo]

Hi chuck

Could you specify how exactly photopost uses database connections per user please? We are also having this issue pop up, and apparently our con-current connections are limited to 15.

According to the server logs, the error is generated in pp-inc.php on line 254 / 263. Funnily enough its the database connection script xD

Any tips?

Thanks for your time on this ^_^

Regards

Helkoryo

[Chuck S]

well we simply connect and grab stuff standard mysql connect with username password host

errors such as these are from your server setup directly not our code.

[helkoryo]

Originally Posted by Chuck S

well we simply connect and grab stuff standard mysql connect with username password host

errors such as these are from your server setup directly not our code.

Ah yes, but does the database connection close straight after getting the information from the database, or does it leave the connection open to use with other scripts?

We submitted a ticket to our host on this issue and received the following in response:

If you are getting that error then it means your script is using up more connections to mysql than we allow (15). You will need to contact your developer to code your site so that it does not require as many connections. I would have them possibly take a look at this: PHP: mysql_pconnect - Manual

Sounds to me like its a server restriction placed by the host, and all the requests for help on this are thrown back to the software developers, which is rather irritating.

[Chuck S]

I cant say without seeing where your having this issue. Only allowing 15 connections is very very restrictive I can tell you that much.