#27054 [NEW]: query's fail after a couple of insert's&update's
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
Thread (6 messages)
- t dot noest at noestnet dot nl