From: mikeyap2005 at gmail dot com
Operating system: windows 7
PHP version: 5.3.17
Package: PDO related
Bug Type: Bug
Bug description:$stmt->fetchAll() then PHP/ Apache crashed
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 bug report at https://bugs.php.net/bug.php?id=63306&edit=1
--
Try a snapshot (PHP 5.4):
https://bugs.php.net/fix.php?id=63306&r=trysnapshot54
Try a snapshot (PHP 5.3):
https://bugs.php.net/fix.php?id=63306&r=trysnapshot53
Try a snapshot (trunk):
https://bugs.php.net/fix.php?id=63306&r=trysnapshottrunk
Fixed in SVN: https://bugs.php.net/fix.php?id=63306&r=fixed
Fixed in release: https://bugs.php.net/fix.php?id=63306&r=alreadyfixed
Need backtrace: https://bugs.php.net/fix.php?id=63306&r=needtrace
Need Reproduce Script: https://bugs.php.net/fix.php?id=63306&r=needscript
Try newer version: https://bugs.php.net/fix.php?id=63306&r=oldversion
Not developer issue: https://bugs.php.net/fix.php?id=63306&r=support
Expected behavior: https://bugs.php.net/fix.php?id=63306&r=notwrong
Not enough info:
https://bugs.php.net/fix.php?id=63306&r=notenoughinfo
Submitted twice:
https://bugs.php.net/fix.php?id=63306&r=submittedtwice
register_globals: https://bugs.php.net/fix.php?id=63306&r=globals
PHP 4 support discontinued: https://bugs.php.net/fix.php?id=63306&r=php4
Daylight Savings: https://bugs.php.net/fix.php?id=63306&r=dst
IIS Stability: https://bugs.php.net/fix.php?id=63306&r=isapi
Install GNU Sed: https://bugs.php.net/fix.php?id=63306&r=gnused
Floating point limitations: https://bugs.php.net/fix.php?id=63306&r=float
No Zend Extensions: https://bugs.php.net/fix.php?id=63306&r=nozend
MySQL Configuration Error: https://bugs.php.net/fix.php?id=63306&r=mysqlcfg
