Jump to content

Issues With Mysql Connections


Recommended Posts

Several of my users at spyderchat.com have been getting the following message intermittently:

 

**************************

Warning: mysql_connect() [function.mysql-connect]: User ***_donalex has already more than 'max_user_connections' active connections in /home/***/public_html/phpBB2/db/mysql4.php on line 48

 

Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/***/public_html/phpBB2/db/mysql4.php on line 330

 

Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in /home/***/public_html/phpBB2/db/mysql4.php on line 331

phpBB : Critical Error

 

Could not connect to the database

 

************************

 

We rarely have more than 40 people online at once.

 

Please advise,

 

Don

Link to comment
Share on other sites

  • 2 weeks later...
sorry for not searching first - never mind - I am finding answers...

 

No, I did not find an answer which was corroborated by different people - I need help...

 

I got this:

Try adding the following to .htaccess

 

CODE

php_flag mysql.allow_persistent off

Link to comment
Share on other sites

Open public_html/phpBB2/db/mysql4.php and locate the following code

 

>function sql_db($sqlserver, $sqluser, $sqlpassword, $database, $persistency = true)

 

and change it to

 

>function sql_db($sqlserver, $sqluser, $sqlpassword, $database, $persistency = false)

 

that should fix the problem.

Link to comment
Share on other sites

Did adding that to your .htaccess file not help?

 

Or are you not sure where to add it?

 

I put it right after:

 

<IfModule mod_security.c>

SecFilterEngine Off

SecFilterScanPOST Off

</IfModule>

php_flag mysql.allow_persistent off

 

Is that correct?

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...