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

can replicate table without autoincrement value

forums › forums › SQLyog › Using SQLyog › can replicate table without autoincrement value

  • This topic is empty.
Viewing 4 reply threads
  • Author
    Posts
    • December 21, 2004 at 2:47 am #8710
      onse
      Member

      Im have been using webyog to replicate the database, how ever if a table has no autoincrement value.. i get an error which says

      Check sja.log for complete error details.

      why doesnt webyog replicate a table without autoincrement field?

      Any help would really be appreciated.. thanks very much.. 🙂

    • December 21, 2004 at 2:50 am #16729
      Ritesh
      Member

      SJA requires a PRIMARY KEY to be defined for the table to be synced.

      Can you cut-n-paste the error message from sja.log out here?

    • December 22, 2004 at 1:36 am #16730
      onse
      Member

      this is the error im getting for that particular problem..

      No PRIMARY KEY defined in the table '`userslevels`'^M

      Sync started at Tue Dec 21 17:34:15 2004

      well do i really have to put a primary key for it? 🙁

      thanks for your reply.. 😀

    • December 22, 2004 at 3:22 am #16731
      Ritesh
      Member

      SJA requires a PRIMARY KEY to be defined on the table.

      The simplest way to add a PRIMARY KEY to a table would be to add an *autoincrement* column to the table.

    • December 23, 2004 at 6:08 am #16732
      onse
      Member

      Ok.. i will try that.. thanks for the help.. 🙂

      merry christmas.. 🙂

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