[rt-users] RTFM and Postgres 7.3.

[Patrick Hurley]

Greetings Jesse,

> > Jan 13 09:39:36 rt RT: DBD::Pg::st execute failed: ERROR:  pg_atoi:
> > zero-length string at
> > /usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm line
410.
> > (/opt/rt3/lib/RT.pm:247)
> 
> The postgres error log should contain a record of what statement it
> failed on. That's necessary for debugging this.

Thanks for the response.

I'm logging everything to syslog -- below are the contents resulting
from attempting to create a new article.  If there's any other info that
would be helpful, just let me know.

Thanks,

Patrick


--

Jan 13 15:24:50 rt RT: Checking for a class of
(/opt/rt3/share/html/RTFM/Article/Search.html:161)

Jan 13 15:24:53 rt RT: Trying to check RT::FM::Class rights for an
unspecified RT::FM::Class at /opt/rt3/lib/RT/Principal_Overlay.pm line
354
^IRT::Principal::HasRight('RT::Principal=HASH(0x96e2254)','Right','ShowA
rticle','Object','RT::FM::Article=HASH(0x96b8f60)','EquivObjects','ARRAY
(0x96e0f44)') called at /opt/rt3/lib/RT/User_Overlay.pm line 1450
^IRT::User::HasRight('RT::User=HASH(0x96e1ab0)','Right','ShowArticle','O
bject','RT::FM::Article=HASH(0x96b8f60)','EquivObjects','ARRAY(0x96e0f44
)') call
ed at /opt/rt3/lib/RT/CurrentUser.pm line 305
^IRT::CurrentUser::HasRight('RT::CurrentUser=HASH(0x967adec)','Right','S
howArticle','Object','RT::FM::Article=HASH(0x96b8f60)','EquivObjects','A
RRAY(0x96e0f44)') called at /opt/rt3/lib/RT/FM/Article_Overlay.pm line
1144
^IRT::FM::Article::CurrentUserHasRight('RT::FM::Article=HASH(0x96b8f60)'
,'ShowArticle') called at /opt/rt3/share/html/RTFM/Article/Edit.html
line 273 ^IHTML::Mason::Commands::__ANON__('Class',1,'Class',1) called
at /usr/lib/perl5/site_perl/5.8.0/HTML/Mason/Component.pm

Jan 13 15:24:53 rt RT: Trying to check RT::FM::Class rights for an
unspecified RT::FM::Class (/opt/rt3/lib/RT/Principal_Overlay.pm:355)

Jan 13 15:24:53 rt RT: Trying to check RT::FM::Article rights for an
unspecified RT::FM::Article at /opt/rt3/lib/RT/Principal_Overlay.pm line
354
^IRT::Principal::HasRight('RT::Principal=HASH(0x96e2254)','Right','ShowA
rticle','Object','RT::FM::Article=HASH(0x96b8f60)','EquivObjects','ARRAY
(0x96e0f44)') called at /opt/rt3/lib/RT/User_Overlay.pm line 1450
^IRT::User::HasRight('RT::User=HASH(0x96e1ab0)','Right','ShowArticle','O
bject','RT::FM::Article=HASH(0x96b8f60)','EquivObjects','ARRAY(0x96e0f44
)')
called at /opt/rt3/lib/RT/CurrentUser.pm line 305
^IRT::CurrentUser::HasRight('RT::CurrentUser=HASH(0x967adec)','Right','S
howA
rticle','Object','RT::FM::Article=HASH(0x96b8f60)','EquivObjects','ARRAY
(0x96e0f44)') called at /opt/rt3/lib/RT/FM/Article_Overlay.pm line 1144
^IRT::FM::Article::CurrentUserHasRight('RT::FM::Article=HASH(0x96b8f60)'
,'ShowArticle') called at /opt/rt3/share/html/RTFM/Article/Edit.html
line 273 ^IHTML::Mason::Commands::__ANON__('Class',1,'Class',1) called
at /usr/lib/perl5/site_perl/5.8.0/HTML/Mason/Component

Jan 13 15:24:53 rt RT: Trying to check RT::FM::Article rights for an
unspecified RT::FM::Article (/opt/rt3/lib/RT/Principal_Ov
erlay.pm:355)

Jan 13 21:24:53 rt postgres[8574]: [1] ERROR:  pg_atoi: zero-length
string

Jan 13 15:24:53 rt RT: DBD::Pg::st execute failed: ERROR:  pg_atoi:
zero-length string at
/usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 410.
(/opt/rt3/lib/RT.pm:247)

Jan 13 15:24:53 rt RT: RT::Handle=HASH(0x93c37bc) couldn't execute the
query 'SELECT ACL.id from ACL, Groups, Principals, CachedGroupMembers
WHERE  (ACL.RightName = 'SuperUser' OR  ACL.RightName = 'ShowArticle')
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::FM::System' AND
ACL.ObjectId = '1') OR (ACL.Obje
ctType = 'RT::FM::Class' AND ACL.ObjectId = '') OR (ACL.ObjectType =
'RT::FM::Article' 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')) )  LIMIT 1' at
/usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 417.
(/opt/rt3/lib/RT.pm:247)

Jan 13 21:24:53 rt postgres[8574]: [2] ERROR:  pg_atoi: zero-length
string

Jan 13 15:24:53 rt RT: DBD::Pg::st execute failed: ERROR:  pg_atoi:
zero-length string at
/usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 410.
(/opt/rt3/lib/RT.pm:247)

Jan 13 15:24:53 rt RT: RT::Handle=HASH(0x93c37bc) couldn't execute the
query 'SELECT ACL.id from ACL, Groups, Principals, CachedGroupMembers
WHERE  (ACL.RightName = 'SuperUser' OR  ACL.RightName = 'ShowArticle')
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::FM::System' AND
ACL.ObjectId = '1') OR (ACL.Obje
ctType = 'RT::FM::Class' AND ACL.ObjectId = '') OR (ACL.ObjectType =
'RT::FM::Article' AND ACL.ObjectId = '')) AND  ( ((Groups.Domain =
'RT::FM::System-Role' AND Groups.Instance = 1)  OR (Groups.Domain =
'RT::FM::Class-Role' AND Groups.Instance = 0)  OR (Groups.Domain =
'RT::FM::Article-Role' AND Groups.Instance = 0)  )  AND Groups.Type =
ACL.PrincipalType AND Groups.Id = Principals.id AND
Principals.PrincipalType = 'Group')  LIMIT 1' at
/usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 417.
(/opt/rt3/lib/RT.pm:

Jan 13 15:24:53 rt RT: WebRT: No permission to view Article ()
(/opt/rt3/share/html/RTFM/Elements/Error:48)

--