CiviCRM Community Forums (archive)

Dear All,

I get a constraint violation error (both on local 4.4.3 installation and the official 4.4.4 drupal demo) when I try to do the following:

My csv-file contains the columns "Civi ID", First Name, "Last Name" and some Adress Fields such as "Street".

In the import contact screen I select the csv-file, "First row contains column headers", "contact type: individual", "For Duplictae Contact: update" and any dedupe rule (e.g. Name and Email).

I match the columns (Civi ID, First Name and Last name to the corresponding fields in CiviCRM)

When I try to import a contact with a CiviCRM ID that does not exist (because it was deleted between exportig the contact's date and trying to re-import it) I get the following error:

DB Error: constraint violation

In addition, I get the following error when I continue to the home page:

Notice: Undefined index: 54559 in CRM_Contact_BAO_Contact::formatProfileContactParams() (line 1840 of /home/webeditor/jenkins-node/workspace/buildkit-demos.civicrm.org/build/d7-demo/sites/all/modules/civicrm/CRM/Contact/BAO/Contact.php).

Of course, matching to a non-existing ID is not possible. However, the import should not crash - I think that before CiviCRM imported all possible contacts and gave back a csv-file with the import-errors. The current behaviour is particularly difficult when using a big import file and you don't know, which contact ist causing the problems.

Has anybody else experienced similar problems? Should I post an issue on JIRA?

Best Regards
Fabian