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.
mysqli_result::free
mysqli_result::close
mysqli_result::free_result
mysqli_free_result
(PHP 5, PHP 7)
mysqli_result::free -- mysqli_result::close -- mysqli_result::free_result -- mysqli_free_result — Libère la mémoire associée à un résultat
Description
Style orienté objet
public mysqli_result::free(): void
public mysqli_result::close(): void
public mysqli_result::free_result(): void
Style procédural
Libère la mémoire associée à un résultat.
Liste de paramètres
-
result -
Style procédural uniquement : Un objet mysqli_result retourné par mysqli_query(), mysqli_store_result(), mysqli_use_result(), ou mysqli_stmt_get_result().
Valeurs de retour
Aucune valeur n'est retournée.
Voir aussi
- mysqli_query() - Exécute une requête sur la base de données
- mysqli_stmt_get_result() - Récupère un jeu de résultats depuis une requête préparée
- mysqli_store_result() - Transfère un jeu de résultats à partir de la dernière requête
- mysqli_use_result() - Initialise la récupération d'un jeu de résultats
add a note
User Contributed Notes 3 notes
jack_action100 at hotmail dot example dot com ¶
5 years ago
Vector at ionisis dot com ¶
14 years ago
If you are getting this error:
Internal SQL Bug: 2014, Commands out of sync; you can't run this command now
Then you never called mysqli_result::free(), mysqli_result::free_result(), mysqli_result::close(), or mysqli_free_result() in your script, and must call it before executing another stored procedure.
