Hi.
We have a problem with search function in CB User manager in our Joomla installation. Here are the details:
1. Joomla ver.: 3.4.1
2. CB 2.0.8
3. PHP 5.6.8 and 5.5.5-10.0.17-MariaDB
4. In backend and logged in as superuser I go to "CB menu" -> "User Management"
I choose "Search tools" -> "Select group" and select any of my groups (the "Group" heading is black color and not sortable) and the following error message would appear:
Unknown column 'e.' in 'on clause' SQL=SELECT COUNT( DISTINCT a.`id` ) FROM `zrd5a_comprofiler` AS a INNER JOIN `zrd5a_users` AS b ON b.`id` = a.`id` LEFT JOIN `zrd5a_session` AS c ON c.`client_id` in (0,1) AND c.`userid` = a.`id` LEFT JOIN `zrd5a_user_usergroup_map` AS d ON d.`user_id` = a.`id` INNER JOIN `zrd5a_user_usergroup_map` AS e ON e.`` = a.`` LEFT JOIN`zrd5a_user_usergroup_map` AS f ON f.`user_id`=e.`user_id` WHERE ( f.`group_id` = 1 )
I now have to sign out of backend and in again to use the CB user menu again for searching.
All other search functions seems to be working, except "Select Online" which shows the full list of members online or not.
Also searching for groups works with no faults under native Joomla users menu.
nant