I am getting this error when using search tools in the community builder list of users
unknown column 'a.block' in 'where clause' SQL=SELECT COUNT( DISTINCT a.`id` ) FROM `tqcr_comprofiler` AS a INNER JOIN `tqcr_users` AS b ON b.`id` = a.`id` LEFT JOIN `tqcr_session` AS c ON c.`client_id` in (0,1) AND c.`userid` = a.`id` LEFT JOIN `tqcr_user_usergroup_map` AS d ON d.`user_id` = a.`id` WHERE ( a.`block` = 0 )
I was searching for disabled users - the other search drop down fields appear to work ok