I get a DB Error when exporting contact search results using the "Merge Household Members into their Households" option (image below). Only this merge option causes the error. The others do not.

I am using CiviCRM 4.7.1. I didn't get this error with any version of 4.6 I used.

I was able to reproduce on both the WordPress and Drupal sandboxes.

WordPress Sandbox Error Message

  • I upgraded our test site to 4.7.2. It still fails. It fails if you try to export 100s or just one contact. It fails when you export a organization contact for which households merging isn't an issue. It's easy to reproduce just run a contact search, select one or more contact, select export and select the merge households option. – George Lozier Feb 23 '16 at 20:02
  • Could this be related to this bug CRM-17073? – George Lozier Feb 27 '16 at 15:31
  • This is partial fixed in 4.7.3 and 4.7.4 (available WordPress demo site). It works with the "Export Primary fields" option but it still fails with the "Select fields for export" option. – George Lozier Mar 7 '16 at 16:16

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.