[jdhr]

jdhr wrote on Nov 29 2004, 03:57 PM:

Hi,

Does anyone knows if I can use MySql 4.0.20d functions inside a sqlwhere tag in the XML sync shema?

e.g.

Code:

TicFechaEntrada = DATE_FORMAT(TicFechaSalida, '%Y-%M-%D')

Thanks for ur help.

Sorry for this post…. i´ve realized, it has been answered in an older post.

Thanks.

[jdhr]

Thanks for your answer Shadow,

about primary keys, does sja have any problem if I define mor than one Primary Key on a Table??

[jdhr]

Shadow,

I´ve already checked the table in both sides and it doesn`t seem to be corrupted. Can u tell me:

– What`s your mysql version? and

– Do u know if the sja.exe file that comes with SQLyog 3.71 trial has any restriction?

Thanks

[jdhr]

Hi Ritesh, this is the complete output:

Code:

SQLyog Job Agent Version 2.0
Copyright   Webyog. All Rights Reserved.

Sync started at Tue Jul 13 12:20:00 2004

Warning : Source and Target MySQL versions are not matching.
Source : 4.0.20a, Target : 4.0.20a-nt.
SJA may not work properly because of the difference in behaviour of concat_ws()
across multiple MySQL versions.

Table                      SrcRows  TgtRows  Inserted  Updated  Deleted
=========================  =======  =======  ========  =======  =======
`dboaparcaderologin`            12       10         0        0  No change
`dboticket`                    152      150         4        0  No change
`dbotickettarifas`             208      216         1        1  No change
`dboticketusuario`             219      183

Look i have changed the xml file so it sync more tables, but is like a timeout happened and doesn`t sync dboticketusuario (it doesn`t even shows the taken time). If we sync only dboticketusuario, it does the same.

So, what can i do?

[jdhr]

Hi Shadow,

Whe´ve done that and the only thing that generates in the sja.log is

Code:

Sync started at Tue Jul 13 11:00:00 2004
 Warning : Source and Target MySQL versions are not matching.
Source : 4.0.20a, Target : 4.0.20a-nt.
SJA may not work properly because of the difference in behaviour of concat_ws() across multiple MySQL versions.

What do u think?

[jdhr]

Sorry,

the target is 4.0.20a-nt and the source 4.0.2a. We installed the 4.0.20d in both but winmysqladmin shows 4.0.20a, is the server version correctly?

Thanks

[jdhr]

Ok,

mysql version is 4.0.2.d in target an source. The target uses win2003 and source win98 so Source : 4.0.20a-nt and Target : 4.0.20a.

the xml file used is

Code:

localhost
root 3306 autonorpe

//the target ip //
root 3306 autonorpe

`dboticketusuario`

the table structure is as the file shows

[Author]

Posts