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.

2 thoughts on “2014 – Commands out of sync; you can't run this command now”

  1. 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

Leave a Reply

Your email address will not be published.