by eggsurplus

Control what your users can access and save time, money, and frustrations. Lock down sensitive data in SugarCRM or SuiteCRM to specific groups or teams. Supports unlimited assigned users, unlimited group assignments to records, custom layouts for each group, login/sudo capabilities and much more.

Cancel at any time!
Free Trial

#1331 - Report Error

Closed General Question created by chandan Verified Purchase 5 years ago

I install security groups and report module already. I think they are conflicted. In log file i see this message

"Thu May 7 13:45:38 2015 [23763][1][FATAL] Error running count query for RT_Report List: Query Failed: ( SELECT count(*) c FROM securitygroups INNER JOIN securitygroups_records ON AND securitygroups_records.securitygroup_id='dfbe9011-6455-0eab-9f50-554ae72e3267' AND securitygroups_records.deleted=0
AND securitygroups_records.module = 'RT_Report'
where securitygroups.deleted=0 ): MySQL error 1054: Unknown column '' in 'on clause'"

Pls help me.

  1. eggsurplus member avatar

    eggsurplus Provider Affiliate

    5 years ago

    Hi there,

    It looks like there is a conflict. You will need to contact the developers of the reporting tool and let them know about this error. They can contact me and I would be happy to assist them with how to make it work with SecuritySuite. They should already have my contact info.

    The query doesn't tell a good story on what you were doing before the error. If you were trying to report on SecurityGroups, does it work if you report on any other module? They may just need to exclude SecurityGroups from the list of modules.


  2. eggsurplus member avatar

    eggsurplus Provider Affiliate

    4 years ago

    Just doing some housekeeping. Feel free to follow up on this if you have any other questions.

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...

Keep up to date on the latest additions

We'll send you an email every month with handpicked add-ons, reviews, tricks and tips. Don't worry, we hate spam as much as you do.