Data Synchronisation (sqlyog Job Agent V5.30)

[Alistair Moffatt]

I'm having some problems synchronising two databases with the Enterprise Trial edition.

First of all, I created a new database by “cloning” one of my existing databases. I then selectively deleted some records from the new database.

I then wanted to use SJA to synchronise the two databases once more, such that the deleted records in my new database were effectively restored.

I selected a single table to synchronise, but received an error message when trying to sync. The error message in the log file says:

`races` 948 915 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 ' concat(sum(conv(substring(md5(concat_ws(“,”,`racedate`,`course`,`racetime`,`tit' at line 1

I would like to narrow down the problem, but have no idea where to find the query that SQLyog generated. Is it stored anywhere? Or written to a log file somewhere?

The structure of the table in question is as follows:

CREATE TABLE `races` (

`racedate` date NOT NULL default '0000-00-00',

`course` varchar(20) NOT NULL default '',

`racetime` time NOT NULL default '00:00:00',

`title` varchar(150) default NULL,

`class` varchar(10) default NULL,

`miles` int(11) default NULL,

`furlongs` int(11) default NULL,

`yards` int(11) default NULL,

`distance` int(11) default NULL,

`predicted_going` varchar(10) default NULL,

`age_limit` varchar(10) default NULL,

`runners` int(11) default NULL,

`allweather` char(1) default 'N',

`amateur` char(1) default NULL,

`apprentice` char(1) default NULL,

`banded` char(1) default NULL,

`chase` char(1) default NULL,

`claiming` char(1) default NULL,

`conditional` char(1) default NULL,

`handicap` char(1) default NULL,

`hunter_chase` char(1) default NULL,

`hurdle` char(1) default NULL,

`ladies_only` char(1) default NULL,

`maiden` char(1) default NULL,

`mares_only` char(1) default NULL,

`national_hunt` char(1) default NULL,

`nh_flat` char(1) default NULL,

`novice` char(1) default NULL,

`nursery` char(1) default NULL,

`seller` char(1) default NULL,

`2yo` char(1) default NULL,

`3yo` char(1) default NULL,

`4plus` char(1) default NULL,

PRIMARY KEY (`racedate`,`course`,`racetime`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

Any ideas as to the problem?

Alistair

[peterlaursen]

we need more info!

1) Can you tell if this happens with the first row of data or later?  this is important because it will give a hint if this is dataspecific or not.

2) SQLyog version and MySQL version.  

3) can you attach the jobfile, please.  A dump with a few rows on each host to reprouce with would be nice too!

[Alistair Moffatt]

peterlaursen wrote on May 4 2007, 09:13 PM:

we need more info!

1) Can you tell if this happens with the first row of data or later?  this is important because it will give a hint if this is dataspecific or not.

2) SQLyog version and MySQL version.  

3) can you attach the jobfile, please.  A dump with a few rows on each host to reprouce with would be nice too!

1) First row of data as far as I can tell. If I examine the target table after the sync, no data appears to have been transferred.

2) SQLyog v5.30 and MySQL 4.1.22-community-nt

3) job file and a cut-down version of the source and target tables (as dumps) attached.

Thanks for your help.

Alistair

[adarsh]

Hello,

Thanks for reporting.

We have fixed the issue for you and you can download the not release version from the following link:

http://www.webyog.com/downloads/betas/not_…531EntTrial.exe

Try this and let us know the details.

Thanks

Adarsh

[Alistair Moffatt]

adarsh wrote on May 9 2007, 12:45 PM:

Hello,

Thanks for reporting.

We have fixed the issue for you and you can download the not release version from the following link:

http://www.webyog.com/downloads/betas/not_…531EntTrial.exe

Try this and let us know the details.

Thanks

Adarsh

The fix seems to work just fine.

Thanks for taking the time to track this down and to fix it at such short notice.

Alistair

[Author]

Posts