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 Developer Edit
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
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

Pull Requests

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: Sun Dec 22 06:01:30 2024 UTC