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
