We’re in the process of upgrading from 3.2.12 to 4.0.19.
During conversion of database charset from latin1 to utf8 I run the command
php hs convert:base
During conversion of table 31 of 43 i get the following error (sensitive data omitted):
31 of 43 base tables copied. Tables.
[===================>--------]SQLSTATE: Integrity constraint violation: 1062 Duplicate entry ‘firstname.lastname@example.org’ for key ‘hs_portal_login_semail_unique’ (SQL: insert into
xLogin) values (…
I’m not familiar with mysql so maybe i misreading the error, but i read this as there are duplicate entries in HS_Portal_Login. I did the following query on the old db (using part of the omitted email address):
SELECT * FROM
sEmail LIKE ‘%omitted%’ LIMIT 0 , 30
There was only one matching entry?