MySQL 5.0.x error with PHP 5.2.3

andy18    SQL-related    

I was trying to setup a new Windows 2003 web server today and everything looks to be in order. It comes to my attention that phpmyadmin has just release 2.11.0 stable version 2 days ago. Without any further hesitation, I downloaded the latest zip files and extracted to the C:\inetpub\wwwroot\phpmyadmin. Next, I install PHP 5.2.3 and MySQL 5.0.45 to the box. While try to check on the PHP installation, it prompts the following on the CLI:

C:\php5>php-cgi.exe -v
PHP 5.2.3 (cgi-fcgi) (built: May 31 2007 09:37:20)
Copyright (c) 1997-2007 The PHP Group
Zend Engine v2.2.0, Copyright (c) 1998-2007 Zend Technologies
with the ionCube PHP Loader v3.1.32, Copyright (c) 2002-2007, by ionCube Ltd., and
with Zend Extension Manager v1.2.0, Copyright (c) 2003-2007, by Zend Technologies
with Zend Optimizer v3.3.0, Copyright (c) 1998-2007, by Zend Technologies
Error in my_thread_global_end(): 1 threads didn’t exist

“Error in my_thread_global_end(): 1 threads didn’t exist” has been discussed heavily in PHP bugs report 41350 Apparently the only way to resolve this is to grab the libmysql.dll from PHP 5.2.1 and replace it on PHP 5.2.2 / 5.2.3

Once the libmysql.dll has been replaced, I have no issues with the CLI test output. However, when I login as root to the Phpmyadmin, it shows me the following screen:

I ended up downgraded the PhpMyadmin version to 2.10.1. I will just have to wait either PHP and MySQL developer to release a patch to correct this.

If you enjoyed this article please consider sharing it!