[rt-users] problems with PostgreSQL 7.3.1

[Julian C. Dunn]

On Wed, 2003-02-05 at 12:39, Robie Basak wrote:
> On Wed, 2003-02-05 at 16:48, Julian C. Dunn wrote:
> > I noticed in the mailing list archives that many people are having
> > problems with PostgreSQL 7.3.1 and RT 2.0.15. Notwithstanding the
> > DBIx::SearchBuilder problems (with the 0.7x series -- downgrading to the
> > 0.6x series helps solve the "Can't bind reference" errors) there are
> > still difficulties with using Postgres 7.3. I think I see what the
> > problem is.
> 
> See a problem I had with DBIx::SearchBuilder:
>   http://fsck.com/rt2/Ticket/Display.html?id=1624

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...

- Julian

-- 
-- Julian C. Dunn, B.A.Sc.  <jdunn at verticalscope.com>
-- Senior Software Developer / UNIX Systems Administrator
-- VerticalScope Inc.
-- 111 Peter St., Suite 700, Toronto, ON
-- Tel: (416) 341-8950 x236  Fax: (416) 341-8959
-- PGP Key: 0x4EE2041F