Details
-
Type:
Bug
-
Status: Done/Fixed
-
Priority:
Minor
-
Resolution: Cannot Reproduce
-
Affects Version/s: 4.5.4
-
Fix Version/s: 4.6.1
-
Component/s: Core CiviCRM
-
Labels:None
-
Documentation Required?:None
Description
When I do a search for contacts, choose the option to create mailing labels and then click the option to "Merge labels for contacts belonging to the same household", CiviCRM returns a database syntax error.
Checking the error log reports the following sql:
SELECT contact_household.id as household_id, contact_id_a as refContact FROM civicrm_contact contact_household
INNER JOIN civicrm_relationship crel ON crel.contact_id_b = contact_household.id AND crel.relationship_type_id = WHERE contact_household.is_deleted = 0 AND crel.contact_id_a IN ( ...
It's failing to find a value for relationship_type_id
AND crel.relationship_type_id =