Hi we stop our gateway for 3 weeks. when i run it again i found a lot of errors and all of trends not working. even when i make a new trend with generic tags .i receive below errors. [code]Exception: Error running query: TagHistory(paths=[M01223/PH RO1, M01223/PH RO2, M01223/PH RO3, M01223/PH RO…

Please check attached error screenshoot [image]

I think these errors look familiar, did you happen to upgrade to MySQL 5.6 recently?

Yes i upgrade MYSQL to the new version. ?? How can i solve the problem? Thanks for your support Tamer

MySQL 5.6 has some internal changes that don’t interact with the old JDBC driver and Ignition historian system very nicely. You’ll have to upgrade to the new JDBC driver. Start by downloading the zip from the ConnectorJ download page: dev.mysql.com/downloads/connector/j/ Extract mysql-connector-…

Hi James, Perfect. It working now. Thanks for your support [:thumb_right:] Tamer

Inductive Automation Forum

Error in your SQL syntax

Ignition

show post in topic

Home
Categories
Guidelines
Terms of Service
Privacy Policy

Powered by Discourse, best viewed with JavaScript enabled