"Command out of sync" Error with Run2Summary Table
Getting this error when submitting a new row to Run2Summary table:
INSERT INTO summary.Run2Summary (runID, runDate, runTime) SELECT 6299, DATE(FROM_UNIXTIME(1392094564)), TIME(FROM_UNIXTIME(1392094564)) >> Error creating RunSummary Entry (Ignoring error): Commands out of sync; you can't run this command now
#1 Updated by Bryan Dannowitz about 6 years ago
- Status changed from New to Resolved
- % Done changed from 0 to 100
In the MySQL C API, whenever a query is run that returns a result, such as a 'SELECT', 'SHOW', 'OPTIMIZE', etc., it is required to store the result via mysql_use/store_query() and then, when done with that result, to free it with mysql_free_result().
This was not done before the Run2Summary INSERT statement, and thus caused this error.
This has been resolved.