Duplicate entry '##' for key 'PRIMARY' query: INSERT INTO migrate_map_records_import... [#764678]

When I execute the migrate command via the GUI, I get a bunch of these:
user warning: Duplicate entry '##' for key 'PRIMARY' query: INSERT INTO migrate_map_records_import_people (sourceid, destid, needs_update) VALUES('85', 817, 0) in /Sites/mysite/sites/all/modules/migrate/migrate.module on line 367.

I'm just beginning to explore the Migrate module so I'm not really clear on the map view, and what it is doing, yet...

I have an external database of people records. They are related, via primary key, to two other tables in the external db - one with links - which should map to the cck links type field associated with the content type, and the other with files, which should map to the cck filefield type in the content type.

What this seems to be doing is preventing me from getting multiple link type fields created for the content type. Only one link field type shows up on the import.

Comments

Comment #1

thekenshow commented 1 June 2010 at 13:04

The map view contains the mapping of source ids to destination (e.g., node, user) ids and allows migrate to determine whether to update an existing item or create a new one. You might discover that duplicate items are being created in your case.

I ran into something similar when importing nodes after adding a tw relationship on the source view that resulted in empty fields appearing in the primary key column. I could see these in the tw browser interface but not when looking at the actual table originally created by tw. When I removed the relationship, the empty values and the errors disappeared. Hope this helps.