Bug with security groups

[larcman]

Hi all,

I have a big problem.
Why this bug appears when the user is in 2 security groups? even if both security groups do not have any role?
I'm using SugarCRM 5.0.0f, it could be the version?

Query Failed:insert into securitygroups_records(id,securitygroup_id,record_ id,module,date_modified,deleted) select distinct '5a792fb2-760a-aec3-9987-4e3b17a3a434',u.securitygroup_id,'58e978c8-22c5-0735-7f81-4e3b17f4d905','Tasks',CURDATE(),0 from securitygroups_users u left join securitygroups_records d on d.securitygroup_id = u.securitygroup_id and d.record_id = '58e978c8-22c5-0735-7f81-4e3b17f4d905' and d.module = 'Tasks' and d.deleted = 0 where d.id is null and u.user_id = '9b212381-3bb7-87a3-eeaa-4e382e90d45c' and u.deleted = 0 ::MySQL error 1062: Duplicate entry '5a792fb2-760a-aec3-9987-4e3b17a3a434' for key 1

It's only this message because the record (query) it's done.

Please help!

[eggsurplus]

The 5.0.0f version is 3 years old so there very well could be a bug there. I'd advise downloading the 6.2.0 version from SugarForge (http://www.sugarforge.org/frs/downlo....2_for_620.zip) and comparing modules/SecurityGroups/SecurityGroup.php to see what differences there are that may be related (there will be a number of changes).

[larcman]

Eggsurplus,
yes there are many differences.
But the problem is I don't want to upgrade my Sugar, there's a lot of custom code.
Is there a patch for this version or for this security suite to fix this bug?
or another solution?

I realized that this version of security suite needs the option in the security suite settings:

Use Popup Select
When creating a new user show the SecurityGroups popup to assign the user to a group(s). When a record is created by a user in more than one group popup a group selection screen otherwise inherit that one group. Inheritance rules will only be used for non-user created records (e.g. Workflows, etc)

Thanks