[rt-devel] rt 1.3.78 and postgres

[Jesse]

Hiya. I just rolled a test release specifically to address your issue.
If you could download rt-1-3-79-test1 and tell me if it works any better.

        -jesse

On Tue, May 22, 2001 at 08:31:22PM +0200, Martin J. Laubach wrote:
>   I have been following the rt progress for a couple of weeks now,
> and previous versions didn't do so well with my pet database (postgres),
> however, 1.3.78 has really come close to working out of the box.
> 
>   I got the web interface to work, can futz around with various settings
> and open tickets.
> 
>   However, the mail interface does not work at all:
> 
> | cactus# ./rt-mailgate -v -q general -a correspond < ~mjl/dead.letter
> | Create user failed in mailgateway: Name in use
> | Name in useNo recipient addresses found in header
> | Couldn't load from the users database.
> | Can't call method "fetchrow" on an undefined value at /usr/pkg/lib/perl5/
> |	site_perl/5.6.0/DBIx/SearchBuilder/Handle.pm line 352.
> 
>   And the log file shows
> 
> | cactus# cat /tmp/rt.log
> | Create user failed in mailgateway: Name in use
> | Name in useUse of uninitialized value in concatenation (.) at
> |	/usr/local/rt/lib/RT/CurrentUser.pm line 79.
> | Couldn't load from the users database.
> | Use of uninitialized value in concatenation (.) at
> |	/usr/local/rt/lib/RT/User.pm line 841.
> | Use of uninitialized value in concatenation (.) at
> |	/usr/local/rt/lib/RT/User.pm line 855.
> | DBD::Pg::st execute failed: ERROR:  parser: parse error at or near ")"
> | RT::Handle=HASH(0x80f3778) couldn't execute the query 'SELECT COUNT(ACL.id)
> | FROM ACL, GroupMembers, Groups WHERE  ((((((RightScope = 'Queue') AND
> | (RightAppliesTo = 1))) AND ((RightName = 'CreateTicket'))) OR
> | ((RightName = 'SuperUser') AND (RightScope = 'System') AND
> | (RightAppliesTo = 0)))  AND (((ACL.PrincipalType = 'Group') AND
> | (ACL.PrincipalId = Groups.Id) AND (GroupMembers.GroupId = Groups.Id)  AND
> | (GroupMembers.UserId = ))))'ERROR:  parser: parse error at or near ")"
> | 
> | Can't call method "fetchrow" on an undefined value at /usr/pkg/lib/perl5/
> |	site_perl/5.6.0/DBIx/SearchBuilder/Handle.pm line 352.
> 
> 
>   Note the "(GroupMembers.UserId = )" in the sql statement above, 
> this is the reason it breaks. As to why there is nothing at the right
> of the =, no clue...
> 
>   Any ideas?
> 
> 	mjl
> 
> 
> _______________________________________________
> Rt-devel mailing list
> Rt-devel at lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-devel
> 

-- 
jesse reed vincent -- root at eruditorum.org -- jesse at fsck.com 
70EBAC90: 2A07 FC22 7DB4 42C1 9D71 0108 41A3 3FB3 70EB AC90

Emacs is a pretty good operating system, but Unix has a better editor.