Template bugs in RT3.0 with pgsql 7.3.2

RT Users
1

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)

smime.p7s (2.79 KB)

2

I’m still having this problem. I’ve tried everything I could think of, and
played with permissions. Does anyone have advice?From: “Jonathan Mischo” jon@clickalyzer.com
To: rt-users@lists.fsck.com
Sent: Sunday, April 06, 2003 12:22 PM
Subject: [rt-users] Template bugs in RT3.0 with pgsql 7.3.2

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)

smime.p7s (2.79 KB)