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:[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
--
Drew Barnes
Applications Analyst
Raymond Walters College
University of Cincinnati
_______________________________________________
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
