Log in

View Full Version : 'max_user_connections'


EcoCav
06-09-2009, 06:35 AM
I keep getting the database error 'max_user_connections'. I get about 200 emails a day from VB about this error now.

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: User deserttu already has more than 'max_user_connections' active connections (link removed) public_html/forum/includes/class_core.php on line 311

I contacted my webhost about the issue, and they had this to say.

The server's limits for Max_Users is set to 10, that simply means you can not exceed 10 concurrent connections to MySQL or else the MySQL services will be suspended for 1 hour. Make sure your scripts are closing the connection after doing a query, if you keep hitting this limit you will need to move off our shared platforms and on a Virtual Private Server.


What can I do to fix the 'max_user_connections' problem? I'm not even sure whats causing the problem..?

Lynne
06-09-2009, 03:29 PM
See this - Common MySQL Error Messages (http://www.vbulletin.com/docs/html/troubleshoot_mysql_errors)

EcoCav
06-17-2009, 10:15 PM
See this - Common MySQL Error Messages (http://www.vbulletin.com/docs/html/troubleshoot_mysql_errors)

Thanks Lynne

I have added the code ( $config['MasterServer']['usepconnect'] = 0; ) to my config.php file on the 9th, but I am still having the problem. My host wont up the max users more than 10, so thats not an option.

Do the mods and styles have anything to do with this error?