Please try it again with a right header like Location: http://www.domain.tld/some.php. Location header needs a complete absolute URI.

Regards, Kai

I did that but it still did not work. I further tested another way: I left every thing as it was, except that I did not open an MSSQL connection. The script worked pretty well. When I changed it back, the same type of bug happened. When looking at phpinfo, even with the latest php version (4.2.1) I saw that in the MSSQL support section, the MSSQL library version was 7.0. Is this a potential source of that bug?

Loi Le V.

Same problem, slightly different case...

win2000 running php.exe 4.2.1 (and mssql 2000)

seems to happen mostly during redrects like...

header("Method: GET");
header("Status: 302 Moved");
header("Location: ". $ABSOLUTE_URL);

some claim they solved this problem by applying the workaround by microsoft (Q160422).

others say they have fixed this by blanking out the doc_root in php.ini

I still have this problem

I have this problem too.

What are you doing with your database connections? Are they persistant (mssql_pconnect) or transient (mssql_connect)? Do you close your connections explicitly (mssql_close) before the end of your script?

vielina, your connections will be closed each time as you are running under the CGI.

Database connections are all transient.

In the original code, I did not close the connections because php would do that at the end of script. But as I was in doubt, I later made a close right before calling the function header() but the same problem happened.

I also made another test: in the script I just opened and immediately right after colsed it. The same bug happened.

When I removed that tiny chunk of code, every thing worked just fine.

Database connections are all transient.

In the original code, I did not close the connections because php would do that at the end of script. But as I was in doubt, I later made a close right before calling the function header() but the same problem happened.

I also made another test: in the script I just opened and immediately right after colsed it. The same bug happened.

When I removed that tiny chunk of code, every thing worked just fine.

Please try using this CVS snapshot:

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

i'm also experiencing this error with win xp, mssql 2000, and php 4.3.0 rc3.

is it a problem with php, or with the mssql libraries?

I have the same problem. Platform: PHP different versions, SQL Server 2000 and Windows 2000.

I see it a lot when the server is busy, or when two requests are made really fast after another.

Really need a solution for this.

No feedback was provided for this bug for over 2 weeks, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

Looks like feedback exists -> open

I have experienced the same bug when running Win2000 Server and MS Sql 2000. MS SQL 7 would not produce this error.
The error has been reproduced in all PHP versions I've tried up to 4.3.0.

I've tried to use delays and change preformance parameters in MSSQL, but no luck there.

A temporary solution would be to rewrite the code to use ODBC for database calls. This cannot be considered a acceptable solution, but it does work for us until this bug is corrected.

What version of the MDAC are all of you using?  I've heard that the latest MDAC causes a lot of problems and that many users are downgrading to the last version.  Just wondering if this might be true or not for any of you.

Updating version

I can also verify the problem.  MSSQL_ call followed by a header redirect produces this problem more often than it doesn't.  IIS5 with php 4.2.x.
 
Since I've been fighting this problem off and on over the last few months, I've had to switch to ODBC to meet an upcoming launch date.  However, I'll continue to follow and contribute any info I can when time allows.

I too get this error message.  I am using Win 2000, IIS; and Perl 5.6.1.  My Perl script is simply:
  print "hello";
so I do not think the problem has anything to do with SQL.

I just found the solution, at least for my problem.
I have a very simple Perl script, that was giving this error.
When I added to the top of the file:
  print "Content-type: text/html\n\n";
the error from IIS is gone.

I hope this helps you PHP folks.

I doubt that Perl solution will fix this, but I hope that this issue stays at the forefront until it can either be fixed with a PHP-side workaround or we find someone at microsoft who's friendly to our cause (not easy to do when you keep making fun of their name).  

From what I've seen in a lot of messages, mostly looking at #9852, and have seen some common threads:

