From: t dot noest at noestnet dot nl Operating system: windows nt4 sp6 PHP version: 4.3.4 PHP Bug Type: MSSQL related Bug description: query's fail after a couple of insert's&update's
Description: ------------ win nt4 sp6a fresh SQLServer install with sp4. ntwdblib.dll 7.00.839 . PHP 4.3.4 from your windows executable installer, as cgi with IIS 4.0. Textsize and TextLimit 2147483647, rest standard. After an insert, a select (computed result), a select, then a, quite lenghty, insert, then an computed select, and then nope, nada! Tried: free_result, free statement(works on what? not my SQLstring, my cn, my rs var's ?) Disconnect DB and connect again: nope! the most simplest SELECT, even on some other table returns "Warning: mssql_query(): Query failed in..." Reverse the order: the 2nd statement after the lenghty insert he's gone. Rerun the script does exact the same thing.... Now I need this statements to be done in this order! Other (shorter) scripts run fine! This was the same with PHP4.3.3 Updating didn't change this sithuation. I feel silly, do I have to make some sort of 2-pass script to get my work done? Reproduce code: --------------- Debug output of my script including all the SQL statements: http://www.noestnet.nl/php/problem.txt script of database: http://www.noestnet.nl/php/problembase.sql flat file's with data from db: http://www.noestnet.nl/php/problembase1.txt ..base3.txt I would not like to expose this for to long... Can you guy's give me a wink when you got 'em? Thanks in advance, Thomas -- Edit bug report at http://bugs.php.net/?id=27054&edit=1 -- Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=27054&r=trysnapshot4 Try a CVS snapshot (php5): http://bugs.php.net/fix.php?id=27054&r=trysnapshot5 Fixed in CVS: http://bugs.php.net/fix.php?id=27054&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=27054&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=27054&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=27054&r=needscript Try newer version: http://bugs.php.net/fix.php?id=27054&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=27054&r=support Expected behavior: http://bugs.php.net/fix.php?id=27054&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=27054&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=27054&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=27054&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=27054&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=27054&r=dst IIS Stability: http://bugs.php.net/fix.php?id=27054&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=27054&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=27054&r=float
