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 <elac...@easter-eggs.com> > Subject: Re: [rt-users] RT 3.6.4, user list too long when resolving > multiple tickets > To: rt-users@lists.bestpractical.com > Message-ID: <20090202150710.gk31...@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 <elac...@easter-eggs.com> > Subject: Re: [rt-users] RT 3.6.4, user list too long when resolving > multiple tickets > To: rt-users@lists.bestpractical.com > Message-ID: <20090202153828.gm31...@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! > _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com