Quickbooks -> MySQL Primary Key Error - QuickBooks API / Integration Forums

OpenSync

Tagged: MYSQL, odbc, OpenSync, quickbooks

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

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

Author
Posts
May 15, 2019 at 9:06 pm #65316

justin7
Participant
I get the following error:
Failed: [MySQL][ODBC 3.51 Driver][mysqld-5.7.22-log]Duplicate entry ‘302-1475100863’ for key ‘PRIMARY’: componentitemline in table buildassembly:-2147217900
I tried to rebuild quickbooks data file but to no avail. Any ideas?
May 22, 2019 at 8:11 am #65336

Yudel Rosales
Keymaster
you have to remove the primary key from buildassembly table.
Author
Posts

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

You must be logged in to reply to this topic.