After enabling debug for RT this is the error I receive when it attempts to retrieve the users lists for the drop-down.
Jul 31 08:51:41 tickets RT: RT::Handle=HASH(0xa14171c) couldn't execute the query 'SELECT DISTINCT main.* FROM Users main , Principals Principals_1, ACL ACL_2, Groups Groups_3, CachedGroupMembers CachedGroupMembers_4 WHERE ((ACL_2.RightName = 'OwnTicket')) AND ((CachedGroupMembers_4.MemberId = Principals_1.id)) AND ((Groups_3.id = CachedGroupMembers_4.GroupId)) AND ((Principals_1.Disabled = '0')or(Principals_1.Disabled = '0')) AND ((Principals_1.id != '1')) AND ((main.id = Principals_1.id)) AND ( ( ACL_2.PrincipalId = Groups_3.id AND ACL_2.PrincipalType = 'Group' AND ( Groups_3.Domain = 'SystemInternal' OR Groups_3.Domain = 'UserDefined' OR Groups_3.Domain = 'ACLEquivalence')) Anyone have any info on where to look for the problem? Thanks -- Alex Lamers, Dan wrote: > Sorry Alex, that's the extent of my knowledge. I'm new to RT and it took me > a while to find out how to get that drop box populated. For me, the 'Own > Ticket' was all that was required and I assigned that to the 'priviledged > users' group. > > Regards, > Dan > > -----Original Message----- > From: Alex Romanauskas [mailto:[EMAIL PROTECTED] > Sent: July 28, 2006 9:34 AM > To: Lamers, Dan > Cc: rt-users > Subject: Re: [rt-users] Users Drop-Down > > > Dan, > > Own Ticket is enabled for all users and Everyone. In case it could > be > some other permission level here is what is assigned to the standard users: > > CommentOnTicket > CreateTicket > ModifySelf > ModifyTicket > OwnTicket > ReplyToTicket > SeeQueue > ShowTicket > ShowTicketComments > Watch > WatchAsAdminCc > > I have also noticed that you can't even use query builder to search by > owner as that drop-down also just shows nobody. > > Thanks > -- > Alex > > Lamers, Dan wrote: >> Alex, >> >> You need to grant the 'own ticket' permission in order for the users to >> appear in the drop-down. >> >> Regards, >> Dan >> >> >> -----Original Message----- >> From: [EMAIL PROTECTED] >> [mailto:[EMAIL PROTECTED] Behalf Of Alex >> Romanauskas >> Sent: July 27, 2006 9:14 AM >> To: rt-users >> Subject: [rt-users] Users Drop-Down >> >> >> I have just upgraded from 3.0.11 to 3.4.5 and for the most part >> everything has gone very well. The only problem I am having is >> assigning ticket ownership. The Owner drop down currently shows >> "Nobody" as the only available choice of owner. Is this a permissions >> problem or something else? All users in question have ModifyTicket as >> does Everyone. >> >> Thanks >> -- >> Alex >> > > -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. _______________________________________________ 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 We're hiring! Come hack Perl for Best Practical: http://bestpractical.com/about/jobs.html
