[rt-users] Template bugs in RT3.0 with pgsql 7.3.2

[Jonathan Mischo]

I'm having the following two problems when trying to modify templates in 3.0
using pgsql 7.3.2:

When I attempt to modify any template, I get the following:

RT Error
No Template

When I try to delete a template, I get:

Permission Denied

I've tried this with SuperUser Permissions, with ShowTemplate, and with
Modify Template, and I still get these two errors...with any user with any
perms, including root with stock perms.

In /var/log/messages I end up with the following when I'm trying to delete:

Apr  6 12:14:48 support RT: DBD::Pg::st execute failed: ERROR:  pg_atoi:
zero-length string at
/usr/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder/Handle.pm line 376.
(/usr/local/rt3/lib/RT.pm:222)
Apr  6 12:14:48 support RT: RT::Handle=HASH(0x847a704) couldn't execute the
query 'SELECT ACL.id from ACL, Groups, Principals, CachedGroupMembers WHERE
(ACL.RightName = 'SuperUser' OR  ACL.RightName = 'ModifyTemplate') AND
Principals.Disabled = 0 AND CachedGroupMembers.Disabled = 0  AND
Principals.id = Groups.id AND Principals.id = CachedGroupMembers.GroupId AND
CachedGroupMembers.MemberId = '12' AND ( ACL.ObjectType = 'RT::System' OR
(ACL.ObjectType = 'RT::Queue' AND ACL.ObjectId = '')) AND ( (
ACL.PrincipalId = Principals.id AND ACL.PrincipalType = 'Group' AND
(Groups.Domain = 'SystemInternal' OR Groups.Domain = 'UserDefined' OR
Groups.Domain = 'ACLEquivalence' OR Groups.Domain = 'Personal')) OR (
((Groups
.Domain = 'RT::Queue-Role' AND Groups.Instance = '')  )  AND Groups.Type =
ACL.PrincipalType AND Groups.Id = Principals.id AND Principals.PrincipalType
= 'Group')  )  LIMIT 1' at
/usr/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder/Handle.pm line 383.
(/usr/local/rt3/lib/RT.pm:222)

And I get the following when I try to submit a modification:

Apr  6 12:14:55 support RT: WebRT: No Template ()
(/usr/local/rt3/share/html/Elements/Error:54)
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/x-pkcs7-signature
Size: 2861 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20030406/28461b22/attachment.bin>