On Mon, Mar 17, 2008 at 04:08:52PM +0000, Richard Ellis wrote:
> ok, that doesn't look good
>
>
> mysql> select * from ACL, CachedGroupMembers, Groups where ACL.RightName
> = 'OwnTicket' and ACL.PrincipalId = Groups.id and Groups.id =
> CachedGroupMembers.GroupId and (CachedGroupMembers.MemberId = '3' or
> CachedGroupMembers.MemberId = '5'); Empty set (0.04 sec)
>
Looks good for you, not for me ;) That means that my trivial fix isn't
going to catch it.
Next:
SELECT * from ACL, CachedGroupMembers, Groups where ACL.RightName = 'OwnTicket'
and ACL.PrincipalId = Groups.id and Groups.id = CachedGroupMembers.GroupId;
This will generate a _lot_ of data. Probably best not to CC the list on
the full response.
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com