Most people with this issue have SQL 2000.
Mpwti have fast servers.
Mpwti have redirects (location: or javascript's).

Some people have fixed this by changing server priority.
Sphftb implementing delays in their redirects.
Sphftb installing MDAC and security patches.
Sphftb setting IIS bandwidth limitations.
Sphftb switching away from PHP :[

It appears to a layman (who has many friends in QA roles) that we have a problem with nearly simultaneous invocations of PHP -and- MSSQL.  Early in this thread, vielina indicated that they never encountered this problem until SQL2K, so it would seem that a slave to the mssql extension dll is the suspect.

This supports most of the workaround suggestions I've seen - changing foreground/background status would impact the execution times of these scripts, slow links would prevent the redirect from turning into a GET so quickly, etc.  Some people have had luck using javascript redirects - I have seen improvement, but not elimination of the issue.  

For myself, I'm considering just doing away with my attempts to rewrite dirty, complicated URLs.  I feel for those with frameset apps, as there really is no avoiding this in such an environment.

One thought I just had, but it's a phenomenal longshot -- anyone diddle with the SQL Server Compatibility level in the SQL2K server parms?  You can set compat. to earlier versions, but I have no clue what that means.  I have never reproduced this on localhost (WinXP with PWS and MSDE SQL server)...

No feedback was provided. The bug is being suspended because
we assume that you are no longer experiencing the problem.
If this is not the case and you are able to provide the
information that was requested earlier, please do so and
change the status of the bug back to "Open". Thank you.

I change connection to ODBC,but this appear too.
when I press F5 button,It work well.
can u solute it? 
It's a serious problem.
now,I had to change my script from php to jsp\asp
But I really did't want to give up php.
:((( it 's hard to write english for me.

part for my connection class as fllow
--------------------------------------
class Connection{
	var $CID;
	var $Status=0;
	//Establish Connection to SQL Server
	function open($Host=CON_HOST,$User=CON_USER,$Pwd=CON_PWD){
	  if($this->Status==1) return $this->CID;
      $this->CID=mssql_connect($Host, $User, $Pwd); 
	  mssql_select_db(CON_DB);
	  $this->Status=1;
	  return $this->CID;
	}
	function execute($sql){
	  mssql_query($sql,$this->CID);
	  return mssql_rows_affected($this->CID);
	} 
	//Close Connection
	function close(){
	  return mssql_close($this->CID);
	} 

} // end class

I think I find the solution for this problem...
Just put this line "cgi.rfc2616_headers = 1" on php.ini.
Please, send us a message if it works. I had this problem during much time and looking for solution, I saw that many others have it too.

PS.: sorry if there is some english error.

After a lot of time trying redirection with header
and always getting "CGI application misbehaved by not returning a complete set of ..." error after an SQL 2000 insert instruction I tried this with success:

print "<html><head><META HTTP-EQUIV='Refresh' CONTENT='0;URL=url'></head></html>";

I've got the same problem and I can't find a solution. I'm using 2 computers as I do some work at work and at home. My configs are pretty much the same in both computers. Both work under Win Xp SP1 Pro, IIS 5.1, PHP 4.3.4 and MySql 4.0.
This only happens at work, at home it works just fine, never had any problem. I'm scared I will have to reinstall my system anytime for some other reason and see this issue bothering me at home too.

Some say it is CPU speed related but I don't know. My home PC is P4 with HT and at work I use an AMD Duron based system. Doesn't seem that relevant.

Most of the comments refer to a MSSQL issue but I use Mysql and I have this same problem too. I read somewhere it's related to the use of frames. I thought so but when using header redirection I encounter the same annoying message.

I even tought of installing Apache instead of IIS but the MS web server seems a lot less scary, I'm just a newbie. I can't find a reason for this to happen only at my work PC. Please help

Using FastCGI solve this problem.

I am having the same porblem, and I would like to know that anyone has a solution for this problem.

i experience this error only when using database connectivity just before  a redirect. With alot of reading and research that contradicts, i found that if you use 

sleep(1); //make script wait one second

just before headers being send this reduces drastically the chances of getting this error, not a 100% fix but i would estimate about a 95%.