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

#279 - Error with getPrimaryGroupID function in SecurityGroup.php

Closed Bug? created by michaeln56 10 years ago

The query in the getPrimaryGroupID function throws an error. I tracked it down to line 668 with the "order by securitygroups_users.primary_group desc" portion of the query. When I remove that part, it runs and returns the correct Group ID

  1. michaeln56 member avatar

    michaeln56

    10 years ago

    I'm using the basic SecuritySuite on SugarCRM 6.5.16

    • eggsurplus member avatar

      eggsurplus Provider Affiliate

      10 years ago

      Hello Michael,

      Run a Quick Repair & Rebuild from Admin->Repair and then Execute the generated SQL. This will add that missing primary_group column.

      -Jason

  2. michaeln56 member avatar

    michaeln56

    10 years ago

    Thanks, i thought i did the repair but i must not have

    • eggsurplus member avatar

      eggsurplus Provider Affiliate

      10 years ago

      No problem. In retrospect, I should have handled adding that new field during install. I dropped the ball and forgot about the field in that release.

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...
Rating
Rating
  • "No brainer. I have purchased it for two production installations and not regretted it."

    Read More Reviews