An error is returned referencing duplicate email addresses is returned when upgrading the database from 2.0 to 2.1

In newer iterations of the Curator Database, there is a protection in place to prevent duplicate emails as they are unique identifiers. However, this was not in place in earlier version. So, when the upgrade script encounters them, and an error is thrown.

Resolution. 

Run the below SQL to find and duplicate emails…

SELECT email, count(email) as count FROM users GROUP BY email HAVING COUNT(email) > 1;

You will need to correct the duplicates manually.

This script is also available on the server where curator is installed… C:/Program Files/IPV/Curator/Server/Sql/Helpers then find SelectDuplicateEmailAdresses.sql