mysql multiple connections can use same pconnect causing grief. |
[eluser]Randy Casburn[/eluser]
Please read this post... http://ellislab.com/forums/viewreply/478856/ Bottom line is this is not a bug, but expected behavior from both PHP and MySQL implemented correctly by CI. MySQL is not designed to handle connections that are ambigous and PHP is cannot remove the ambiguity we create even when our intentions are noble. So your solution of changing passwords, etc, is one way of removing the ambiguity. If you don't want to create additional user accounts on the DB server, one or the other connections may be changed to a non-persistent connection. The best way go about this is to consider, really, if persistent connections are necessary for one of the DBs. I hope you find this helpful. Randy |
Messages In This Thread |
mysql multiple connections can use same pconnect causing grief. - by El Forum - 10-30-2008, 05:26 PM
mysql multiple connections can use same pconnect causing grief. - by El Forum - 10-30-2008, 06:05 PM
mysql multiple connections can use same pconnect causing grief. - by El Forum - 10-30-2008, 06:39 PM
mysql multiple connections can use same pconnect causing grief. - by El Forum - 10-30-2008, 06:45 PM
mysql multiple connections can use same pconnect causing grief. - by El Forum - 10-30-2008, 07:48 PM
mysql multiple connections can use same pconnect causing grief. - by El Forum - 10-30-2008, 08:42 PM
mysql multiple connections can use same pconnect causing grief. - by El Forum - 10-30-2008, 09:18 PM
mysql multiple connections can use same pconnect causing grief. - by El Forum - 04-16-2009, 06:52 PM
mysql multiple connections can use same pconnect causing grief. - by El Forum - 09-07-2010, 11:00 AM
|