Details
-
Type:
Bug
-
Status: Done/Fixed
-
Priority:
Trivial
-
Resolution: Fixed/Completed
-
Affects Version/s: 4.7.8
-
Fix Version/s: 4.7.17
-
Component/s: None
-
Labels:
-
Versioning Impact:Patch (backwards-compatible bug fixes)
-
Documentation Required?:None
-
Sprint:4.7.10 Code improvement
-
Funding Source:Contributed Code
Description
If a CiviCRM Profile includes location details and the location type display name contains a space, the profile view will fatal with
$Fatal Error Details = Array
(
[message] => One of parameters (value: `Summer Palace-city`) is not of the type MysqlColumnNameOrAlias
To reproduce (done on demo just now, profile ID=1) -
- Create an address type with display name containing a space (nb: there is a warning that the location name should not contain a space on this screen?)
- Add a field from this address to a profile used for search or listings
- View the profile listings
- "Sorry but we are not able to provide this at the moment. One of parameters (value: `Foo Bar-city`) is not of the type MysqlColumnNameOrAlias"