OpenSync

Home Forums OpenSync Error: Duplicate entry for primary key

This topic contains 1 reply, has 2 voices, and was last updated by  Yudel Rosales 1 year, 2 months ago.

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #62931

    mgrimes
    Participant

    I am getting the following error when syncing the Items table.

    [MySQL][ODBC 5.2(a) Driver][mysqld-5.5.5-10.0.20-MariaDB-log]Duplicate entry '800001CE-1291909121' for key 'PRIMARY': iteminventory QuantityOnSalesOrder in table items:-2147217900

    If I exclude the Items table from the sync, everything works fine (except the items table is populated of course). I’ve tried dropping and recreating the MySQL database without luck. Running v3.0.17 of OpenSync.

    Thanks for your help!

    #62951

    Yudel Rosales
    Keymaster

    We are working on that issue. In the meantime you will have to remove the primary key attribute and the index on each table that throws that error. Sorry for the inconveniences.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.