Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Error No. 1064 problems

forums › forums › SQLyog › Sync tools, Migration, Scheduled Backup and Notifications › Error No. 1064 problems

  • This topic is empty.
Viewing 0 reply threads
  • Author
    Posts
    • November 3, 2004 at 4:00 pm #8635
      [email protected]
      Member

      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.):

      media

      i

      media

      `albums`

      edit_status='APPROVED'

      `artists`

      edit_status='APPROVED'

      `songs`

      edit_status='APPROVED'

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

  • Author
    Posts
Viewing 0 reply threads
  • You must be logged in to reply to this topic.