|  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #46262 FreeTDS error.
Submitted: 2008-10-09 05:55 UTC Modified: 2008-10-21 01:00 UTC
Avg. Score:4.0 ± 0.0
Reproduced:1 of 1 (100.0%)
Same Version:0 (0.0%)
Same OS:1 (100.0%)
From: manohar dot angani at gmail dot com Assigned:
Status: No Feedback Package: MSSQL related
PHP Version: 5.2.6 OS: Linux
Private report: No CVE-ID: None
View Add Comment Developer Edit
Welcome! If you don't have a Git account, you can't do anything here.
You can add a comment by following this link or if you reported this bug, you can edit this bug over here.
Block user comment
Status: Assign to:
Bug Type:
From: manohar dot angani at gmail dot com
New email:
PHP Version: OS:


 [2008-10-09 05:55 UTC] manohar dot angani at gmail dot com
We are using freetds .64 and it gives us an error when the same procedure is invoked twice with the same parameter.

Error: the XML response that was returned from the server is invalid.
sp_helpconstraint_new mt_cell_pull
    [0] => 00000
    [1] => 0
    [2] => (null) [0] (severity 0) [(null)]
    [3] => 0
    [4] => 0
sp_columns mt_cell_pull
sp_helpconstraint_new mt_dimension_selected
    [0] => 00000
    [1] => 0
    [2] => (null) [0] (severity 0) [(null)]
    [3] => 0
    [4] => 0
sp_columns mt_dimension_selected
sp_helpconstraint_new mt_cell_pull
    [0] => HY000
    [1] => 20019
    [2] => Attempt to initiate a new Adaptive Server operation with results pending [20019] (severity 7) [(null)]
    [3] => 0
    [4] => 7
    [5] => Success
DBEntidad::DBEntidad - tableInfo without data - Table: mt_cell_pull-Query Error: Attempt to initiate a new Adaptive Server operation with results pending [20019] (severity 7) [(null)]

Expected result:
The SQL error is thrown by FreeTDS and it shouldn't throw it.

Actual result:
SQL error ..


Add a Patch

Pull Requests

Add a Pull Request


AllCommentsChangesGit/SVN commitsRelated reports
 [2008-10-14 00:57 UTC]
Thank you for this bug report. To properly diagnose the problem, we
need a short but complete example script to be able to reproduce
this bug ourselves. 

A proper reproducing script starts with <?php and ends with ?>,
is max. 10-20 lines long and does not require any external 
resources such as databases, etc. If the script requires a 
database to demonstrate the issue, please make sure it creates 
all necessary tables, stored procedures etc.

Please avoid embedding huge scripts into the report.

 [2008-10-21 01:00 UTC] php-bugs at lists dot php dot net
No feedback was provided for this bug for over a week, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
 [2012-03-19 13:15 UTC] programmer at finner dot de
Bug still in 5.4. Assuming, $db is a database object which provides a connection 
via PDO/dblib, try
$con = $db->connect();
$query = $con->prepare("select id from table where param = ?");
while (true) {
  $query->bindParam(1, 4711);
  while ($row = $query->fetch(PDO::FETCH_ASSOC) {
    (do something with result)
If you provide different values at $quer->bindParam(), it works OK, also, if you 
prepare the query always new within the while loop. If you reuse the prepared 
query with the same parameter as in the loop before, the mentioned error will 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Fri Jun 21 06:01:30 2024 UTC