HelpSpot Help Desk Software | HelpSpot Blog | HelpSpot Support

Mysql Integrity constraint violation during upgrade from 3.2.12 to 4.0.19


#1

Hello

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 ‘omitted@omitted.com’ 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?