After running the first group migration 'umn_dm_profile_staging', I am getting 37 errors:

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '103973222400' [error]
for key 'PRIMARY': INSERT INTO {digitalmeasures_migrate_profile} (id, userId,
category, xml, created) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1,
:db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4); Array
(
    [:db_insert_placeholder_0] => numberwashere
    [:db_insert_placeholder_1] => numberwashere
    [:db_insert_placeholder_2] => categorywashere
    [:db_insert_placeholder_3] => xmlwashere
    [:db_insert_placeholder_4] => numberwashere
CommentFileSizeAuthor
#2 digitalmeasures_migrate-1062-duplicate-entry-3054007-2-D8.patch465 byteshinte

Comments

hinte created an issue. See original summary.

hinte’s picture

hinte commented
StatusFileSize
new digitalmeasures_migrate-1062-duplicate-entry-3054007-2-D8.patch465 bytes

It looks like the 'id' field in digitalmeasures_migrate.install isn't unique enough to use as a 'primary key' anymore. There are 37 duplicates in the 'id' field. I have added an additional field in conjunction with 'id' to make it more unique.