HelpSpot Help Desk Software | HelpSpot Blog | HelpSpot Support

Mysql Integrity constraint violation during upgrade from 3.2.12 to 4.0.19



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[23000]: Integrity constraint violation: 1062 Duplicate entry ‘’ for key ‘hs_portal_login_semail_unique’ (SQL: insert into HS_Portal_Login (sEmail, sPasswordHash, 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 HS_Portal_Login WHERE sEmail LIKE ‘%omitted%’ LIMIT 0 , 30

There was only one matching entry?