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

[Jonathan Mischo]

I'm still having this problem.  I've tried everything I could think of, and
played with permissions.  Does anyone have advice?

----- Original Message -----
From: "Jonathan Mischo" <jon at clickalyzer.com>
To: <rt-users at 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)
>
-------------- 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/20030408/9fa5eeaa/attachment.bin>