DB update: Integrity constraint violation: 1062 Duplicate entry

Hello,

Please try to upgrade the module to the latest version, it contains a lot of known issues bug fixes.

https://www.drupal.org/project/multiple_registration/releases/3.2.0 →

The issue remains relevant also for 3.2.0 as nothing changed in multiple_registration_update_8204() since 3.1.1. The reason why it happens is that "multiple_registration" table contains records with duplicate uid's (and in our case coinciding rid's). I did not debug why those duplicates have been created, however as they are completely identical it must be safe to just delete them before declaring "uid" as a primary key.

A minor update for a newer MySQL version.

I recently updated this module from a version prior to 3.1.1 which added the Database Update with ID: 8204 (8204 - Add PK to {multiple_registration} table ).

I ran into the same issue running the database update via Drush.

Applying Patch #6 and running the database update again applied the update with no database errors.

Thank you for your patch. It looks good to me.

The patch has been committed. A new release will be created soon.

Automatically closed - issue fixed for 2 weeks with no activity.