php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #31532 delete query failed
Submitted: 2005-01-13 10:32 UTC Modified: 2005-01-13 21:11 UTC
Votes:2
Avg. Score:5.0 ± 0.0
Reproduced:0 of 0 (0.0%)
From: nikanorov at gmail dot com Assigned:
Status: Closed Package: MSSQL related
PHP Version: 4.3.10 OS: windows xp
Private report: No CVE-ID: None
 [2005-01-13 10:32 UTC] nikanorov at gmail dot com
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'.)

Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2005-01-13 21:11 UTC] derick@php.net
This bug has been fixed in CVS.

Snapshots of the sources are packaged every three hours; this change
will be in the next snapshot. You can grab the snapshot at
http://snaps.php.net/.
 
Thank you for the report, and for helping us make PHP better.
 
PHP Copyright © 2001-2022 The PHP Group
All rights reserved.
Last updated: Sat Oct 01 04:05:52 2022 UTC