Error No. 1064 problems

[[email protected]]

I am synchronizing a Linux based 4.0.18 MySQL db with a Windows 2003 based 4.0.18 MySQL db.

I am synchronizing 3 tables with a simple where clause.

My error log is full of this error:

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' at line 1

Error No. 1064

My xml script looks like this (minus host, user, passwords, ports, etc. I've changed <> to () ):

### (job version=”2.0″)

### (syncjob)

### (abortonerror abort=”no” /)

### (fkcheck check=”yes” /)

### (source)

### (host) (/host)

### (user) (/user)

### (pwd) (/pwd)

### (port) (/port)

### (database)media(/database)

### (/source)

### (target)

### (host) (/host)

### (user) i(/user)

### (pwd) (/pwd)

### (port) (/port)

### (database)media(/database)

### (/target)

### (tables all=”no”)

### (table)

### (name)`albums`(/name)

### (columns all=”yes” /)

### (sqlwhere)edit_status='APPROVED'(/sqlwhere)

### (/table)

### (table)

### (name)`artists`(/name)

### (columns all=”yes” /)

### (sqlwhere)edit_status='APPROVED'(/sqlwhere)

### (/table)

### (table)

### (name)`songs`(/name)

### (columns all=”yes” /)

### (sqlwhere)edit_status='APPROVED'(/sqlwhere)

### (/table)

### (/tables)

### (/syncjob)

### (/job)

I would appreciate it if anyone has any ideas about this.

[Ritesh]

I have replied to your mail.

[Author]

Posts