Bug #63306 [Opn]: $stmt->fetchAll() then PHP/ Apache crashed
Edit report at https://bugs.php.net/bug.php?id=63306&edit=1
ID: 63306
Updated by: laruence@php.net
Reported by: mikeyap2005 at gmail dot com
Summary: $stmt->fetchAll() then PHP/ Apache crashed
Status: Open
Type: Bug
Package: PDO related
Operating System: windows 7
PHP Version: 5.3.17
-Assigned To:
+Assigned To: pajoye
Block user comment: N
Private report: N
New Comment:
Pierre, could you please look at this ? the debug package is 0 size
Previous Comments:
------------------------------------------------------------------------
[2012-10-18 14:55:07] mikeyap2005 at gmail dot com
the debug pack for php 5.3.17 is 0 mb
http://windows.php.net/snapshots/
sorry, this is my first time to debug php
------------------------------------------------------------------------
[2012-10-18 14:26:43] laruence@php.net
Thank you for this bug report. To properly diagnose the problem, we
need a backtrace to see what is happening behind the scenes. To
find out how to generate a backtrace, please read
http://bugs.php.net/bugs-generating-backtrace.php
for *NIX and
http://bugs.php.net/bugs-generating-backtrace-win32.php
for Win32
Once you have generated a backtrace, please submit it to this bug
report and change the status back to "Open". Thank you for helping
us make PHP better.
------------------------------------------------------------------------
[2012-10-18 14:23:57] mikeyap2005 at gmail dot com
Description:
------------
when i call $stmt->fetchAll() then PHP/ Apache crashed,thereafter browser will ask download the
script file.
sql is "SELECT data_x FROM sysuser" , datatype of the data_x is text, crashed only when
the select statement contain field which is text datatype.
i'm using MSSQL 2008 R2 Express
It is crashed for PHP version 5.3.13 and 5.3.14 either
i use zend server or using wamo or setup my own server ,
however it is ok for PHP version 5.3.8 and 5.2.x.
Test script:
---------------
$conn = new PDO('odbc:Driver={SQL
Server};Server=SERVERNAME;Database=DATABASE;','USERID', 'USERPASSWORD');
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$_sql = "SELECT data_x "; // please make sure the data type is "text"
$_sql.= " FROM gmcmm_user";
$stmt = $conn->prepare($_sql);
$stmt->setFetchMode(PDO::FETCH_ASSOC);
$stmt->execute();
var_dump($stmt->fetch()); // this line will caused the crash
------------------------------------------------------------------------
--
Edit this bug report at https://bugs.php.net/bug.php?id=63306&edit=1
Thread (10 messages)