[rt-users] problems with PostgreSQL 7.3.1

[Robie Basak]

On Mon, 2003-02-10 at 16:14, Julian C. Dunn wrote:
> It seems the problem I'm having is different than what you were having.
> In WebRT's error log I see this:
> 
> [Mon Feb 10 16:08:14 2003] [error] [client 209.82.14.131] FastCGI: server "/usr/
> local/rt2.0.15/bin/mason_handler.fcgi" stderr: DBD::Pg::st execute failed: ERROR
> :  pg_atoi: zero-length string at /usr/local/lib/perl5/site_perl/5.6.1/DBIx/Sear
> chBuilder/Handle.pm line 365, <GEN179> line 47.
> [Mon Feb 10 16:08:14 2003] [error] [client 209.82.14.131] FastCGI: server "/usr/
> local/rt2.0.15/bin/mason_handler.fcgi" stderr: RT::Handle=HASH(0x8a64d38) couldn
> 't execute the query 'INSERT INTO Transactions (Creator, OldValue, TimeTaken, Ti
> cket, Data, NewValue, Field, Created, Type) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)'E
> RROR:  pg_atoi: zero-length string
> 
> I did some digging and it looks like somewhere along the line,
> "TimeTaken" is being set to undef (or is never defined in the first
> place) so the whole thing falls apart.
> 
> I will try your patch, but somehow I'm not sure it will solve the
> problem...

It looks to me like the Postgres interface doesn't like undef being
given as a value. No idea why, I'd have thought that'd be interpreted as
an SQL NULL. You could try something like:

$TimeTaken = 0 unless defined $TimeTaken;

At the appropriate place (I haven't seen the code, so know nothing about
variable names in use though).

HTH,
Robie.
-- 
Robie Basak <robie at principle.co.uk>
Northern Principle Limited