ID: 41350 Comment by: aaronbair at hotmail dot com Reported By: graham at directhostinguk dot com Status: Assigned Bug Type: MySQL related Operating System: Windows 2003 PHP Version: 5.2.3 Assigned To: scottmac New Comment:
CLI and FAST-CGI can not handle persistent MySQL connections. How can an unloaded processes remember a connection? Turn that option off in php.ini and the error goes away. mysql.allow_persistent = Off The real problem here is that this option is set On in php.ini-recommended Previous Comments: ------------------------------------------------------------------------ [2007-07-13 10:16:00] [EMAIL PROTECTED] So that we won't forget. http://server.macvicar.net/patches/php-bug41350.patch ------------------------------------------------------------------------ [2007-06-28 10:02:15] chris at crgs dot co dot uk Scott is already aware of this, but I tried the snapshot from 12:30 27-06-2007 and it didn't fix the problem. However this might be because the fix from the MySQL bug is necessary as well, and currently the PHP snapshots contain libmysql.dll from PHP 5.0.37 rather than 5.0.45 (which is apparently the one we need). We may need to wait for MySQL to release their new version, and for the new libmysql.dll to make its way across to PHP, before the bug will be 'properly' fixed. ------------------------------------------------------------------------ [2007-06-26 12:00:57] [EMAIL PROTECTED] Please try using this CVS snapshot: http://snaps.php.net/php5.2-latest.tar.gz For Windows (zip): http://snaps.php.net/win32/php5.2-win32-latest.zip For Windows (installer): http://snaps.php.net/win32/php5.2-win32-installer-latest.msi I've committed a fix that should have resolved this. ------------------------------------------------------------------------ [2007-06-26 11:38:18] maxfm at abv dot bg Just go to the end of php.ini Change: [PHP_MYSQL] extension=php_mysql.dll to: ;[PHP_MYSQL] ;extension=php_mysql.dll Then go to: ;extension=php_mysql.dll and enable it: extension=php_mysql.dll ------------------------------------------------------------------------ [2007-06-24 09:37:28] ysangkok at gmail dot com I'm experiencing the same problem with 5.2.3. Using CGI on IIS5. I fixed it by using the dll from 5.2.1. ------------------------------------------------------------------------ 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/41350 -- Edit this bug report at http://bugs.php.net/?id=41350&edit=1