Skip to Content Skip to Menu

[SOLVED] Error message in CB User Management

9 years 6 months ago - 9 years 6 months ago #263518 by jankeesschakel
[SOLVED] Error message in CB User Management was created by jankeesschakel
When I open the CB menu User Management I don't get theuser listing but I get the following error message:

Unknown column 'e.' in 'on clause' SQL=SELECT COUNT( DISTINCT a.`id` ) FROM `a0t17_comprofiler` AS a INNER JOIN `a0t17_users` AS b ON b.`id` = a.`id` LEFT JOIN `a0t17_session` AS c ON c.`client_id` in (0,1) AND c.`userid` = a.`id` LEFT JOIN `a0t17_user_usergroup_map` AS d ON d.`user_id` = a.`id` INNER JOIN `a0t17_user_usergroup_map` AS e ON e.`` = a.`` LEFT JOIN`a0t17_user_usergroup_map` AS f ON f.`user_id`=e.`user_id` WHERE ( f.`group_id` = 2 )

What went wrong?
Attachments:
Last edit: 9 years 6 months ago by krileon.

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

  • nant
  • nant
  • OFFLINE
  • Posts: 12339
  • Thanks: 1467
  • Karma: 877
9 years 6 months ago #263528 by nant
Replied by nant on topic Error message in CB User Management
I believe this has been identified as an issue with CB 2.0.8.

Workaround for now is to not search by user group in CB User Management page.

You might need to empty your browser cache.

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

  • krileon
  • krileon
  • ONLINE
  • Posts: 48478
  • Thanks: 8282
  • Karma: 1443
9 years 6 months ago - 9 years 6 months ago #263560 by krileon
Replied by krileon on topic Error message in CB User Management
It's a bug with the filter XML. Logout or purge browser cookies to force a logout. That should fix the issue as the filters are stored in your Joomla session so they persist with page load. Issue should be fixed in next nightly once we've further reviewed the regression. Unfortunately this means some filters are broken.


Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.
Last edit: 9 years 6 months ago by krileon.
The following user(s) said Thank You: jankeesschakel

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

9 years 6 months ago #263582 by jankeesschakel
Replied by jankeesschakel on topic Error message in CB User Management
Thanks, that worked!

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

Moderators: beatnantkrileon
Powered by Kunena Forum