#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 [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.
6 years ago
Fixed it by doing an uninstall and reinstall.
6 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.