Bug #5986 Updated: Combination of msql() and msql_connect() causes lost connections.

ID: 5986 Updated by: mfischer Reported By: pete@byways.org Status: Closed Bug Type: mSQL related Operating System: RedHat Linux 6.2 PHP Version: 4.0.1 New Comment: Hey, I wanted to close it X-) Previous Comments: ------------------------------------------------------------------------ [2001-11-29 15:55:25] derick@php.net Whooohoo! it' fixed. closing. ------------------------------------------------------------------------ [2001-11-29 15:54:41] pete@byways.org I've confirmed this to be fixed as of PHP 4.0.6, Apache 1.3.20, mSQL 2.0.11. The script provided also works in PHP 4.1.0RC3. ------------------------------------------------------------------------ [2001-11-25 07:41:14] mfischer@php.net Can you test if this has changed with the latest RC? http://www.php.net/~zeev/php-4.1.0RC3.tar.gz Feedback. ------------------------------------------------------------------------ [2000-08-11 04:49:33] pete@byways.org I believe that the problem is caused by the msql_globals.default_link value being set to an mSQL database link that has been closed by _close_msql_link in php_msql.c. Ideally, when a database link is closed, if it's the default link, then reset the default link to -1. I'm not sure how to do that in the code. I can get the script to work if I add this line to the _close_msql_link function: msql_globals.default_link = -1; However, I'm sure this is a less than adequate method, since we don't want to reset it all the time. ------------------------------------------------------------------------ [2000-08-10 04:25:01] pete@byways.org I get the same errors after patching php_msql.c and re-running the script I provided. ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/?id=5986 Edit this bug report at http://bugs.php.net/?id=5986&edit=1