I have been trying to migrate tables from one database to another and it's been going fine until receiving the following error. It states that there is a syntax error near "(" at position 100.
What does position 100 refer to? Also, I presume that a syntax error relates to the underlying command in the output block?
Please see the attached screenshot and let me know if you might know the cause of the problem.
We need to view the Database output block "Configuration" and "Publish method" and the Field organiser to see the types and names of the fields which are being written to the database.
We also need to know what type of database it is and the table structure.