I have a lot of data in a pointshop database which I converted to MySQL from pdata. Everytime I import the SQL file this happens:
SQL query: INSERT INTO `pointshop_data` VALUES ( '993283467', '260', '' ); MySQL said: Documentation #1062 - Duplicate entry '993283467' for key 'PRIMARY'
The issue is, the primary key is defined as uniqueid, which is unique, and shouldn’t have any duplicates. I have looked through the SQL dump and have found no duplicates of the many different ID’s it has thrown out at me.