ID: 16411
Comment by: no at dontwantspam dot com
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:
On occasion, I get it on my win2k workstation running PHP 4.2.x on IIS5
with a max of 10 connections (limitation of the workstation version).
Usually only happens when I start up multiple browsers to check the
display of a single page and constantly refresh each one while tweaking
my code. Most of the time, there are no database calls involved (and
only mysql is installed).
However, also have it on another win2k machine with PHP 4.3.1 on IIS5
and mssql. CGI header misbehaving occured on a test site with less
than 10 people accessing it, and the server is configured for heavy
load.
Previous Comments:
------------------------------------------------------------------------
[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)...
------------------------------------------------------------------------
[2003-01-14 14:05:07] levinp at ctcgsc dot org
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.
------------------------------------------------------------------------
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
