php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Bug #27054 query's fail after a couple of insert's&update's
Submitted: 2004-01-26 20:18 UTC Modified: 2004-01-28 20:23 UTC
From: t dot noest at noestnet dot nl Assigned:
Status: Closed Package: MSSQL related
PHP Version: 4CVS, 5CVS OS: windows nt4 sp6
Private report: No CVE-ID: None
View Add Comment Developer Edit
Welcome! If you don't have a Git account, you can't do anything here.
You can add a comment by following this link or if you reported this bug, you can edit this bug over here.
(description)
Block user comment
Status: Assign to:
Package:
Bug Type:
Summary:
From: t dot noest at noestnet dot nl
New email:
PHP Version: OS:

 

 [2004-01-26 20:18 UTC] 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

Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2004-01-26 20:19 UTC] 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:44 UTC] t dot noest at noestnet dot nl 
Install of Latest Stable(4.3.5RC2-dev) did not change anything. And I checked the script runs and is not cached etc.
 [2004-01-26 21:36 UTC] sniper@php.net 
Do you get more information why the queries fail if you 
add 'var_dump(mssql_get_last_message());' after the mssql_query line(s)?
 [2004-01-27 06:19 UTC] t dot noest at noestnet dot nl 
No, the 'last message' stay's the same after the failing queries.
 [2004-01-28 20:23 UTC] t dot noest at noestnet dot nl 
Something went wrong in my DBAL with the parsing of the commands.... :-( My fault. mssql does not tell that it did not get any commands...., mysql does.

Look at it from the good side: query's in excess of 1 kb are no problem. Now I'm sure.

Sorry Folks!
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved. 		Last updated: Wed Apr 24 02:01:30 2024 UTC