PDA

View Full Version : I get MySQL errors


Auction Guy
Sun 20th Apr '08, 4:26pm
I have been getting this error every once in awhile and I am wondering if it a problem with my hosting or something in RC3??

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: User MydbName already has more than 'max_user_connections' active connections /usr/www/users/Mydbname/includes/class_core.php on line 311

Help anyone??

Thanks in advance! :)

Steve Machol
Sun 20th Apr '08, 4:30pm
This is a server/host issue. The server has maxed out the number of MySQL connections your host allows you to have. You can try turning persistent connections off in your config.php:

// ****** MASTER DATABASE PERSISTENT CONNECTIONS ******
// This option allows you to turn persistent connections to MySQL on or off.
// The difference in performance is negligible for all but the largest boards.
// If you are unsure what this should be, leave it off. (0 = off; 1 = on)
$config['MasterServer']['usepconnect'] = 0;
But if you still have problems after that, all you can do is ask your host to raise the maximum number of connections they allow.

Here is more info on this error:

http://dev.mysql.com/doc/refman/4.1/en/user-resources.html
http://dev.mysql.com/doc/refman/5.0/en/user-resources.html