Home Forums OpenSync Error: Duplicate entry for primary key

This topic contains 1 reply, has 2 voices, and was last updated by  Yudel Rosales 3 years, 1 month ago.

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


    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!


    Yudel Rosales

    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.