Syntax Error in sja generated comands

[JasonPotter]

Hi There,

I am trying to do a one-way sync of a single table and am getting the following error:

Error No. 1064^M

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 'group by 1 order by 2' a

Sync started at Mon Sep 13 23:43:58 2004

The db version is 4.0.14-standard running on linux for both databases.

The create script for the table at both ends is:

Code:

CREATE TABLE `eventspending` (    
          `EventID` bigint(20) NOT NULL auto_increment,
                `UnitID` char(50) NOT NULL default '',
                `EventDetailID` int(11) NOT NULL default '0',
                `SyncType` char(32) NOT NULL default '',    
                `SyncMethod` char(255) NOT NULL default '',  
                `Options` char(255) NOT NULL default '',    
                `File` char(255) NOT NULL default '',        
                `Package` char(255) NOT NULL default '',    
                `StartTime` datetime NOT NULL default '0000-00-00 00:00:00',
                `Complete` datetime default NULL,  
                `Attempts` int(11) NOT NULL default '0',
                `Active` char(1) NOT NULL default 'N',  
                PRIMARY KEY  (`EventID`,`UnitID`)  
              ) TYPE=MyISAM

my sync file is as follows:

Code:

[base Server]
root taxitaxi 3306 adbasestation

127.0.0.1
root taxitaxi 3306 ttremotedb

`eventspending`
`EventID` `UnitID` `EventDetailID` `SyncType` `SyncMethod` `Options` `File` `Package` `Active` UnitID = '00:0F:3D:0A:86:2F' and Active = 'Y'

I have attached some example data to put into the adbasestation db and then run the sync script. If someone else can add, delete and update rows in adbasestation db and do the sync without getting an error let me know. Also once you have done the first sync, delete about 4 rows from the ttremotedb and then redo the sync. This is when I get the problem.

Cheers

Jason

[Author]

Posts