Issue
When connecting to MySQL using initial SQL and custom SQL, the following error may occur:
Commands out of sync; you can't run this command now
Last Modified Date: 27 Mar 2020
Environment
- Tableau Desktop
- MySQL
- Initial SQL
- Custom SQL
Resolution
To troubleshoot this error, check that all variables mentioned in the custom SQL query have been assigned values in the initial SQL command.Cause
According to MySQL documentation, this error occurs when client functions are called in the wrong order.Additional Information
This error may also occur related to the version of the driver used.MySQL Error: Commands out of sync
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials