Uploaded image for project: 'CiviCRM'
  1. CiviCRM
  2. CRM-292

Import Contacts: A non-recoverable error has occurred when importing contacts with Fill choosen as duplicate handling

    Details

    • Type: Bug
    • Status: Done/Fixed
    • Priority: Minor
    • Resolution: Fixed/Completed
    • Affects Version/s: 1.1
    • Fix Version/s: 1.1
    • Component/s: None
    • Labels:
      None

      Description

      Execution Steps are as follows:
      1. Import the testcustom.csv file attached here with No duplicate Checking as duplicate handler.
      2. Now again import the same file and choose Fill as duplicate handler.
      3. During the final stage after Summary an error message is dislayed,

      Sorry. A non-recoverable error has occurred.

      Database Error Code: Cannot add or update a child row: a foreign key constraint fails, 1216

      Return to CiviCRM menu.

      error

      Array
      (
      [callback] => Array
      (
      [0] => CRM_Core_Error
      [1] => handle
      )

      [code] => -3
      [message] => DB Error: constraint violation
      [mode] => 16
      [debug_info] => INSERT INTO civicrm_address () VALUES () [nativecode=1216 ** Cannot add or update a child row: a foreign key constraint fails]
      [type] => DB_Error......

        Attachments

        1. testcustom.csv
          0.2 kB
          Siddharth Bhawalkar

          Activity

            People

            • Assignee:
              brian Brian McFee
              Reporter:
              siddharth Siddharth Bhawalkar
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: