This bug is in 7.0.9
On line 719 of BxBaseProfileView.php, there is a single quote (as in, on the key shared with the double quote) where there should be a tilted quote (on the key shared with the tilde ~), at the end of $sItemName
WHAT IT IS:
case 'bool':
$aWhere[] = "`Profiles`.`$sItemName'";
break;
WHAT IT SHOULD BE:
case 'bool':
$aWhere[] = "`Profiles`.`$sItemName`";
break;
This bug causes a SQL error when a checkbox type of profile field is in a search form and is checked.
---------------
Note: There is a separate error causing checkboxes to have an empty value attribute, value="", but I haven't figured that one out yet. I got around that issue to figure out the above bug by manually altering the query string to give the checkbox type proflle field a value.
- Brian
