ID: 16411 Comment by: abanet at pas dot ucm dot es Reported By: vielina at hn dot vnn dot vn Status: No Feedback Bug Type: MSSQL related Operating System: Windows 2000 PHP Version: 4.3.0 New Comment:
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>"; Previous Comments: ------------------------------------------------------------------------ [2003-05-12 07:23:03] pedro at fundacaounimed dot com dot br 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. ------------------------------------------------------------------------ [2003-02-08 20:26:16] xd1013 at 163 dot com 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 ------------------------------------------------------------------------ [2003-02-08 20:24:41] xd1013 at 163 dot com 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. ------------------------------------------------------------------------ [2003-01-20 04:00:09] [EMAIL PROTECTED] 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. ------------------------------------------------------------------------ [2003-01-15 21:19:06] modea_ph at odsec dot com 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)... ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/16411 -- Edit this bug report at http://bugs.php.net/?id=16411&edit=1