note 123708 added to mysqli-result.free

From: 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

« previous php.notes (#210414) next »