Author Topic: 4.6.10 > 4.7 beta1 upgrade error (dupicate entry) (Read 435 times)

magnolia61 · December 04, 2015, 01:06:47 am

Hello guys,
Just tried to upgrade from 4.6.10 to 4.7 beta 1 and got the following fatal error during db upgrade.

ALTER TABLE civicrm_setting ADD UNIQUE INDEX index_domain_contact_name (domain_id, contact_id, name) [nativecode=1062 ** Duplicate entry '1-1-navigation' for key 'index_domain_contact_name']
DebugInfo ALTER TABLE civicrm_setting ADD UNIQUE INDEX index_domain_contact_name (domain_id, contact_id, name) [nativecode=1062 ** Duplicate entry '1-1-navigation' for key 'index_domain_contact_name']

Cheers, Richard

totten · December 09, 2015, 01:05:25 pm

Any chance you could use a SQL tool (e.g. "phpmyadmin" or "mysql" or "drush civicrm-sql-cli") to run this query:

Code: [Select]

SELECT name, domain_id, contact_id, count(*) AS dupes FROM civicrm_setting cs GROUP BY name, domain_id, contact_id HAVING dupes > 1;

FWIW, the "navigation" records should be expendable. (They're auto(re)generated.) For a quick workaround, you can try running:

Code: [Select]

DELETE FROM civicrm_setting  WHERE contact_id IS NOT NULL AND name = 'navigation';

EDIT: PR: https://github.com/civicrm/civicrm-core/pull/7418

CiviCRM Community Forums (archive)

News:

Author Topic: 4.6.10 > 4.7 beta1 upgrade error (dupicate entry) (Read 435 times)

magnolia61

4.6.10 > 4.7 beta1 upgrade error (dupicate entry)

totten

Re: 4.6.10 > 4.7 beta1 upgrade error (dupicate entry)