Edit report at https://bugs.php.net/bug.php?id=63306&edit=1
ID: 63306 User updated by: mikeyap2005 at gmail dot com Reported by: mikeyap2005 at gmail dot com Summary: $stmt->fetchAll() then PHP/ Apache crashed -Status: Feedback +Status: Open Type: Bug Package: PDO related Operating System: windows 7 PHP Version: 5.3.17 Block user comment: N Private report: N New Comment: Thread 0 - System ID 9268 Entry point php_cgi!php_graceful_shutdown+3a5a Create time 18/10/2012 3:23:05 PM Time spent in user mode 0 Days 0:0:19.468 Time spent in kernel mode 0 Days 0:0:3.666 Full Call Stack Function Arg 1 Arg 2 Arg 3 Arg 4 Source php5!zend_register_internal_class_ex+ad0 01096bf8 000005f0 01096bf8 019b0918 php5!zend_mm_set_custom_handlers+26d 000005e2 019b05a0 00000000 000005e1 php5!zend_mm_set_custom_handlers+1048 019b05a0 000005e2 019afff0 030a2d24 php5!erealloc+25 019b05a0 000005e2 00000000 019b00e0 php_pdo_odbc+2d24 019afc38 00001000 00c0ca30 00c0ca44 php5!php_pdo_stmt_delref+2266 019ae808 019afc38 00000000 00000000 php5!zend_parse_parameters+5a 00000000 00000000 00000000 00000000 Previous Comments: ------------------------------------------------------------------------ [2012-10-18 19:22:52] paj...@php.net Check latest rev here: http://windows.php.net/downloads/snaps/php-5.3/r7aed21c/ there is a bug about the html page, which has to be fixed so it gets the right links again ------------------------------------------------------------------------ [2012-10-18 15:38:25] larue...@php.net Pierre, could you please look at this ? the debug package is 0 size ------------------------------------------------------------------------ [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] larue...@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