[rt-users] RT 3.6.4, user list too long when resolving multiple tickets

[Daksh Chauhan]

I agree with Emmanuel that workaround does not really provide a "fix" on 
this issue. I have read and followed this issue (of users list too long, or 
QueryBuilder and Bulk update page takes too long to load) for a while. FYI: 
I am running RT 3.8.1 on opensuse11; perl 5.10; mysql 5.0

I did not see same issue as described in "Message 5" below. But, I did 
notice one of my queues had a permissions of "OwnTicket" to group 3. When I 
looked; group 3 is "Everyone", but the queue it was assigned to did not 
exist! Not sure why, perhaps it was deleted by prior admin.

So, I removed that privilege from the "unknown" queue, and now my pages are 
much faster (i.e; I do not have a long list of users in "Own Ticket" drop 
down box).

Thanks everyone for helping on this issue.
Daksh


> ------------------------------
>
> Message: 2
> Date: Mon, 2 Feb 2009 16:07:11 +0100
> From: Emmanuel Lacour <elacour at easter-eggs.com>
> Subject: Re: [rt-users] RT 3.6.4, user list too long when resolving
> multiple tickets
> To: rt-users at lists.bestpractical.com
> Message-ID: <20090202150710.GK31690 at easter-eggs.com>
> Content-Type: text/plain; charset=us-ascii
>
> On Mon, Feb 02, 2009 at 03:57:45PM +0100, Christopher Kunz (Filoo GmbH)
> wrote:
>> kem cho schrieb:
>> > Check this out:
>> >
>> > http://www.gossamer-threads.com/lists/rt/users/81858#81858
>> >
>>
>>
>> Nice workaround, works fine for me. Owner change is very rarely used in
>> our setup, anyway.
>>
>
> Yes, but it hides the fact that you seems to have an ACL issue in your
> setup. What is the result of this sql query on your DB:
>
> select * from ACL where RightName='OwnTicket';
>
>
> ------------------------------
>
> Message: 5
> Date: Mon, 2 Feb 2009 16:38:29 +0100
> From: Emmanuel Lacour <elacour at easter-eggs.com>
> Subject: Re: [rt-users] RT 3.6.4, user list too long when resolving
> multiple tickets
> To: rt-users at lists.bestpractical.com
> Message-ID: <20090202153828.GM31690 at easter-eggs.com>
> Content-Type: text/plain; charset=us-ascii
>
> On Mon, Feb 02, 2009 at 04:13:52PM +0100, Christopher Kunz (Filoo GmbH)
> wrote:
>> Emmanuel Lacour schrieb:
>> >
>> > select * from ACL where RightName='OwnTicket';
>> >
>>
>>
>> mysql> select * from ACL where RightName='OwnTicket';
>> +------+---------------+-------------+-----------+------------+----------+-------------+---------------+
>> | id   | PrincipalType | PrincipalId | RightName | ObjectType | ObjectId
>> | DelegatedBy | DelegatedFrom |
>> +------+---------------+-------------+-----------+------------+----------+-------------+---------------+
> [...]
>> | 1179 | Group         |           5 | OwnTicket | RT::Queue  |       33
>> |           0 |             0 |
>
>
> On queue with Id 33, you gave right OwnTicket to Group 5 and Group 5 is
> usually the "Unprivileged" group!
>