#34080 [NEW]: recordset crash on trim and on fields with value null
From: mihkel at art dot tartu dot ee Operating system: MS-Win2000 SP4 PHP version: 5.0.4 PHP Bug Type: Unknown/Other Function Bug description: recordset crash on trim and on fields with value null Description: Database: MS-SQL Server 2000 (in case it is important) See code below. Expecting it to NOT hang forever and produce some output. Unfortunately - if ANY of the lines with crash comment behind them is present it will hang forever (until web-server timeout). 'user' - is a present field of type char(20) and value is never NULL. 'kursjuh' - is a present field of type char(1) and will result a crash only if field value is NULL. PHP fails to produce error log - so, no info there. Reproduce code: --- $db=new COM(ADODB.Connection); $db-Open(Driver={SQL Server};Server=***;Database=***;); $dta=$db-Execute(SELECT * FROM Qigus); while(!$dta-EOF) { echo $dta-Fields['kursjuh']-Value; // crash echo $dta['kursjuh']; // crash echo $dta['user']; // works fine echo trim($dta['user']); // crash $dta-MoveNext(); } -- Edit bug report at http://bugs.php.net/?id=34080edit=1 -- Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=34080r=trysnapshot4 Try a CVS snapshot (php5.0): http://bugs.php.net/fix.php?id=34080r=trysnapshot50 Try a CVS snapshot (php5.1): http://bugs.php.net/fix.php?id=34080r=trysnapshot51 Fixed in CVS:http://bugs.php.net/fix.php?id=34080r=fixedcvs Fixed in release:http://bugs.php.net/fix.php?id=34080r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=34080r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=34080r=needscript Try newer version: http://bugs.php.net/fix.php?id=34080r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=34080r=support Expected behavior: http://bugs.php.net/fix.php?id=34080r=notwrong Not enough info: http://bugs.php.net/fix.php?id=34080r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=34080r=submittedtwice register_globals:http://bugs.php.net/fix.php?id=34080r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=34080r=php3 Daylight Savings:http://bugs.php.net/fix.php?id=34080r=dst IIS Stability: http://bugs.php.net/fix.php?id=34080r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=34080r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=34080r=float No Zend Extensions: http://bugs.php.net/fix.php?id=34080r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=34080r=mysqlcfg
#34080 [Fbk-Opn]: recordset crash on trim and on fields with value null
ID: 34080 User updated by: mihkel at art dot tartu dot ee Reported By: mihkel at art dot tartu dot ee -Status: Feedback +Status: Open Bug Type: COM related Operating System: MS-Win2000 SP4 PHP Version: 5.0.4 New Comment: The crash is gone now. (for both trim and null fields) BUT. fields with the value NULL return now 'Object id #4' which doesn't sound right. Am i missing somethig and it is suposed to do so? (i would prefer 'NULL' or '' as return value) Previous Comments: [2005-08-11 13:22:38] [EMAIL PROTECTED] Please try using this CVS snapshot: http://snaps.php.net/php5-latest.tar.gz For Windows: http://snaps.php.net/win32/php5-win32-latest.zip [2005-08-11 13:15:04] mihkel at art dot tartu dot ee Description: Database: MS-SQL Server 2000 (in case it is important) See code below. Expecting it to NOT hang forever and produce some output. Unfortunately - if ANY of the lines with crash comment behind them is present it will hang forever (until web-server timeout). 'user' - is a present field of type char(20) and value is never NULL. 'kursjuh' - is a present field of type char(1) and will result a crash only if field value is NULL. PHP fails to produce error log - so, no info there. Reproduce code: --- $db=new COM(ADODB.Connection); $db-Open(Driver={SQL Server};Server=***;Database=***;); $dta=$db-Execute(SELECT * FROM Qigus); while(!$dta-EOF) { echo $dta-Fields['kursjuh']-Value; // crash echo $dta['kursjuh']; // crash echo $dta['user']; // works fine echo trim($dta['user']); // crash $dta-MoveNext(); } -- Edit this bug report at http://bugs.php.net/?id=34080edit=1
#34080 [Opn]: recordset crash on trim and on fields with value null
ID: 34080 User updated by: mihkel at art dot tartu dot ee Reported By: mihkel at art dot tartu dot ee Status: Open Bug Type: COM related Operating System: MS-Win2000 SP4 PHP Version: 5.0.4 New Comment: Update: $x=$rs['kursjuh']; echo 'x'.$x; echo 'x'.$rs['kursjuh']; gives me 'Object id #4Object id #5' - this can't be normal. Previous Comments: [2005-08-11 14:35:38] mihkel at art dot tartu dot ee The crash is gone now. (for both trim and null fields) BUT. fields with the value NULL return now 'Object id #4' which doesn't sound right. Am i missing somethig and it is suposed to do so? (i would prefer 'NULL' or '' as return value) [2005-08-11 13:22:38] [EMAIL PROTECTED] Please try using this CVS snapshot: http://snaps.php.net/php5-latest.tar.gz For Windows: http://snaps.php.net/win32/php5-win32-latest.zip [2005-08-11 13:15:04] mihkel at art dot tartu dot ee Description: Database: MS-SQL Server 2000 (in case it is important) See code below. Expecting it to NOT hang forever and produce some output. Unfortunately - if ANY of the lines with crash comment behind them is present it will hang forever (until web-server timeout). 'user' - is a present field of type char(20) and value is never NULL. 'kursjuh' - is a present field of type char(1) and will result a crash only if field value is NULL. PHP fails to produce error log - so, no info there. Reproduce code: --- $db=new COM(ADODB.Connection); $db-Open(Driver={SQL Server};Server=***;Database=***;); $dta=$db-Execute(SELECT * FROM Qigus); while(!$dta-EOF) { echo $dta-Fields['kursjuh']-Value; // crash echo $dta['kursjuh']; // crash echo $dta['user']; // works fine echo trim($dta['user']); // crash $dta-MoveNext(); } -- Edit this bug report at http://bugs.php.net/?id=34080edit=1
#34080 [Opn]: recordset crash on trim and on fields with value null
ID: 34080 User updated by: mihkel at art dot tartu dot ee Reported By: mihkel at art dot tartu dot ee Status: Open Bug Type: COM related Operating System: MS-Win2000 SP4 PHP Version: 5.0.4 New Comment: Correction: 'xObject id #4xObject id #5' (where is the edit button when you need one? :/ ) Previous Comments: [2005-08-11 14:47:39] mihkel at art dot tartu dot ee Update: $x=$rs['kursjuh']; echo 'x'.$x; echo 'x'.$rs['kursjuh']; gives me 'Object id #4Object id #5' - this can't be normal. [2005-08-11 14:35:38] mihkel at art dot tartu dot ee The crash is gone now. (for both trim and null fields) BUT. fields with the value NULL return now 'Object id #4' which doesn't sound right. Am i missing somethig and it is suposed to do so? (i would prefer 'NULL' or '' as return value) [2005-08-11 13:22:38] [EMAIL PROTECTED] Please try using this CVS snapshot: http://snaps.php.net/php5-latest.tar.gz For Windows: http://snaps.php.net/win32/php5-win32-latest.zip [2005-08-11 13:15:04] mihkel at art dot tartu dot ee Description: Database: MS-SQL Server 2000 (in case it is important) See code below. Expecting it to NOT hang forever and produce some output. Unfortunately - if ANY of the lines with crash comment behind them is present it will hang forever (until web-server timeout). 'user' - is a present field of type char(20) and value is never NULL. 'kursjuh' - is a present field of type char(1) and will result a crash only if field value is NULL. PHP fails to produce error log - so, no info there. Reproduce code: --- $db=new COM(ADODB.Connection); $db-Open(Driver={SQL Server};Server=***;Database=***;); $dta=$db-Execute(SELECT * FROM Qigus); while(!$dta-EOF) { echo $dta-Fields['kursjuh']-Value; // crash echo $dta['kursjuh']; // crash echo $dta['user']; // works fine echo trim($dta['user']); // crash $dta-MoveNext(); } -- Edit this bug report at http://bugs.php.net/?id=34080edit=1