smashingred

I finally found the answer to my question. A plugin I was using: CoppermineSC was the root of my problems. Where it was making a DB connection it was killing the WP db connection. After nearly 8 hours of wasted time I did a Google search to find this solution. Apparently the plugin didn’t use the newlink param of the mysql_connect() and therefore was starting a new connection to the WP DB instead of starting a new one.

If you are using CoppermineSC make sure you change the following line (around 1096) from :
$this->cpgscdbh = @mysql_connect($dbhost, $dbuser, $dbpassword);

to:

$this->cpgscdbh = @mysql_connect($dbhost, $dbuser, $dbpassword, TRUE);

In addition any plugins that are accessing the db should include this the newlink param value or you could end up breaking your WP.

Cheers

Jay

PS: Stack on which I had issues was LAMP, Apache 2.2, MySQL 5.0.25, PHP 5.2.5. WordPress 2.5.1 and Coppermine 1.44.