Hello! I have a main machine with Ignition 7.5.12 and several remote servers with Ignition 7.6.6. On the main machine i create the database connections pointed to remote servers. On the remote servers i have a tag history configured to local DB. Each remote server has unique system name. I create the easy chart component on the main server, go to costomize and add some tags from remote machines ([db_name/system_name]tag_path), click “ok” and have an error: “You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘OPTION SQL_SELECT_LIMIT=1’ at line 1”. What is wrong? Can somebody help?
Yes, the problem is that the remote mysql servers are probably 5.6+, and the main machine needs a new version of the MySQL JDBC driver.
Check out this kb article for more info.