Skip to Content Skip to Menu

User filter sql error

9 years 5 months ago #263941 by PierreCorell
User filter sql error was created by PierreCorell
Hello Joomlapolis,

on CB 2.0.8 + Joomla 3.4.1 I get a sql error on filter selection at a specific usergroup, anyway which usergroup I select.
Code:
Unknown column 'e.' in 'on clause' SQL=SELECT COUNT( DISTINCT a.`id` ) FROM `#__comprofiler` AS a INNER JOIN `#__users` AS b ON b.`id` = a.`id` LEFT JOIN `#__session` AS c ON c.`client_id` in (0,1) AND c.`userid` = a.`id` LEFT JOIN #__user_usergroup_map` AS d ON d.`user_id` = a.`id` INNER JOIN `#__user_usergroup_map` AS e ON e.`` = a.`` LEFT JOIN`#__user_usergroup_map` AS f ON f.`user_id`=e.`user_id` WHERE ( f.`group_id` = 2 )

Do you need some more informations, installed CB-plugins etc.?

Thanks in advance,
Pierre.

Please Log in or Create an account to join the conversation.

  • nant
  • nant
  • OFFLINE
  • Posts: 12339
  • Thanks: 1467
  • Karma: 877
9 years 5 months ago #263946 by nant
Replied by nant on topic User filter sql error

PierreCorell wrote: Hello Joomlapolis,

on CB 2.0.8 + Joomla 3.4.1 I get a sql error on filter selection at a specific usergroup, anyway which usergroup I select.

Code:
Unknown column 'e.' in 'on clause' SQL=SELECT COUNT( DISTINCT a.`id` ) FROM `#__comprofiler` AS a INNER JOIN `#__users` AS b ON b.`id` = a.`id` LEFT JOIN `#__session` AS c ON c.`client_id` in (0,1) AND c.`userid` = a.`id` LEFT JOIN #__user_usergroup_map` AS d ON d.`user_id` = a.`id` INNER JOIN `#__user_usergroup_map` AS e ON e.`` = a.`` LEFT JOIN`#__user_usergroup_map` AS f ON f.`user_id`=e.`user_id` WHERE ( f.`group_id` = 2 )

Do you need some more informations, installed CB-plugins etc.?

Thanks in advance,
Pierre.


Known identified issue:

www.joomlapolis.com/forum/147-potential-bug/229612-bug-or-misconfig-in-cb-user-mananger

Please Log in or Create an account to join the conversation.

Moderators: beatnantkrileon
Powered by Kunena Forum