Problems adding meetings

[larcman]

Hi,

When I try to add a new meeting, note, case or whatever this bug appears:

Query Failed:insert into securitygroups_records(id,securitygroup_id,record_ id,module,date_modified,deleted) select distinct '44d64a61-c46b-f7a8-0dde-4e38100be19a',u.securitygroup_id,'2c69cacc-9423-c380-f1d4-4e381001e687','Meetings',CURDATE(),0 from securitygroups_users u left join securitygroups_records d on d.securitygroup_id = u.securitygroup_id and d.record_id = '2c69cacc-9423-c380-f1d4-4e381001e687' and d.module = 'Meetings' and d.deleted = 0 where d.id is null and u.user_id = '98ca461c-8c48-676e-198f-4ab95b0f1a4d' and u.deleted = 0 ::MySQL error 1062: Duplicate entry '44d64a61-c46b-f7a8-0dde-4e38100be19a' for key 1

This only happens with one user who is in 2 security groups with 2 or 3 roles. If i remove this user from one of them, it works! but I need both security groups.

Thanks

[larcman]

Well I've been trying to solve the problem.
When I write that query on PHPmyadmin it displays 2 results (the 2 security groups to which the user belongs).
If I remove the user of one of them, it works without any problem!
What could be the reason of this bug? or I can't put a user in two different groups?

By the way Im using SugarCRM version 5.0.0f. The version could be the problem?
because if I do something similar in 5.2.0f version I don't have any problem.


Help please.
Thanks