#31532 [NEW]: delete query failed

From: Date: Thu, 13 Jan 2005 09:32:19 +0000
Subject: #31532 [NEW]: delete query failed
Groups: php.bugs 
Request: Send a blank email to php-bugs+get-72048@lists.php.net to get a copy of this message 
From:             nikanorov at gmail dot com
Operating system: windows xp
PHP version:      4.3.10
PHP Bug Type:     MSSQL related
Bug description:  delete query failed

Description:
------------
On delete return -- "Changed database context to 'wakka'". SQL query runs
on SERVER, but mssql_query returns false.
 
This sql in Query Analizer works fine.

Server: IIS 5
MSSQL: MSSQL DEV 2000 SP3

RESULT OF EXAMPLE CODE: Query failed: delete from wakka_links where
from_tag = 'HomePage' (Changed database context to 'wakka'.)

Reproduce code:
---------------
<?
$sql="delete from wakka_links where from_tag = 'HomePage'";
$dblink = mssql_connect('localhost', 'sa', 'pass');
mssql_select_db('wakka', $dblink);
if (!$result =   mssql_query($sql, $dblink))
  {
    die("Query failed: ".$sql." (".mssql_get_last_message().")");
  }
?>

Actual result:
--------------
Query failed: delete from wakka_links where from_tag = 'HomePage' (Changed
database context to 'wakka'.)

-- 
Edit bug report at http://bugs.php.net/?id=31532&edit=1
-- 
Try a CVS snapshot (php4):   http://bugs.php.net/fix.php?id=31532&r=trysnapshot4
Try a CVS snapshot (php5.0): http://bugs.php.net/fix.php?id=31532&r=trysnapshot50
Try a CVS snapshot (php5.1): http://bugs.php.net/fix.php?id=31532&r=trysnapshot51
Fixed in CVS:                http://bugs.php.net/fix.php?id=31532&r=fixedcvs
Fixed in release:            http://bugs.php.net/fix.php?id=31532&r=alreadyfixed
Need backtrace:              http://bugs.php.net/fix.php?id=31532&r=needtrace
Need Reproduce Script:       http://bugs.php.net/fix.php?id=31532&r=needscript
Try newer version:           http://bugs.php.net/fix.php?id=31532&r=oldversion
Not developer issue:         http://bugs.php.net/fix.php?id=31532&r=support
Expected behavior:           http://bugs.php.net/fix.php?id=31532&r=notwrong
Not enough info:             http://bugs.php.net/fix.php?id=31532&r=notenoughinfo
Submitted twice:             http://bugs.php.net/fix.php?id=31532&r=submittedtwice
register_globals:            http://bugs.php.net/fix.php?id=31532&r=globals
PHP 3 support discontinued:  http://bugs.php.net/fix.php?id=31532&r=php3
Daylight Savings:            http://bugs.php.net/fix.php?id=31532&r=dst
IIS Stability:               http://bugs.php.net/fix.php?id=31532&r=isapi
Install GNU Sed:             http://bugs.php.net/fix.php?id=31532&r=gnused
Floating point limitations:  http://bugs.php.net/fix.php?id=31532&r=float
No Zend Extensions:          http://bugs.php.net/fix.php?id=31532&r=nozend
MySQL Configuration Error:   http://bugs.php.net/fix.php?id=31532&r=mysqlcfg

Thread (2 messages)

« previous php.bugs (#72048) next »