Details
-
Type:
Bug
-
Status: Done/Fixed
-
Priority:
Trivial
-
Resolution: Duplicate
-
Affects Version/s: 4.6.3
-
Fix Version/s: None
-
Component/s: Core CiviCRM
-
Labels:None
-
Documentation Required?:None
-
Funding Source:Needs Funding
Description
Getting an odd error during a relationship search. The upshot is that Contact/BAO/query.php is adding a WHERE statement for "contact_b.is_deleted"... which doesn't exist. The search fails.
I can't replicate this error on the demo site - or any other site. Yet re-installing civicrm 4.6.3 on the existing database didn't cure the problem. Nor does moving the database from the dev environment to the live environment doesn't cure the issue either. I can't see anything in the sites/default/civicrm directory that suggests a link to this.
A search of CiviCRM code shows that contact_b.is_deleted appears just once, in the BAO.
Going into Contact/BAO/query.php and commenting out line 4162 fixes this particular search (and has no effect on the search on those sites that don't have this problem).
Does this line of code need to remain in the release? Should it be removed in the next release?
