#39727 [Opn->WFx]: Commands out of sync error when calling MySQL stored procedures from PHP

From: Date: Mon, 04 Dec 2006 11:33:57 +0000
Subject: #39727 [Opn->WFx]: Commands out of sync error when calling MySQL stored procedures from PHP
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-105861@lists.php.net to get a copy of this message 
 ID:               39727
 Updated by:       tony2001@php.net
 Reported By:      edoardo at wbr dot it
-Status:           Open
+Status:           Wont fix
 Bug Type:         MySQL related
 Operating System: Linux
 PHP Version:      4.4.4
 New Comment:

I'm afraid you'll have to upgrade to PHP5 in order to be able to use
MySQLi, which supports this and has mysqli_next_result() method.


Previous Comments:
------------------------------------------------------------------------

[2006-12-04 11:15:45] edoardo at wbr dot it

Description:
------------
From PHP I cannot call two stored procedure in the same connection (I
guess it depends on the fact they are returning MULTI_RESULTS, it
doesn't happen with normal SELECTs)

When I run the second one I get the following error: "Commands out of
sync; you can't run this command now".

I made a lot of tests with different MySQL versions, at the moment I'm
running a 5.0.27 built from source and PHP 4.4.4 built from source and
linked to 5.0.27 (not using the bundled library) and I get that error
but, for example, I got it working with client libraries from MySQL
5.1.7 beta (but not with 5.1.12 beta).

I already posted this bug to MySQL but they closed it telling it's not
a bug (http://bugs.mysql.com/?id=24783).
They pointed me at
http://dev.mysql.com/doc/refman/5.0/en/c-api-multiple-queries.html
but I cannot find a PHP equivalent for mysql_next_result


Reproduce code:
---------------
#!/usr/bin/php -q
<?php
define('CLIENT_MULTI_RESULTS', 131072);

$conn = mysql_connect("localhost", "root", "", 1 ,
CLIENT_MULTI_RESULTS) or die(mysql_error());
mysql_select_db("tester") or die(mysql_error());

$query = "CALL test_proc('webrainstorm')";

for ($i = 1; $i < 5; $i++) {
        $ret = mysql_unbuffered_query($query) or
die(mysql_error()."\n");
        while ($row = mysql_fetch_array($ret, MYSQL_ASSOC)) {
                foreach ($row as $col) {
                        echo "$col\t";
                }
                echo "\n";
        }
        mysql_free_result($ret);
        unset($ret);
}

mysql_close($conn);
?>

Find SQL test script at http://www.webrainstorm.it/tmp/test.sql

Expected result:
----------------
# ./test.php
enabled
enabled
enabled
enabled

Actual result:
--------------
# ./test.php
enabled
Commands out of sync; you can't run this command now


------------------------------------------------------------------------


-- 
Edit this bug report at http://bugs.php.net/?id=39727&edit=1

Thread (3 messages)

« previous php.bugs (#105861) next »