I'm betting it's your "research" queue. On Wed, Sep 13, 2006 at 05:13:54PM -0500, Jackie Hamilton wrote: > > Sorry to rehash this thread, but I'm still having trouble with the Tickets > page having all 150K+ users in the "Owner" pull down, rendering the page > unusable. I downgraded our MySQL to 4.1.21, so I know it's not a MySQL 5.0 > issue. > > I've reviewed the previous thread where another user was having this problem. > I'm not clear on the solution though. In Theo's case it looked like it was > related to a disabled queue having OwnTicket rights. However, none of the > queues on my system are disabled: > > mysql> SELECT * FROM ACL WHERE RightName = 'OwnTicket' order by ObjectId; > +-----+---------------+-------------+-----------+------------+----------+-------------+---------------+ > | id | PrincipalType | PrincipalId | RightName | ObjectType | ObjectId | > DelegatedBy | DelegatedFrom | > +-----+---------------+-------------+-----------+------------+----------+-------------+---------------+ > | 2 | Group | 11 | OwnTicket | RT::System | 1 | > 0 | 0 | > | 19 | Group | 332274 | OwnTicket | RT::Queue | 3 | > 0 | 0 | > | 37 | Group | 332273 | OwnTicket | RT::Queue | 4 | > 0 | 0 | > | 64 | Group | 193983 | OwnTicket | RT::Queue | 5 | > 0 | 0 | > | 63 | Group | 203501 | OwnTicket | RT::Queue | 5 | > 0 | 0 | > | 65 | Group | 294765 | OwnTicket | RT::Queue | 5 | > 0 | 0 | > | 104 | Group | 217313 | OwnTicket | RT::Queue | 6 | > 0 | 0 | > | 103 | Group | 332274 | OwnTicket | RT::Queue | 6 | > 0 | 0 | > | 130 | Group | 332273 | OwnTicket | RT::Queue | 8 | > 0 | 0 | > | 154 | Group | 332275 | OwnTicket | RT::Queue | 9 | > 0 | 0 | > | 155 | Group | 179139 | OwnTicket | RT::Queue | 9 | > 0 | 0 | > | 156 | Group | 203501 | OwnTicket | RT::Queue | 9 | > 0 | 0 | > | 183 | Group | 332276 | OwnTicket | RT::Queue | 10 | > 0 | 0 | > | 203 | Group | 332277 | OwnTicket | RT::Queue | 11 | > 0 | 0 | > | 220 | Group | 3 | OwnTicket | RT::Queue | 12 | > 0 | 0 | > | 221 | Group | 332273 | OwnTicket | RT::Queue | 12 | > 0 | 0 | > | 244 | Group | 332278 | OwnTicket | RT::Queue | 13 | > 0 | 0 | > | 265 | Group | 294765 | OwnTicket | RT::Queue | 15 | > 0 | 0 | > +-----+---------------+-------------+-----------+------------+----------+-------------+---------------+ > 18 rows in set (0.00 sec) > > mysql> select id,Name,Created,LastUpdated,Disabled from Queues where id in > (1,3,4,5,6,7,9,10,11,12,13,15); > +----+------------+---------------------+---------------------+----------+ > | id | Name | Created | LastUpdated | Disabled | > +----+------------+---------------------+---------------------+----------+ > | 3 | backlog | 2003-11-07 00:14:17 | 2003-11-07 00:14:17 | 0 | > | 4 | general | 2002-09-09 13:13:55 | 2002-09-12 06:53:25 | 0 | > | 5 | inventory | 2004-10-12 13:58:14 | 2004-10-12 13:58:14 | 0 | > | 6 | it | 2003-01-10 02:09:41 | 2003-01-10 02:09:41 | 0 | > | 7 | jobs | 2006-06-01 15:15:44 | 2006-06-01 15:15:44 | 0 | > | 9 | ops | 2003-01-10 02:10:16 | 2003-01-10 02:10:16 | 0 | > | 10 | pr | 2003-01-10 02:02:30 | 2003-01-10 02:02:30 | 0 | > | 11 | promotions | 2003-03-06 13:35:56 | 2003-03-06 13:35:56 | 0 | > | 12 | research | 2005-02-18 15:50:25 | 2005-02-21 12:40:33 | 0 | > | 13 | sales | 2003-01-07 12:59:26 | 2003-01-08 16:58:23 | 0 | > | 15 | suggest | 2005-08-12 14:16:21 | 2005-08-12 14:18:11 | 0 | > +----+------------+---------------------+---------------------+----------+ > 11 rows in set (0.00 sec) > > > How do I fix this so the "Owner" list doesn't consist of every user in the > db? What should I be looking for, here? > > Thanks, > > -- Jackie Hamilton > [EMAIL PROTECTED] > _______________________________________________ > 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 >
-- _______________________________________________ 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
