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
Fixed it by doing an uninstall and reinstall.
7 years ago
Glad you got it working! Another way to solve this, in case anyone else runs into this, is to go to Admin->Repair->Quick Repair and Rebuild and after it finishes loading execute the generated SQL at the bottom of the page. Sometimes the installer just misses adding these new fields sometimes.
I'll close this out, but feel free to comment here or start a new case if needed.