Bug #15083 Updated: Big bug with mssql_fetch_xxxx methods

ID: 15083 Updated by: nirav@magnet-i.com Reported By: mi@cemag.de Status: Closed Bug Type: MSSQL related Operating System: Windows 2000 Pro PHP Version: 4.1.1 New Comment: I had the same problem with Windows XP Pro, MSSQL 2000 and PHP 4.1.1 / 4.1.2, Apache 1.3.20 MSSQL functions were working fine otherwise, but it used to crash with mssql_fetch_array function. If I called mssql_fetch_row, it crashed once, but still showed some output in the browser. Keeping set_magic_quotes_runtime(false); solved the issue. I hope this gets fixed soon. Thank you. Previous Comments: ------------------------------------------------------------------------ [2002-01-18 03:22:06] mi@cemag.de <? ////////////////////////////////// // // Apologize for the bug information, // the mssql functions work fine... // But the problem occurs only when set_magic_quotes_runtime is set to true on PHP 4.1.1 // with version 4.0.6, the problem don't appear. // set_magic_quotes_runtime(true); $conn = mssql_connect(yourHostname, yourUsername, yourPassword); mssql_select_db(yourDatabase, $conn); $result = mssql_query("SELECT name FROM Country"); // name type nchar $count = mssql_num_rows($result) $value = array(); for($i = 0; $i < $count; $i++) { $value[] = mssql_fetch_object($result); } print_r($value); mssql_free_result($result); mssql_close($conn); ?> ------------------------------------------------------------------------ [2002-01-17 13:45:59] sander@php.net Status -> feedback ------------------------------------------------------------------------ [2002-01-17 13:44:39] sander@php.net Can you provide a sample script? ------------------------------------------------------------------------ [2002-01-17 09:17:48] mi@cemag.de On PHP 4.0.6 on Windows 2000 Pro I use the php_mssql.dll extension to access mssql server 7.0 and all the method works very well. (hum!! only the problem with ntext type but with CAST(yourfieldname AS text) on the SQL query, that disappears) After updating to PHP 4.1.1 on Windows 2000 Pro The same code crashes Apache and Windows displays a dialog box with : Apache.exe The instruction at "0x006db197" referenced memory at "0x043bcc3a". The memory could not be "written". I have search for a long time in the SQL query but in reality the problem is not there... The problem depends of the type returned by the query. All the numerical types work fine but all the string types like char, nchar, text, ... result in crashes. This problem appears only when you try to read the result with mssql_fetch_xxxx methods... My configuration : Windows 2000 Pro MSSQL SERVER 7.0 APACHE 1.3.20 PHP 4.1.1 (same problem with PHP 4.1.0) ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=15083&edit=1