Bug or misconfig in CB User Mananger?

5 years 4 months ago #263708 by sastific
Bug or misconfig in CB User Mananger? was created by sastific
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.

Brgds,
sastific

Please Log in to join the conversation.

5 years 4 months ago #263922 by Papa Cheche
Replied by Papa Cheche on topic Bug or misconfig in CB User Mananger?
I've the same pb.

Please Log in to join the conversation.

5 years 4 months ago #263924 by nant

Please Log in to join the conversation.

Moderators: beatnantkrileon
Time to create page: 0.436 seconds

Facebook Twitter LinkedIn