Details
-
Type:
Bug
-
Status: Won't Do
-
Priority:
Major
-
Resolution: Won't Do
-
Affects Version/s: 4.5.5, 4.6.9
-
Fix Version/s: Unscheduled
-
Component/s: None
-
Labels:
-
Versioning Impact:Patch (backwards-compatible bug fixes)
-
Documentation Required?:None
-
Funding Source:Needs Funding
Description
Tested on CiviCRM 4.5.5 and current CiviCRM demo site (4.6.10) if you:
add a new location type, then populate a contact with an email address of that location type, then use Search builder to search for email address with location type gives 'DB Error: syntax error'
SQL is reported to 'include a column that doesn't exists and it's going against the wrong table':
http://civicrm.stackexchange.com/questions/7110/using-search-builder-to-search-on-a-field-with-custom-location-gives-db-error