[rt-users] Users Drop-Down

[Drew Barnes]

Sounds like you didn't run the upgrade scrips on the db.  Check the README.

Alex Romanauskas wrote:
> 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:aroman at ziplink.net]
>> 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: rt-users-bounces at lists.bestpractical.com
>>> [mailto:rt-users-bounces at lists.bestpractical.com]On 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
>>>
>>>       
>>     
>
>
>   

-- 
Drew Barnes
Applications Analyst
Raymond Walters College
University of Cincinnati