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.

Free Trial

By clicking you consent to share your profile with the developer

#2997 - Security Suite failing to run initial sql query.

Closed Installation created by stevewgunn Verified Purchase 5 years ago

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

  1. stevewgunn member avatar

    stevewgunn Verified Purchase

    5 years ago

    Fixed it by doing an uninstall and reinstall.

    • eggsurplus member avatar

      eggsurplus Provider Affiliate

      5 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.

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...
Rating
Rating
  • "Quite powerful, flexible and easy to use plugin. Works perfectly in SuiteCRM as well as in SugarCRM." - damien8105

    Read More Reviews