SJA sqlwhere issue

[sry_not4sale]

Afternoon,

I am using SQLyog Job Agent Version 2.0 on a Fedora 2 box that is synching with another Fedora 2 box.

Both are running mysql 4.1.7-standard.

The issue is this:

I am trying to synch only the even rows in a table, however one table (and none of the others aparently) refuses to sync at all in one direction unless I take the sqlwhere clause out..

Im guessing its a problem with my schema?

The table that I'm having trouble with is `tblRecipient`

Heres the schema that doesn't work:

Code:

 
   
   
   
   
     localhost
     ezymail_sync
     ***********      3306      ezymail
   
   
     192.168.1.6
     ezymail_web
     **********      3306      ezymail
   
         

       `tblJob`
             

     

       `tblScan`
             

     

       `tblConfig`
             

     

       `tblClient`
                 (MOD( `ClientID`, 2 ) = 0) AND (modified IS NULL)
             

     

       `tblMail`
                 MOD( `status`, 2 ) = 0
             

     

       `tblRecipient`
                 MOD( `MailID`, 2 ) = 0
             

     

And this is the schema that does:

Code:

 
   
   
   
   
     192.168.1.6
     ezymail_sync
     ***********      3306      ezymail
   
   
     localhost
     ezymail
     *******      3306      ezymail
   
         

       `tblStaff`
             

     

       `tblSecurity`
             

     

       `tblPageInfo`
             

     

       `tblUserPreference`
             

     

       `tblClient`
                 (MOD( `ClientID`, 2 ) = 1) OR (`modified` IS NOT NULL)
             

     

       `tblMail`
                 MOD( `status`, 2 ) = 1
             

     

       `tblAdminPageInfo`
             

     

       `tblRecipient`
                 MOD( `MailID`, 2) = 1
             

     

       `tblStaffPermissions`
             

     

And here is the result message for the schema that doesnt work:

Code:

SQLyog Job Agent Version 2.0
Copyright (c) Webyog. All Rights Reserved.

Sync started at Wed Nov  3 15:16:00 2004

Table                      SrcRows  TgtRows  Inserted  Updated  Deleted
=========================  =======  =======  ========  =======  =======
`tblJob`                         3        3         0        0        0  
`tblScan`                        5        5         0        0        0  
`tblConfig`                      1        1         0        0        0  
`tblClient`                      7        7         0        0        0  
`tblMail`                        6        6         0        0        0  
`tblRecipient`                  12        7         0        0  

Total time taken – 0 sec(s)

What worries me is the lack of a Deleted value?

Any help/thoughts would be appreciated.. cheers!

[Ritesh]

This is a known bug in SJA 2.0 and has been fixed in SJA 4.0.

The Linux version of SJA 4.0 is not yet 4.1.7 compatible. We will be coming out with a new release soon.

I will keep you updated in this thread.

[sry_not4sale]

Was this fixed in the November 5 release?

Thanks,

Aaron

[Ritesh]

Yes.

[Author]

Posts