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.
#1331 - Report Error
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 rt_report.id=securitygroups_records.record_id 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 'rt_report.id' in 'on clause'"
Pls help me.
-
"Quite powerful, flexible and easy to use plugin. Works perfectly in SuiteCRM as well as in SugarCRM." - damien8105
Read More Reviews
- Most Recent Love from Users
kacsoristvan- damien8105
- anri
- Administrador
- Stefano1
- einkauf2
8 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.
Cheers, -Jason
8 years ago
Just doing some housekeeping. Feel free to follow up on this if you have any other questions.