1. Forums
  3. Support and Presales
  5. CB Paid Subscriptions Support
  7. Cron job error - You are not authorized to view this page.

Cron job error - You are not authorized to view this page.

8 years 11 months ago #263994 by ricco1
Replied by ricco1 on topic Cron job error - You are not authorized to view this page.
Here is the whole error:

Unknown column 'e.' in 'on clause' SQL=SELECT COUNT( DISTINCT a.`id` ) FROM `xxx_comprofiler` AS a INNER JOIN `xxx_users` AS b ON b.`id` = a.`id` LEFT JOIN `xxx_session` AS c ON c.`client_id` in (0,1) AND c.`userid` = a.`id` LEFT JOIN `xxx_user_usergroup_map` AS d ON d.`user_id` = a.`id` INNER JOIN `xxx_user_usergroup_map` AS e ON e.`` = a.`` LEFT JOIN`xxx_user_usergroup_map` AS f ON f.`user_id`=e.`user_id` WHERE ( f.`group_id` = 8 )

Please Log in to join the conversation.

8 years 11 months ago #264006 by nant
Replied by nant on topic Cron job error - You are not authorized to view this page.

ricco1 wrote: Here is the whole error:

Unknown column 'e.' in 'on clause' SQL=SELECT COUNT( DISTINCT a.`id` ) FROM `xxx_comprofiler` AS a INNER JOIN `xxx_users` AS b ON b.`id` = a.`id` LEFT JOIN `xxx_session` AS c ON c.`client_id` in (0,1) AND c.`userid` = a.`id` LEFT JOIN `xxx_user_usergroup_map` AS d ON d.`user_id` = a.`id` INNER JOIN `xxx_user_usergroup_map` AS e ON e.`` = a.`` LEFT JOIN`xxx_user_usergroup_map` AS f ON f.`user_id`=e.`user_id` WHERE ( f.`group_id` = 8 )


Yes, that is a know issue that will be fixed in CB 2.0.9.

For now just empty your browser cache and avoid filtering by group on CB User Management page.
--
Nick (nant)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Tutorials + Search the forums
For more add-ons and support: Upgrade your membership
Links: Community Builder - Languages - Adv/Pro/Dev membership - CBSubs Paid Subscriptions - GPL Templates - Hosting

Visit my CB Profile - Send me a Private Message (PM)
The following user(s) said Thank You: LochMan, ricco1

Please Log in to join the conversation.

8 years 11 months ago #264020 by ricco1
Replied by ricco1 on topic Cron job error - You are not authorized to view this page.
Do you still need access? Can I delete you? :)

Please Log in to join the conversation.

8 years 11 months ago #264031 by nant
Replied by nant on topic Cron job error - You are not authorized to view this page.

ricco1 wrote: Do you still need access? Can I delete you? :)


yes you can delete
--
Nick (nant)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Tutorials + Search the forums
For more add-ons and support: Upgrade your membership
Links: Community Builder - Languages - Adv/Pro/Dev membership - CBSubs Paid Subscriptions - GPL Templates - Hosting

Visit my CB Profile - Send me a Private Message (PM)
The following user(s) said Thank You: ricco1

Please Log in to join the conversation.

Moderators: beat, nant, krileon
  1. Forums
  3. Support and Presales
  5. CB Paid Subscriptions Support
  7. Cron job error - You are not authorized to view this page.
Time to create page: 0.184 seconds

Facebook Twitter LinkedIn

    You are here:  
  1. Home
  2. Forums
  3. Support and Presales
  4. CB Paid Subscriptions Support
  5. Cron job error - You are not authorized to view this page.

Search

Login / Logout

User Menu