Too many concurrent mysql connections
Charisma
posted 21st of January 2009
in
Community Voice.
6 comments.
Hi guys,
I just recieved a few hundred emails wiith the following error on all of them: You need to close the mysql concurrent connection in your script. Please contact with your script writer/programmer about it. We do unfortunately not provide such code as this is out of our service area
Database error in Charisma Models
Mysql error: User charisma601final already has more than 'max_user_connections' active connections
Just wondering if there is a piece of code I can insert or something that you know of that will help me safely close the current concurrent connections for each visitor after the page has queried the items?
Many thanks
Cheers,
Colin
Recommended by
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.
The new Dolphin solution is powered by UNA Community Management System.
in your "inc" directory find the file db.inc.php. In that file find the line that reads:
$this->link = @mysql_pconnect( $this->host . $this->port . $this->sock, $this->user, $this->passwd );
and change it to:
$this->link = @mysql_connect( $this->host . $this->port . $this->sock, $this->user, $this->passwd );
Taking out the "p" from mysql_pconnect makes it a single connect instead of a persistant connection.
I will give this a try :)
But why did they put pconnect in the script if it's causing problems ? I don't really understand the use of this.
http://www.flashdaweb.com/blog/2009/03/05/database-error-in-dolphin-cms-and-max_user_connections-problem-fix.html
Where else might I find and change this?