data sync error on one table

[aeon]

Hi I am using SQLyog 3.71 and synching a remote MySQL server with a local MySQL. All works fine on lots of databases and tables with the database synchronisation tool running under Windows scheduling agent except for one table in one db.

The error at the time if I run the job manually shows:

Quote:

 

Warning : Source and Target MySQL versions are not matching.

Source : 3.23.37, Target : 3.23.52.

SJA may not work properly because of the difference in behaviour of concat_ws() across multiple MySQL versions.

Table                      SrcRows  TgtRows  Inserted  Updated  Deleted

=========================  =======  =======  ========  =======  =======

`downloads`                      4        4         0        0        0  

`mregistrations`                41       41         0        0        0  

`users2`                   Error !! Please check the log file for details.

The only error I can find in sjasession.xml (always assuming that is the correct place to look) says:

Quote:

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

Perhaps its to do with the versions as reported as there is a primary key on the table in question.

Odd that I do not have a problem on other tables though… This one is a little larger than most of the others I have to copy at a couple of thousand rows but otherwise not much different. Any thoughts?

[Ritesh]

Please paste the result for the following query:

Code:

show keys from `yourdb`.`users2`

[aeon]

Quote:

users2id1idA1868\N\N\

or in XML :

Code:

users2

0id
1idA 1868(NULL)(NULL)

[Ritesh]

As you can see there is no PRIMARY KEY defined. I can only figure out one index that is named id

[Shadow]

It's been repeatedly told that SQLyog data manipulating features (including sja) work if and only if there is a primary key defined in the table(s) that is(are) affected by a feature!

[aeon]

Whoops :wacko: – could have sworn – … Must double check before posting … Sorry folks! blush

[Author]

Posts