[rt-users] RT 3.4.2 installation woes

[Jay R. Ashworth]

On Tue, May 24, 2005 at 08:54:56PM -0400, David Glasser wrote:
> On 5/24/05, Adrian Close <adrian.close at hitwise.com> wrote:
> > On Tue, 24 May 2005, Gavin Henry wrote:
> > I don't have any segfaults in my Apache log - Apache seems quite happy.
> > I do have the following database error, which occurs when I go to create a
> > new user:
> > 
> > [Wed May 25 09:41:16 2005] [error] [client 210.9.182.38] FastCGI: server "/opt/rt3/bin/mason_handler.fcgi" stderr: DBD::Pg::st execute failed: ERROR:  invalid input syntax for integer: ""
> > [Wed May 25 09:41:16 2005] [error] [client 210.9.182.38] FastCGI: server
> > "/opt/rt3/bin/mason_handler.fcgi" stderr: RT::Handle=HASH(0x953083c) couldn't
> > execute the query 'SELECT  * FROM Principals WHERE LOWER(PrincipalType) = ? AND
> > (ObjectId IS NULL OR ObjectId = '')' at /usr/local/lib/perl5/site_perl/5.8.6/DBIx/SearchBuilder/Handle.pm line 494.
> 
> This is an known issue in DBIx::SearchBuilder involving searching for
> null fields under Postgres; in fact, we checked in a fix for it just
> this afternoon and are currently trying to ensure that we have fully
> fixed the problem.

And, to recap the workaround, if you haven't already manually
downgraded your DBD::Pg from 1.4x to 1.32, do so, and try again.

Cheers,
-- jra
-- 
Jay R. Ashworth                                                jra at baylink.com
Designer                          Baylink                             RFC 2100
Ashworth & Associates        The Things I Think                        '87 e24
St Petersburg FL USA      http://baylink.pitas.com             +1 727 647 1274

      If you can read this... thank a system administrator.  Or two.  --me