Bug #15632 Updated: MSSQL querys cause major problems

ID: 15632 Updated by: martijn@ideeweb.nl Reported By: tyler@coastergames.net Status: Open Bug Type: MSSQL related Operating System: Windows 2000 PHP Version: 4.1.1 New Comment: After some hasling with the configuration, I have found a solution (for both mod_php and CGI) in setting the mssql.compatability_mode option to 'Off': mssql.compatability_mode = Off I also noticed this bugreport, with the same solution: http://bugs.php.net/bug.php?id=15890 Previous Comments: ------------------------------------------------------------------------ [2002-04-20 19:06:29] martijn@ideeweb.nl I experience the same problem using Apache 1.3.20 on Windows 2000. The bug shows with mod_php and PHP as CGI (both 4.1.2). SQL Server 2000 (Dev. Ed.) is installed on the same machine. Connecting to the server and selecting a database is no problem, but any call to mssql_query() causes PHP to crash. I find no messages in the errorlog (except for a 'Premature end of script headers' with the CGI version). Interesting is the fact that mssql_query() behaves as expected (no errors) only if the query returns 0 rows. ------------------------------------------------------------------------ [2002-02-20 17:09:38] tyler@coastergames.net Additonal info: This occurs under apache as well, but I get an internal script error. The problem occurs when a call to mssql_query matches at least one row. If a query does not match anything, PHP does not crash. But if it does, it crashes. ------------------------------------------------------------------------ [2002-02-20 14:16:09] sander@php.net Reopened. ------------------------------------------------------------------------ [2002-02-20 13:45:03] tyler@coastergames.net Hrmm, can't seem to reopen. The status box only shows 'Bogus' ------------------------------------------------------------------------ [2002-02-20 13:43:28] tyler@coastergames.net Sorry. With the above configuration, calls to at least mssql_query(); result in a PHP timeout. PHP apparently continues to run, or at least the webserver thinks it is, and the users browser does not display a new page until PHP times out. Behavior is weird, and an example is perhaps weird. <?php mssql_connect("host","user","pass"); echo "Foo!"; #Outputs Foo! <?php mssql_connect("host","user","pass"); echo "Foo!"; #Echos nothing apparently flush(); #Doesn't help; $q = mssql_query("some query"); The first case works, the 2nd doesn't. ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/15632 -- Edit this bug report at http://bugs.php.net/?id=15632&edit=1