Bug #5433
"Command out of sync" Error with Run2Summary Table
Status:
Closed
Priority:
Normal
Assignee:
-
Start date:
02/13/2014
Due date:
% Done:
100%
Estimated time:
1.00 h
Description
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
History
#1 Updated by Bryan Dannowitz almost 7 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.
#2 Updated by Bryan Dannowitz almost 7 years ago
- Status changed from Resolved to Closed