2014 – Commands out of sync; you can't run this command now

#2014 – Commands out of sync; you can’t run this command now

Now that can be a really annoying error!

It happens when querying stored procedures in phpMyAdmin as mysqli seems to return 2 sets of results opposed to the usual 1 that mysql returns.

You cannot call anything else until you have “flushed” or “cleared” the second result.

You can try using COMMIT to resolve this.

0 0 vote
Article Rating
Subscribe
Notify of
guest
2 Comments
Newest
Oldest Most Voted
Inline Feedbacks
View all comments
chemicaluser
chemicaluser
8 years ago

I have run into this before but I resolved it by calling the procedure from the locahost screen (main page when you log into phpmyadmin)

CALL mydatabase.myprocedure();

but it only works when you are under locahost