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

Categories: ContentGeneral

2 Comments

chemicaluser · September 16, 2012 at 01:10

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

    Andrew · September 17, 2012 at 13:58

    I believe this also only works the first time, until there’s a db cache clear..

Leave a Reply

Your email address will not be published. Required fields are marked *