ID: 16411
Comment by: [EMAIL PROTECTED]
Reported By: [EMAIL PROTECTED]
Status: Open
Bug Type: MSSQL related
Operating System: Windows 2000
PHP Version: 4.1.2
New Comment:
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.
Previous Comments:
------------------------------------------------------------------------
[2002-11-21 03:29:36] [EMAIL PROTECTED]
I have this problem too.
------------------------------------------------------------------------
[2002-06-20 15:19:45] [EMAIL PROTECTED]
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
------------------------------------------------------------------------
[2002-06-02 22:14:18] [EMAIL PROTECTED]
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.
------------------------------------------------------------------------
[2002-06-02 17:53:17] [EMAIL PROTECTED]
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
------------------------------------------------------------------------
[2002-04-03 09:46:44] [EMAIL PROTECTED]
I have the same set of php scripts, php 4.0.6 CGI running on:
1-Windows NT 4.0 with IIS4, MySQL, MS-SQL 7; this works fine;
2-Windows 2000 server with IIS5, MySQL, MS-SQL 7; this works fine;
3-Windows 2000 advanced server with IIS5, MySQL, MS-SQL 7; this works
fine;
4-Windows 2000 advanced server with IIS5, MySQL, MS-SQL 2000; this
still
works except that a curious error occurs:
Im using a lot of Header ("location: some.php") for redirections. In
this
particular installation, right after the call of header function, the
browser
still gets the right URI, but then it issues the following error (a
copy
again here):
<message>
CGI ERROR
CGI application misbehaved by not returning a complete set of
headers.The headers that it did return are:
</message>
The funny thing was that if I refresh the page then it works just
fine.
When I look back at the 4 installations, the only difference was the
installation 4: MS-SQL 2000.
I later made another test: from the installation 3, I made an upgrade
of MS SQL from 7.0 to 2000. The same problem happened.
I have tested with php 4.1.2 and 4.0.6. I had the same symptoms with
both versions
Is there anything in php_mssql that does the job with MS-SQL 2000 but
has some sort of side-effect that causes the above strange bug?
Would any one spend time looking into the code? It
would help us a lot.
Thank you very much!
Loi Le V.
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=16411&edit=1
