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

data sync error on one table

forums › forums › SQLyog › Sync tools, Migration, Scheduled Backup and Notifications › data sync error on one table

  • This topic is empty.
Viewing 4 reply threads
  • Author
    Posts
    • June 30, 2004 at 7:58 am #16035
      Ritesh
      Member

      Please paste the result for the following query:

      Code:
      show keys from `yourdb`.`users2`
    • June 30, 2004 at 8:58 am #16036
      aeon
      Member
      Quote:
      users2id1idA1868\N\N\

      or in XML :

      Code:

      users2

      0id
      1idA 1868(NULL)(NULL)

    • June 30, 2004 at 12:27 pm #16037
      Ritesh
      Member

      As you can see there is no PRIMARY KEY defined. I can only figure out one index that is named id

    • June 30, 2004 at 2:10 pm #16038
      Shadow
      Member

      It's been repeatedly told that SQLyog data manipulating features (including sja) work if and only if there is a primary key defined in the table(s) that is(are) affected by a feature!

    • June 30, 2004 at 5:12 pm #16039
      aeon
      Member

      Whoops :wacko: – could have sworn – … Must double check before posting … Sorry folks! blush

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