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.

Cancel at any time!
Free Trial

#279 - Error with getPrimaryGroupID function in SecurityGroup.php

Closed Bug? created by michaeln56 5 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

    5 years ago

    I'm using the basic SecuritySuite on SugarCRM 6.5.16

    • eggsurplus member avatar

      eggsurplus Provider Affiliate

      5 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

    5 years ago

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

    • eggsurplus member avatar

      eggsurplus Provider Affiliate

      5 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
  • "SecuritySuite was a very good addition to our SugarCRM implementation helping to integrate different functional teams with strictly specified roles."

    Read More Reviews

Keep up to date on the latest additions

We'll send you an email every month with handpicked add-ons, reviews, tricks and tips. Don't worry, we hate spam as much as you do.