ID: 48363 Updated by: paj...@php.net Reported By: chris at crgs dot co dot uk Status: Bogus Bug Type: MySQL related Operating System: Windows Server 2003 PHP Version: 5.2.9 New Comment:
5.3.0 does not use libmysql anymore. Previous Comments: ------------------------------------------------------------------------ [2009-05-22 15:11:52] chris at crgs dot co dot uk In that case why not downgrade to the last version of MySQL that doesn't have this bug (5.0.22, supplied with PHP 5.2.1), so that everyone trying to set up PHP inside Windows doesn't have to jump through this extra hoop of copying DLLs around just to get the thing to work properly without hanging or error messages? ------------------------------------------------------------------------ [2009-05-22 15:06:03] paj...@php.net Complain to mysql instead. They change the compiler minimum versions and the latest 5.0.x are not compatible anymore with VC6 (which is what we use for PHP 5.2). They also break the binary compatibility. ------------------------------------------------------------------------ [2009-05-22 14:17:21] chris at crgs dot co dot uk Description: ------------ Ever since PHP 5.2.6, php.exe on Win32 can take a long time to close after generating a page when using the php_mysql.dll extension and the copy of libmysql.dll supplied with the Win32 distribution of PHP (currently version 5.0.51a). This can be resolved by updating libmysql.dll to a later version (e.g. the one supplied with MySQL 5.0.77), or downgrading to a lower version (e.g. the one supplied with PHP 5.2.1). MySQL 5.0.70+ contains the fix for http://bugs.mysql.com/bug.php?id=37226, which seems to be causing this issue. This is related to PHP bug #41350 - the error message described in that bug is no longer displayed in new versions of PHP, but the delay described by many others is still an issue. A number of people have asked in that bug for the copy of libmysql.dll supplied with PHP to be updated to 5.0.70+, but nothing has happened. Reproduce code: --------------- <? phpinfo();?> (Make sure the php_mysql.dll extension is enabled in php.ini) Run C:\PHP\php.exe C:\test.php Expected result: ---------------- PHP should close immediately after generating the phpinfo page. Actual result: -------------- PHP generates the phpinfo page, but hangs for 5 seconds before closing. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=48363&edit=1