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

Problems with SJA – Linux Version

forums forums SQLyog Sync tools, Migration, Scheduled Backup and Notifications Problems with SJA – Linux Version

  • This topic is empty.
Viewing 17 reply threads
  • Author
    Posts
    • #8380
      acmbc
      Member

      Hi,

      We are trying to use the command-line linux version of SJA to synchronize two remote databases.

      We are encountering error 1064 on several tables. This error only occurs in relatively few of the records in the tables, but results in the dbs not being properly synchronized.

      I should note that the field data in these tables contain many accented characters (portuguese) as well as text fields.

      I am sending an sja.log file for a synchronization operation which contains these errors (I have NO idea where the p&!!…..etc. strings come from. They are NOT in the field data.

      SJA.LOG:

      Sync started at Thu Mar 25 02:58:56 2004

      Error No. 1064

      You have an error in your SQL syntax near 'p&‼Bp&‼B' at line 1

      Error No. 1064

      You have an error in your SQL syntax near 'h&‼Bh&‼B' at line 1

      Error No. 1064

      You have an error in your SQL syntax near 'X&‼BX&‼B' at line 1

      Error No. 1064

      You have an error in your SQL syntax near '°%‼B°%‼B' at line 1

      Thanks for any help!

      Augusto Carvalho

    • #15607
      Shadow
      Member

      I did encounter similar problems regarding special Central European characters. It turned out that the backup db had wrong character set setting…

    • #15608
      acmbc
      Member

      I haven't checked the character set on the dbs – the “backup” db was created from a snapshot of the master db, and all the data *appears* right. I can try reexporting and specifying the character set to use.

    • #15609
      acmbc
      Member

      Nope – don't think it's the character set. For testing purposes, tried synchronzing between 2 db's on the same MySQL installation (they would have the same character sets). Still get the errors.

      Any ideas?

    • #15610
      Shadow
      Member

      Well, then I have no idea what could cause your problem. Doest the replication fail only on those records that contain special characters?

    • #15611
      acmbc
      Member

      Yes, as an example, one of the tables we are replicating – a product list – causes 4 failures out of 2515. Obviously this is only representative of the number of changed records since we made the “baseline” snapshot.

      We have tried replicating between 2 db's on the SAME server, as I said, and the problems still occur. As for the character sets, our production db is in 3.23.54, which does not seem to like explicit naming of characters sets, at the table level at least!

    • #15612
      Shadow
      Member

      Well, you should ask Ritesh, if you could send him the problematic records (given it's possible) and if he could debug sja using your data.

      MySql 3.x supports only one character set/server…

    • #15613
      Ritesh
      Member

      It will be very nice if you can email me a backup of the database.

    • #15614
      Shadow
      Member

      He even volounteers, you don't need to ask! 😀

    • #15615
      floyd
      Member

      Hello,

      I also encounter the same problem with using in linux verson

      Error No. 1064

      You have an error in your SQL syntax near 'h4Bh4B' at line 1

      Error No. 1064

      You have an error in your SQL syntax near 'x5Bx5B' at line 1

      Error No. 1064

      You have an error in your SQL syntax near 'h5Bh5B' at line 1

      Error No. 1064

      You have an error in your SQL syntax near 'X5BX5B' at line 1

      Error No. 1064

      You have an error in your SQL syntax near 'À4BÀ4B' at line 1

      my DB just have Eng. and Daytime. No any special language.

      and my MySQL version is 3.23.58-1.80 and 3.23.58-1.73 (Redhat rpm)

      any ppl have idea?

      Floyd

    • #15616
      Shadow
      Member

      Do you use any unusual (special) characters?

    • #15617
      floyd
      Member

      no….

      the following is a row of my DB

      404080804 20040408 07:30 26 2 804 810 a 1 0 0 2004-04-08 07:30:00

      just “:” and “-” two symbol

      Floyd

    • #15618
      Shadow
      Member

      Then – unfortunately – I cannot help. I don't have any computers around running linux…

    • #15619
      webshowpro
      Member

      Has there been any progress on this issue?

      The same thing is happening to me.:

      Error No. 1064^M

      SQL server version for the right syntax to use near 'Ã<8f>^SBÃ<8f>^SB' at line 1

      I use a cryus IMAP installation, and the database that is giving me trouble is used to authenticate IMAP users, the data basicaly is usernames and addresses and passwords

      I am running Mysql 4.0.15, on a RedHat 8.0 installation. I- I don't know how to tell which records specifically are causing the problem. Ot is happening on four records out of about 3000.

      -Brandon

    • #15620
      darthwonka
      Member

      I have the same problem.. sync worked a couple times then just started getting Error 1064 on one of our tables.

      Error No. 1064^M

      You have an error in your SQL syntax near 'order='3', display_thumb='0' where `id`='211'' at line 1^M

      Error No. 1064^M

      You have an error in your SQL syntax near 'order='2', display_thumb='0' where `id`='210'' at line 1^M

      Error No. 1064^M

      You have an error in your SQL syntax near 'order='0', display_thumb='0' where `id`='208'' at line 1^M

      Error No. 1064^M

      You have an error in your SQL syntax near 'order='1', display_thumb='0' where `id`='209'' at line 1^M

      Sync started at Thu May 20 11:49:29 2004

      All of these 'id's it is looking to match do not exist in the table. Also, of note, the id's are not necessarily in sequencial order.

      Thanks for any assistance.

      ( I emailed Ritesh with a backup of the table)

    • #15621
      Ritesh
      Member

      Hello,

      Which version of MySQL?

      Can you attach a dump of the database?

    • #15622
      darthwonka
      Member
      Quote:
      Hello,

      Which version of MySQL?

      Can you attach a dump of the database?

      The dump should be in your inbox… if you need it in another format, let me know.

      I am currently using mysql-server-3.23.58-1.9 on both machines.

    • #15623
      Ritesh
      Member

      I have received the dump. Thanks 🙂

Viewing 17 reply threads
  • You must be logged in to reply to this topic.