Error: Duplicate entry for primary key

[mgrimesParticipant]

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 RosalesKeymaster]

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.

[Author]

Posts