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

by

From the reference manual section B.3.2.12 Commands out of sync:

B.3.2.12 Commands out of sync

If you get Commands out of sync; you can't run this command now in your client code, you are calling client
functions in the wrong order.

This can happen, for example, if you are using mysql_use_result() and
try to execute a new query before you have called mysql_free_result().
It can also happen if you try to execute two queries that return data
without calling mysql_use_result() or mysql_store_result() in between.

This post from the MySQL forums has this to say:

I’ve solved that problem. I use MySQL-Fron instead MySQL Query
browser. And everything works fine.

Makes me think that it’s not a server or database problem but a problem in the tool you’re using.

More Related Contents:

  1. Stored procedure that Automatically delete rows older than 7 days in MYSQL
  2. Can I create view with parameter in MySQL?
  3. Pass array to MySQL stored routine
  4. Connect By Prior Equivalent for MySQL
  5. How to raise an error within a MySQL function
  6. MySQL stored procedure vs function, which would I use when?
  7. MySQL stored procedures use them or not to use them
  8. Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation ‘=’
  9. MySQL create stored procedure syntax with delimiter
  10. mysql dynamic query in stored procedure
  11. Writing optional parameters within stored procedures in MySQL? [duplicate]
  12. Dynamic table names in stored procedure function
  13. List of Stored Procedures/Functions Mysql Command Line
  14. passing LIMIT as parameters to MySQL sproc
  15. mysql stored procedure that calls itself recursively
  16. How do you debug MySQL stored procedures?
  17. How can I use transactions in my MySQL stored procedure?
  18. MySQL Stored Procedure Error Handling
  19. MySQL Stored Procedures not working with SELECT (basic question)
  20. use a variable for table name in mysql sproc
  21. Split a string and loop through values in MySQL stored procedure
  22. How to schedule a stored procedure in MySQL
  23. My SQL Dynamic query execute and get ouput into a variable in stored procedure
  24. MySQL : When stored procedure parameter name is the same as table column name
  25. What is dynamic SQL?
  26. How to use Table output from stored MYSQL Procedure
  27. How do I write an SP in phpMyAdmin (MySQL)?
  28. Call a stored procedure for each row returned by a query in MySQL
  29. Mysql stored procedure don’t take table name as parameter
  30. How to pass a variable to a IN clause?

Leave a Comment