ID: 41350 Comment by: sharadrb at yahoo dot com Reported By: graham at directhostinguk dot com Status: No Feedback Bug Type: MySQL related Operating System: Windows 2003 PHP Version: 5.2.3 New Comment:
Even I had same issue with PHP version 5.2.5. So, I rolled back to older version 5.2.1 which does not have this issue. Now, I don't have this issue with version 5.2.1 Previous Comments: ------------------------------------------------------------------------ [2008-02-20 17:05:01] brandonkahre at charter dot net I am still experiencing this bug as of Feb-20-2008. I am running PHP 5.2.4 in a Windows XP environment with MySQL 4.2.20. To leave no room for confusion, the problems and steps I am using to recreate this bug are described in Bug #44009 (http://bugs.php.net/bug.php?id=44009). I have tried the following PHP versions: PHP 5.2.4 PHP 5.2.5 PHP 5.2.6-latest I have tried patching the Windows php_mysql.dll extension using the following sources: PHP 5.2.1: http://www.php.net/releases/#5.2.1 [copy /ext/php_mysql.dll only] - this did not fix any problems MySQL: http://dev.mysql.com/downloads/connector/php/ [mysql extension (PHP 5.2.0) for MySQL Server 4.1.21] - could not connect to MySQL server. Please note that the extension is for PHP 5.1.6.6 MySQL: http://dev.mysql.com/downloads/connector/php/ [mysql extension (PHP 5.2.0) for MySQL Server 5.0.27] - this did not fix any problems IT-Guys (mentioned in this bug tracker): http://www.it-etc.com/2007/10/25/php-error-524-getting-error-error-in-my_thread_global_end-1-threads-didnt-exit/ - this did not fix any problems. The extensions provided seem to be for PHP 5.2.0.0 ------------------------------------------------------------------------ [2008-02-13 17:25:20] byerly0503 at gmail dot com This bug caused me to spend an hour on the issue. I kept ignoring all of the help related to MySQL since the script I was trying to run, didn't use MySQL. Please fix this by including the right DLL or adjust the installer to give a warning message: "Despite downloading this package, you will need to download an older package, replace the mysql dll, in order to use PHP." ------------------------------------------------------------------------ [2008-02-08 06:56:04] OPunWide at hotmail dot com I'm a newbie at this, and am installing php for the first time. Very basic setup, running WinXP, using IIS 5.1 and PHP 5.2.5, installed using the Windows installer. When I first installed I included support for MySQL in the options, but had not installed MySQL. The error happened with a psp script consisting only of pspinfo(). I went back to the installer and removed support for MySQL and the problem went away. I don't think the folks at MySQL can be blamed for this one. ------------------------------------------------------------------------ [2008-02-07 22:27:08] WS6TA at txlanes dot com I have to agree about the impression this makes on potential LAMP adopters. I am a long-time Windows/MSSQL person looking at the LAMP stack as an alternative to MS. However, I download PHP 5.2.5 and start reading the manual only to get the error "Error in my_thread_global_end()" the first time I used the CLI. So, I go searching and find all kinds of references to dll swaps for PHP side AND the MySQL side. I don't even have MySQL installed yet... I was looking at PHP's ability to be a standalone scripting tool as well as a web-database tool. Anyway, I then find this thread where it appears the bug has been around since approximately May 2007 and PHP version 5.2.3. I commented out "extension=php_mysql.dll" in the php.ini to stop the error, but I think I will want this extension once I install MySQL. My hat's off to the people that started and have contributed to the PHP codebase. Please understand that I am not trying to bash anyone. I simply want to reiterate the PHP is crucial component to the LAMP stack and having to search for a bug fix on the very first run discourages potential new adopters. I'm very impressed with what I know about PHP thus far and would hate to think a potential adopter could be discouraged at square one in their evaluation. ------------------------------------------------------------------------ [2008-01-22 20:30:48] codeslinger at compsalot dot com Ping, Can we get php updated please? This problem is now one year old. Everyone who updates to the latest Windows php = 5.2.5 encounters this bug, it results in total breakage of loading the mysql dll. This bug has cost thousands upon thousands of man-hours to be expended/wasted by site admins in trying to locate the cause of the problem and the fix for it. In some cases it has also caused people to abandon the use of php-mysql programs altogether. According to MySQL Bug: http://bugs.mysql.com/bug.php?id=25621 The final resolution is that the problem was with mysql not php and that the problem was fixed awhile ago, and that all that is needed is for php to update to the latest mysql library. Given the fundamental importance of the php mysql interface, as in LAMP, it is inexplicable that it has taken an entire year to resolve what appears to have been a fairly simple fix. ------------------------------------------------------------------------ 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
