ID: 35637
Updated by: [EMAIL PROTECTED]
Reported By: realbenzin at inbox dot lv
-Status: Open
+Status: Feedback
Bug Type: MySQLi related
Operating System: Win XP SP2
PHP Version: 5.1.1
New Comment:
How about showing how you defined the procedure?
Previous Comments:
------------------------------------------------------------------------
[2005-12-12 07:11:29] realbenzin at inbox dot lv
It is not the same!!!!! Because I am calling the sp twice and sp
contains only one select not two like in that other "bug". PS i red
about that multi query, but that won`t help me...
------------------------------------------------------------------------
[2005-12-11 23:30:56] [EMAIL PROTECTED]
Duplicate of bug #32882.
------------------------------------------------------------------------
[2005-12-11 23:22:07] realbenzin at inbox dot lv
5.0.15
------------------------------------------------------------------------
[2005-12-11 23:12:55] [EMAIL PROTECTED]
What mysql version are you connecting to?
------------------------------------------------------------------------
[2005-12-11 22:49:42] realbenzin at inbox dot lv
Description:
------------
When mysql stored procedures are called twice in a row I get mysqli
error "Lost connection to MySQL server during query", it does not
happen if I do it once or in row with simple sql statements... Mysql is
ok, and no free_result is helping...
Reproduce code:
---------------
$db = new mysqli('localhost','root','qwerty','VT_SYS');
$u = $db->query("call spRazList(NULL);");
$u = $db->query("call spRazList(NULL);") or die('asdasdad'.$db->error);
Expected result:
----------------
That stored procedure would execute twice with no errors.
Actual result:
--------------
Mysqli error "Lost connection to MySQL server during query"
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=35637&edit=1
