MySQL Sync Error

  • 19Views
  • Last Post 18 January 2019
  • Topic Is Solved
0
votes
John Buerger posted this 17 January 2019

I've been with you for a while. I had a sync between Zoho and a MySQL database. First we were syncing with one table and it worked fine. Then I added a second table to the same sync and it worked for awhile but eventually broke - something about adding to an existing sync was the reason. Now I can't get a new sync to work at all, with one table or many. I keep getting this error:

'This version of MariaDB doesn't yet support 'multiple triggers with the same action time and event for one table'

I've left messages with the bot but I don't think it does anything with them nor does it pass them along. Seriously, if I can't get the sync to work, there is no reason to use your (or pay for) your service.

Order By: Standard | Newest | Votes
0
votes
Mariia Zaharova posted this 17 January 2019

Dear John!

Sorry for the delayed response.

 

Please see: https://dba.stackexchange.com/questions/105578/error-this-version-of-mariadb-doesnt-yet-support-multiple-triggers-with-the-s

The error you're getting means that your MySQL server does not allow tables to have several triggers with the same action at a time (i.e. after insert or before insert triggers, etc.).

 

When performing synchronization repeatedly, Skyvia synchronizes only data that was changed since the previous synchronization. For this, it creates special tracking tables and triggers in relational databases for data modification tracking. The parameter that is responsible for this in Synchronization package is InitTrackingObjects. When it is set to True this means that tracking tables and triggers were created for the tables. It is not recommended to add new tasks to the synchronization package which already performed initial sync. One of the reasons - tracking tables and triggers will not be created for newly added tables until the InitTrackingObjects parameter is reset. The recommended option is to use separate packages for new tasks or re-create the package with several tasks (new tasks and tasks that you have in an existing package).

 

In order to resolve mentioned error, we recommended you to try these steps:

- check triggers for the tables that are used in synchronization package directly in the database; delete them (Skyvia creates 3 triggers - with the insert, update, delete events, type - after);

- create new synchronization package (or check that InitTrackingObjects and LastSyncTime parameters are reset in existing one);

- run package.

 

Please notify us about the results.

0
votes
John Buerger posted this 18 January 2019

That fixed that problem. Now I get an error stating 

Unable to process your request. Please verify whether you have entered proper method name,parameter and parameter values.

And yet the data seems to transfer fine. I had to remove the primary key from Zoho in my MySQL database to make it work but everything else is good.

0
votes
Mariia Zaharova posted this 18 January 2019

Thank you for your reply.

Unable to process your request. Please verify whether you have entered proper method name,parameter and parameter values.

As I can see this error is resolved. Actually, thise error occurs at Zoho CRM side and requires further investigation. If you encounter this issue again or if you have any further questions, feel free to contact us.

 

Best regards,

Mariia

Close