Data sync deleting rows in target db

[billy44]

I am using the trial version, and it seems to run ok and quickly, however I get this:

`Agentsmoney` 31 31 0 0 31

`Agentszip` 153 153 0 0 0

`Agreements` 311 311 0 0 0

sure enough, the target db, table agentsmoney is empty…

[Ritesh]

Which versions of MySQL & SQLyog are you using?

Can you mail me the table sturcture and sample data for Agentsmoney?

[wwwild]

I had the same issue when doing a sync between a MySQL 3.23.x server and MySQL 4 server.

[Ritesh]

This is an issue when you try to sync data between a MySQL 3.23.x server and a 4.x server.

Both the versions return different checksums for the same data when used along with concat_ws(). This results in incorrect working of SJA.

It is recommended to sync data between same versions of MySQL.

[billy44]

I changed my version of mysql and it did in fact work correctly, except these errors in the log:

No PRIMARY KEY defined in the table '`Completed`'

No PRIMARY KEY defined in the table '`Online`'

No PRIMARY KEY defined in the table '`State_Alabama`'

No PRIMARY KEY defined in the table '`State_Alaska`'

I cannot define a primary key in these dbs because the user is inserting the information manually, including the id and all..

is there a work around on this error?

[Ritesh]

Right now you need to have a PRIMARY KEY defined for a table to be synced. That is the only way to determine a unique row of data in a table.

We are working on a work-around where SJA will automatically truncate the data in the target table and do a complete insert from source to target.

[Ritesh]

The best workaround is to add an auto-increment column in the table.

[Author]

Posts