Details
-
Type:
Bug
-
Status: Done/Fixed
-
Priority:
Minor
-
Resolution: Fixed/Completed
-
Affects Version/s: 2.0
-
Fix Version/s: 2.0
-
Component/s: Core CiviCRM
-
Labels:None
Description
If the County field is included in a profile, and set to be searchable - it shows up in the Search form - but a fatal error is thrown when you try to do a search.
http://sandbox.civicrm.org/civicrm/profile?reset=1&gid=1
Database Error Code: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') LEFT JOIN civicrm_location_type `Home-location_type` ON ( ( `Home-address`.' at line 6, 1064
The same DB error occurs when trying to view or edit a contact via that profile (as long as County field is enabled). If you disable County field - no errors occur
http://sandbox.civicrm.org/civicrm/profile/view?reset=1&id=103&gid=1
The problematic part of the query is the following clause:
LEFT JOIN civicrm_location_type `1-location_type` ON ( )