"Shared Household-ID not found" when trying to "Use Household Address"

[straffin]

All,

I'm trying to set an Individual to "Use Household Address" for contacts and I get a "Shared Household-ID not found" error. Any idea why? The test contact has two relationships with the target household ("Household Member of" and a custom relationship).

- John

[Deepak Srivastava]

Such kind of error is generally thrown when dojo selector doesn't happen to submit the contact-ID of selected household contact.

I tried replicating the problem on my local machine, but seems to be working fine.

Could you replicate your problem on demo site.

[straffin]

Could you replicate your problem on demo site.

Yep... just did. I imported the following record:

FamilyID,Name,Last Name,Pretty Last Name,First Names,First First Name,Rest of First Name,Street,City,Zip,Email,Phone,Curriculum,Church,paidthrough,Renewed On,new,suppl
17,"DOE, Jane & John",DOE,Doe,Jane & John,Jane,John,123 Main Street,Anytown,12345,jane.doe@example.org,123-4567,Classical,Duke Catholic,2006,9/1/2005,TRUE,FALSE

(I've attached the file as well)

Imported file twice: first time as Household using "Name"="Household Name", "FamilyID"="External ID" and the address fields; second time as Individual using "First First Name", "Pretty Last Name" and "Email" along with "Name"="Household Member of" + "Household Name". The resulting records are currently in the demo db as "Jane Doe" and "DOE, Jane & John". When trying to set "Use Household Address" on Jane and selecting the DOE household, I get the same error on the demo site that I am getting on my own.

Help?

[Deepak Srivastava]

Changing the household name from "DOE, Jane & John" To "DOE Jane & John" works 

Dojo selector shows the list in the format: "display_name, street_address (upto 25 char), city" i.e three parts.
Having a comma (,) in display_name is changing the format of the list causing misinterpretation of contact-ID and hence the error.

Since this is a valid bug, Can you file an issue with the problem and expected behavior along with solution that solved your problem ?

Thx

[campsoupster]

Did this receive follow-up?  I'm getting this same error message, though interestingly the household address is saved correctly if I refresh the contact's edit screen.  I'm happy to submit the bug if need be.

-s

[campsoupster]

Actually, it looks like this is throwing a foreign key error:

Database Error Code: Cannot add or update a child row: a foreign key constraint fails (`db_example_host_civicrm/civicrm_relationship`, CONSTRAINT `FK_civicrm_relationship_relationship_type_id` FOREIGN KEY (`relationship_type_id`) REFERENCES `civicrm_relationship_type` (`id`)), 1452


But again, the save works.

-s

[Deepak Srivastava]

Not sure if problem reported earlier was related to any foreign-key.

w.r.t, an issue has been filed and fixed : http://issues.civicrm.org/jira/browse/CRM-2317

Have a look at it And if you suspect the issue doesn't address your problem, try replicating the problem on demo.

And file an issue if you are successful replicating the problem.