#15632 [Opn->Fbk]: MSSQL querys cause major problems

ID: 15632 Updated by: iliaa@php.net Reported By: tyler@coastergames.net -Status: Open +Status: Feedback Bug Type: MSSQL related Operating System: Windows 2000 PHP Version: 4.1.1 New Comment: Please try using this CVS snapshot: http://snaps.php.net/php4-latest.tar.gz For Windows: http://snaps.php.net/win32/php4-win32-latest.zip Previous Comments: ------------------------------------------------------------------------ [2002-04-20 19:56:55] martijn@ideeweb.nl 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 ------------------------------------------------------------------------ [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' ------------------------------------------------------------------------ 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