|  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
Anyone can comment on a bug. Have a simpler test case? Does it work for you on a different platform? Let us know!
Just going to say 'Me too!'? Don't clutter the database with that please — but make sure to vote on the bug!
Your email address:
Solve the problem:
2 + 23 = ?
Subscribe to this entry?

 [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-2023 The PHP Group
All rights reserved.
Last updated: Fri Dec 08 07:01:27 2023 UTC