Skip to content

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.

See also  How to delete an AWS WAF - Web ACL
Subscribe
Notify of
guest
2 Comments
Newest
Oldest Most Voted
Inline Feedbacks
View all comments
chemicaluser
chemicaluser
10 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

2
0
Would love your thoughts, please comment.x
()
x