ID: 46289
Comment by: ramin dot farmani 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:
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
Previous Comments:
------------------------------------------------------------------------
[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
------------------------------------------------------------------------
[2009-02-20 03:23:12] michael dot cordover+php at gmail dot com
I also get this issue on WinXP SP2 (5.1 build 2600) running Apache
2.2.11.0 (from xampplite 1.7.0).
Interestingly this occurs with executing a PDO::prepare()d SELECT
statement but not on UPDATE or INSERT. This happens even when
PDOStatement::bindValue / bindParam is not used.
I cannot reproduce the "subtle change makes it work" described by
asylow.
I am unable to provide a backtrace.
--Code--
$dbConn = new PDO(DBDSN, DBUSER, DBPASS);
// Connection is definitely valid
$q = $dbConn->prepare('SELECT * FROM people');
$q->execute();
--Crash report--
AppName: apache.exe
AppVer: 2.2.11.0
ModName: php_pdo_mysql.dll
ModVer: 5.2.9.9
Offset: 0000249a
--PHP Version-- [per phpinfo()]
Was occurring on 5.2.8 and also on snapshot:
PHP Version 5.2.9RC3-dev
System Windows NT 18315XP 5.1 build 2600
Build Date Feb 18 2009 23:39:16
Configure Command cscript /nologo configure.js
"--enable-snapshot-build" "--enable-debug-pack"
"--with-snapshot-template=d:\php-sdk\bin\\..\snap_5_2\vc6\x86\template"
"--with-php-build=d:\php-sdk\bin\\..\snap_5_2\vc6\x86\php_build"
"--with-pdo-oci=D:\php-sdk\oracle\instantclient10\sdk,shared"
"--with-oci8=D:\php-sdk\oracle\instantclient10\sdk,shared"
--PDO Version-- [per phpinfo()]
pdo_mysql PDO Driver for MySQL, client library version 5.1.30
--MySQL Version--
C:\xampplite\mysql\bin>mysqld.exe --version
mysqld.exe Ver 5.1.30-community for Win32 on ia32 (MySQL Community
Server (GPL))
------------------------------------------------------------------------
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
