ID: 46289
Updated by: [email protected]
Reported By: asylow at free dot fr
-Status: Open
+Status: Bogus
Bug Type: PDO related
Operating System: Windows XP SP3
PHP Version: 5.2.9
New Comment:
Ok, it was then the classic case where MySql's libmysql DLL was used
instead of the version bundled with PHP. We already have many bogus
reports about this issue and your solution is the right one (as explain
in the other reports).
Previous Comments:
------------------------------------------------------------------------
[2009-09-02 03:07:10] Parad0X dot UA at gmail dot com
I was able to fix this by removing MYSQL from Windows' PATH env
setting. Looks like when PHP is looking for libmysql.dll it uses the
first one it finds in mysql\bin and it's not quite compatible.
Or you can try to add php to the path before mysql.
I hope that helps.
------------------------------------------------------------------------
[2009-06-22 03:53:32] ramin dot farmani at gmail dot com
Hi
similarly my httpd.exe crashed when i runnig a site wroten by Yii
framework it's seem we have a big problem in php_pdo_mysql library I
using php 5.2.10
------------------------------------------------------------------------
[2009-05-24 18:04:07] dave at abo dot co dot uk
I have a similar occurrence when running through apache2.2 and mysql 5
When running a page via apache with mysql query it crashes
szAppName : httpd.exe szAppVer : 2.2.11.0
szModName : php5ts.dll
szModVer : 5.2.9.9 offset : 0000ac7a
however when running the same page through php cli it works fine
Running PHP 5.2.9-2 (cli) (built: Apr 9 2009 08:23:19)
Copyright (c) 1997-2009 The PHP Group
Zend Engine v2.2.0, Copyright (c) 1998-2009 Zend Technologies
Here is my example code
It crashes frequently on the mysql_connect line other times it appears
to get as far (compiling) as the mysql query
<?
$cMysqlDatabase = 'develop';
$cMysqlUsername = 'develop';
$cMysqlPassword = 'develop';
$cMysqlDatabase = 'develop_dev';
$mysql_link = mysql_connect($gcMysqlHost1, $cMysqlUsername,
$cMysqlPassword);
$bDatabaseSelected = mysql_select_db($cMysqlDatabase, $mysql_link);
print "hello\n";
$nTestLevel = 1;
if ($nTestLevel > 0)
{
print " nTestLevel > 0";
$query = "show tables\n";
print "Query = $query";
$mysql_result = mysql_query($query, $mysql_link);
if ($mysql_result)
{
while ($arTables = mysql_fetch_assoc($mysql_result))
{
print_r($arTables);
}
}
else
{
print "error ". mysql_error($mysql_link) . "\n";
}
}
print "end\n";
?>
------------------------------------------------------------------------
[2009-05-08 19:10:51] mattgrdinic at yahoo dot com
I can confirm this bug as well. The solution was similar to above, I
replaced the php_pdo_mysql.dll and php_pdo.dll which were version
5.2.9.9 with ones from my 5.2.8 install (which were version 5.2.8.8(,
and all works as expected.
------------------------------------------------------------------------
[2009-05-03 19:01:26] oddvibes at gmail dot com
I fixed this problem on my computer. In my case it seems to have to do
something with the Xammp installation. It probably would be interesting
to know if the other people who were experiencing this problem were also
running on xammp.
I found this sollution by searching the web and found it on the
Magento-forum:
http://www.magentocommerce.com/boards/viewthread/31789/
The solution is simple:
- Download:
http://windows.php.net/downloads/snaps/php-5.2-win32-VC6-x86-latest.zip
- Unzip & copy libmysql.dll into xampp\apache\bin & xampp\php.
- Restart apache.
------------------------------------------------------------------------
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/46289
--
Edit this bug report at http://bugs.php.net/?id=46289&edit=1
