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) »
  • Upgrades and duplicate emails
Pages: [1]

Author Topic: Upgrades and duplicate emails  (Read 1493 times)

Neil Adair

  • I post occasionally
  • **
  • Posts: 78
  • Karma: 4
  • CiviCRM version: 4.5.8
  • CMS version: Drupal 7
  • MySQL version: MariaDB 10
  • PHP version: 5.5 FPM
Upgrades and duplicate emails
August 07, 2007, 07:12:31 pm
The errors I'm encountering with upgrading my database from 1.6 to 1.7 or 1.8 are associated with email addresses which are duplicated in the database. The contacts have different names but the existence of a duplicate email seems to cause foreign key constraint failures.
Can anyone confirm this is the case?
Will we need to purge all duplicate emails from the database to successfully upgrade?

Thanks
Neil

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: Upgrades and duplicate emails
August 07, 2007, 07:38:29 pm

yes. we've been adding more constraints to the db in recent versions to catch and trap various bugs. The code had a few bugs which introduced duplicate locations/email under certain conditions. We've also added some unique constraints to the uf_match table

Getting rid of the duplicate emails is probably a good first step

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) »
  • Upgrades and duplicate emails

This forum was archived on 2017-11-26.