I have a job file for synchronising a couple of tables (one-way) between two databases, which was saved out from SQLYog Enterprise v5.12. On a new machine I have installed a new version, SQLYog Enterprise v6.1.
When trying to use the job file I get the following error in the log:
`courses_instance` 8190 8190 Error No. 1064
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 '`,`start_date`,`start_time`,`finish_time`,`price`,`notes`,`residential`,`on_spec' at line 1
1st Phase : 0 0 `courses_instance_visibility` 15702 15702 Error No. 1064
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 '`,`instance_id`,`site_id“ from id `courses_instance_visibility` group by 1 orde' at line 1
1st Phase : 0 0
Both source and target databases are running 5.0.45-community-nt.
Any assistance gratefully received.