From: piotr at clickthinking dot com Operating system: Windows 2003/2000/XP PHP version: Irrelevant PHP Bug Type: MSSQL related Bug description: Accessing MSSQL server crashes Apache
Description: ------------ I have checked this with PHP 4.3.10, 5.02, 5.03, latest snapshot and 5.0 in combination with Apache 2.0.53 and 1.3.33 (I tried all combinations). While running under Windows 2000, 2003 and XP and trying to connect to a MSSQL server (on my local machine or a different server) using adodb 4.61 (http://adodb.sourceforge.net) the apache server crashes reporting php5ts.dll to be the problem (a runtime error dialog box occurs that when clicked restarts apache). It crashes Apache entirely and apache stops loading pages until it is reset. There are no error messages in the apache logs and one has to look in event viewer to see what caused the problem. This crash happens randomly, it normally takes 8-10 refreshes of a page for a crash to occur (sometimes as many as 20 refreshes). It doesn't matter what page it is as long as the page pulls information from a MSSQL database. The same page pulling from the exact same database using MySQL does not produce any errors and just keeps running. Reproduce code: --------------- require_once('adodb/adodb.inc.php'); global $conn; $conn =& ADONewConnection('odbc_mssql'); $conn->SetFetchMode(ADODB_FETCH_BOTH); $dsn="driver={sql server}; server=localhost; database=arb_db;"; $conn->pconnect($dsn, 'sa', 'ididit'); // Putting pconnect or connect makes no difference" $sql = "SELECT Desc FROM Tours ORDER BY TourRank"; $rs = $conn->Execute($sql); Expected result: ---------------- I expect it to pull Desc field from the Tours Table in the arb_db database. Actual result: -------------- Apache crashes in the way described. Apache crashes with a runtime error dialog and an error is logged under event viewer. This occurs on Windows 2003/2000/XP on with PHP 4.3.10, 5.02, 5.03, latest snapshot and 5.0 in combination with Apache 2.0.53 and 1.3.33 (I tried all combinations). MSSQL 2000 and 97 were tried and MySQL 4.1 and 4.0. MySQL worked fine, MSSQL connection crashsed server. -- Edit bug report at http://bugs.php.net/?id=32253&edit=1 -- Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=32253&r=trysnapshot4 Try a CVS snapshot (php5.0): http://bugs.php.net/fix.php?id=32253&r=trysnapshot50 Try a CVS snapshot (php5.1): http://bugs.php.net/fix.php?id=32253&r=trysnapshot51 Fixed in CVS: http://bugs.php.net/fix.php?id=32253&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=32253&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=32253&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=32253&r=needscript Try newer version: http://bugs.php.net/fix.php?id=32253&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=32253&r=support Expected behavior: http://bugs.php.net/fix.php?id=32253&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=32253&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=32253&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=32253&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=32253&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=32253&r=dst IIS Stability: http://bugs.php.net/fix.php?id=32253&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=32253&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=32253&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=32253&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=32253&r=mysqlcfg
