#27054 [Fbk->Opn]: query's fail after a couple of insert's&update's

From: Date: Tue, 27 Jan 2004 01:44:32 +0000
Subject: #27054 [Fbk->Opn]: query's fail after a couple of insert's&update's
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-53937@lists.php.net to get a copy of this message 
 ID:               27054
 User updated by:  t dot noest at noestnet dot nl
 Reported By:      t dot noest at noestnet dot nl
-Status:           Feedback
+Status:           Open
 Bug Type:         MSSQL related
 Operating System: windows nt4 sp6
 PHP Version:      4.3.4
 New Comment:

Install of Latest Stable(4.3.5RC2-dev) did not change anything. And I
checked the script runs and is not cached etc.


Previous Comments:
------------------------------------------------------------------------

[2004-01-26 20:19:32] sniper@php.net

Please try using this CVS snapshot:

  http://snaps.php.net/php4-STABLE-latest.tar.gz
 
For Windows:
 
  http://snaps.php.net/win32/php4-win32-STABLE-latest.zip



------------------------------------------------------------------------

[2004-01-26 20:18:50] t dot noest at noestnet dot nl

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 this bug report at http://bugs.php.net/?id=27054&edit=1

Thread (6 messages)

« previous php.bugs (#53937) next »