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.
#2997 - Security Suite failing to run initial sql query.
I am getting the following error when trying to run the newer version of 6.5.25 (2.9.6) after upgrading my version of Sugar.
Fri Mar 31 08:23:37 2017 [17722][40PAULH][FATAL] Error finding the current users primary group: Query Failed: select securitygroups.id from securitygroups_users
inner join securitygroups on securitygroups_users.securitygroup_id = securitygroups.id
and securitygroups.deleted = 0
where securitygroups_users.user_id='40PAULH' and securitygroups_users.deleted = 0
order by securitygroups_users.primary_group desc limit 0,1 : MySQL error 1054: Unknown column 'securitygroups_users.primary_group' in 'order clause'
Resolution is urgent if any one can help I would really appreciate it.
Steve Watson
-
"The perfect solution for managing security. Very stable and easy to implement. Must-have add-on for every CE implementation!"
Read More Reviews
- Most Recent Love from Users
kacsoristvan- damien8105
- anri
- Administrador
- Stefano1
- einkauf2
7 years ago
7 years ago