ID: 34784
Comment by: php at blazemonger dot com
Reported By: jwall at webpeak dot com
Status: Assigned
Bug Type: MSSQL related
Operating System: Windows XP
PHP Version: 5CVS-2005-10-08 (snap)
Assigned To: fmk
New Comment:
I am seeing this error on *every* MSSQL query under PHP 5.2.2, on
Windows 2003 Server x64, in the apache 2.2.4 error log file.
Previous Comments:
------------------------------------------------------------------------
[2007-07-03 23:39:38] vollmer at ampache dot org
I'm running into this same issue with large result sets.
I am running a Debian ETCH server with Apache2/PHP5.2
dpkg --list | grep "php"
ii libapache2-mod-php5 5.2.0-8+etch4
server-side, HTML-embedded scripting languag
ii php-pear 5.2.0-8+etch4
PEAR - PHP Extension and Application Reposit
ii php5-cli 5.2.0-8+etch4
command-line interpreter for the php5 script
ii php5-common 5.2.0-8+etch4
Common files for packages built from the php
ii php5-curl 5.2.0-8+etch4
CURL module for php5
ii php5-gd 5.2.0-8+etch4
GD module for php5
ii php5-ldap 5.2.0-8+etch4
LDAP module for php5
ii php5-mcrypt 5.2.0-8+etch4
MCrypt module for php5
ii php5-mysql 5.2.0-8+etch4
MySQL module for php5
ii php5-snmp 5.2.0-8+etch4
SNMP module for php5
ii php5-sybase 5.2.0-8+etch4
Sybase / MS SQL Server module for php5
The exact error I am seeing is
Query: SELECT * FROM L_U_t_State WHERE Status='1' (51 Rows returned)
Error: Changed database context to 'RMS'.
Complexity or speed of query doesn't appear to matter, my larger
multi-table selects/joins/unions do not produce the same error.
PHP Code that is producing the error message
<?php
/* Run the query*/
$result = mssql_fetch_assoc($result_resource);
if (!$result) {
debug_event('num_rows','Failed: ' . $sql .
mssql_get_last_message(),'1');
}
?>
-Karl Vollmer
------------------------------------------------------------------------
[2006-08-07 20:25:47] haunw at spcollege dot edu
I have this same issue on PHP 4.3.11(running as CGI) on Windows2000
server.
Happens intermittently. Only pattern seems to be that it is when SQL
Server is running a bit slower.
------------------------------------------------------------------------
[2006-06-16 14:14:51] hectorjazz at hotmail dot com
Corrected
------------------------------------------------------------------------
[2006-06-16 14:13:21] hectprjazz at hotmail dot com
extension of PHP 4.4.x (mssql.dll) = SQL Server 2000
extension of PHP 4.3.x (mssql.dll) = SQL Server 7
------------------------------------------------------------------------
[2006-03-24 21:15:21] zane dot wright at langley dot af dot mil
I also have the problem using 5.0.3 and a combination of PEAR's
LiveUser using DB.
It can be reproduced with a
$db =& DB::connect($dsn, $options);
var_dump($db->query('INSERT INTO liveuser_users_seq (vapor) VALUES
(0)'));
------------------------------------------------------------------------
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/34784
--
Edit this bug report at http://bugs.php.net/?id=34784&edit=1
