note 123708 added to mysqli-result.free
| From: | jack_action100 at hotmail dot example dot com | Date: | Wed, 20 Mar 2019 12:43:53 +0000 |
| Subject: | note 123708 added to mysqli-result.free | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-210414@lists.php.net to get a copy of this message | ||
If you are STILL getting this error, even after freeing your results:
Internal SQL Bug: 2014, Commands out of sync; you can't run this command now
You may have a stored procedure in your query. A procedure can return more than one result set,
and it will always return one extra empty result set that carries some meta information on the
procedure call itself, especially error information. ( source: https://bugs.mysql.com/bug.php?id=71044 )
While calling single procedures, with one SELECT in them, using mysqli->query("CALL
stored_procedure();"), I had to do the following to make it work between two
calls:
<?php
$result->free();
$mysqli->next_result();
?>
It has no negative impact if you are not calling a stored procedure.
----
Server IP: 208.43.231.9
Probable Submitter: 82.199.157.34 (proxied: 184.160.246.63)
----
Manual Page -- http://php.net/manual/en/mysqli-result.free.php
Edit -- https://master.php.net/note/edit/123708
Del: integrated -- https://master.php.net/note/delete/123708/integrated
Del: useless -- https://master.php.net/note/delete/123708/useless
Del: bad code -- https://master.php.net/note/delete/123708/bad+code
Del: spam -- https://master.php.net/note/delete/123708/spam
Del: non-english -- https://master.php.net/note/delete/123708/non-english
Del: in docs -- https://master.php.net/note/delete/123708/in+docs
Del: other reasons-- https://master.php.net/note/delete/123708
Reject -- https://master.php.net/note/reject/123708
Search -- https://master.php.net/manage/user-notes.php