CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • v3.4.4 > v3.4.5 upgrade failed
Pages: [1]

Author Topic: v3.4.4 > v3.4.5 upgrade failed  (Read 1075 times)

fen

  • I post frequently
  • ***
  • Posts: 216
  • Karma: 13
    • CivicActions
  • CiviCRM version: 3.3-4.3
  • CMS version: Drupal 6/7
  • MySQL version: 5.1/5.5
  • PHP version: 5.3/5.4
v3.4.4 > v3.4.5 upgrade failed
August 03, 2011, 06:58:05 pm
Have a Drupal 6, CiviCRM v3.4.4 site upgrading to v3.4.5 (it was recently upgraded painlessly from v3.3.6).  Have two minor extensions in custom templates and php, but after the first fail I tried an upgrade with those directories unset (they only affect the output of contribution searches so unless a contribution search is performed, they are unused) and got the same error:
Code: [Select]
Sorry. A non-recoverable error has occurred.
Database Error Code: Duplicate entry 'civicrm_contact-24858-46' for key 'UI_entity_id_entity_table_tag_id', 1062
Additional Details:
...
    [message] => DB Error: already exists
    [mode] => 16
    [debug_info] => ALTER TABLE civicrm_entity_tag
ADD UNIQUE INDEX UI_entity_id_entity_table_tag_id( entity_table, entity_id, tag_id )
[nativecode=1062 ** Duplicate entry 'civicrm_contact-24858-46' for key 'UI_entity_id_entity_table_tag_id']
Same error whether upgrading via 'drush civicrm-upgrade-db' or '/civicrm/upgrade?reset=1'.

I don't believe there are any changes with anything like a UI_entity_id_entity_table.

Any ideas where to start?

Kurund Jalmi

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4169
  • Karma: 128
    • CiviCRM
  • CiviCRM version: 4.x, future
  • CMS version: Drupal 7, Joomla 3.x
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: v3.4.4 > v3.4.5 upgrade failed
August 04, 2011, 12:01:55 am
Looks like you db has duplicate entries for contact and tag combination. So can you check on that and once you clean up db try upgrade.

HTh
Kurund
Found this reply helpful? Support CiviCRM

fen

  • I post frequently
  • ***
  • Posts: 216
  • Karma: 13
    • CivicActions
  • CiviCRM version: 3.3-4.3
  • CMS version: Drupal 6/7
  • MySQL version: 5.1/5.5
  • PHP version: 5.3/5.4
Re: v3.4.4 > v3.4.5 upgrade failed
August 04, 2011, 07:30:33 am
Thanks - there were indeed dupes in the inherited DB.  Apologies for not checking this out first.

Eileen

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4195
  • Karma: 218
    • Fuzion
Re: v3.4.4 > v3.4.5 upgrade failed
August 20, 2011, 01:58:44 am
We hit this too - DB doesn't have a long checkered history so dunno why
Make today the day you step up to support CiviCRM and all the amazing organisations that are using it to improve our world - http://civicrm.org/contribute

fen

  • I post frequently
  • ***
  • Posts: 216
  • Karma: 13
    • CivicActions
  • CiviCRM version: 3.3-4.3
  • CMS version: Drupal 6/7
  • MySQL version: 5.1/5.5
  • PHP version: 5.3/5.4
Re: v3.4.4 > v3.4.5 upgrade failed
August 20, 2011, 07:34:44 am
In our case it was from doing imports of overlapping sets of people - from multiple original databases - and adding tags via the API that, until v3.4.5, allowed adding tags to contacts that already had that tag.

Fortunately it was an easy fix.

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: v3.4.4 > v3.4.5 upgrade failed
August 20, 2011, 08:05:05 am

This is a bug, and we need to clean the DB before we do the upgrade. Fix will be in 3.4.6

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • v3.4.4 > v3.4.5 upgrade failed

This forum was archived on 2017-11-26.