ID: 46289 Comment by: Parad0X dot UA at gmail dot com Reported By: asylow at free dot fr Status: Open Bug Type: PDO related Operating System: Windows XP SP3 PHP Version: 5.2.9 New Comment:
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. Previous Comments: ------------------------------------------------------------------------ [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. ------------------------------------------------------------------------ [2009-05-03 17:43:26] oddvibes at gmail dot com I'm having the same issue on Windows Vista. The following Windows crash information might be useful: Windows error-reporting creates the following error-messages: Faulting application apache.exe, version 2.2.11.0, time stamp 0x493f5d44, faulting module php_pdo_mysql.dll, version 5.2.8.8, time stamp 0x493d7650, exception code 0xc0000005, fault offset 0x0000250a, process id 0xf10, application start time 0x01c9c677df857f87. And: Faulting application apache.exe, version 2.2.11.0, time stamp 0x493f5d44, faulting module ntdll.dll, version 6.0.6001.18000, time stamp 0x4791a7a6, exception code 0xc0000005, fault offset 0x0006814c, process id 0x10d8, application start time 0x01c9c677ded2aa47. And after that, the following information: Fault bucket 1062083465, type 1 Event Name: APPCRASH Response: None Cab Id: 0 Problem signature: P1: apache.exe P2: 2.2.11.0 P3: 493f5d44 P4: php_pdo_mysql.dll P5: 5.2.8.8 P6: 493d7650 P7: c0000005 P8: 0000250a P9: P10: Attached files: C:\ProgramData\Microsoft\Windows\WER\ReportQueue\Report09c3bd88\WERAF65.tmp.version.txt C:\ProgramData\Microsoft\Windows\WER\ReportQueue\Report09c3bd88\WERAF66.tmp.appcompat.txt C:\ProgramData\Microsoft\Windows\WER\ReportQueue\Report09c3bd88\WERAFC4.tmp.hdmp C:\ProgramData\Microsoft\Windows\WER\ReportQueue\Report09c3bd88\WERBC91.tmp.mdmp These files may be available here: C:\ProgramData\Microsoft\Windows\WER\ReportArchive\Report0cdbcec7 Specs: * Windows Vista Home Edition * Apache 2.2 * MySQL 5.1.30 * PHP 5.2.8 ------------------------------------------------------------------------ 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