[rt-users] Incompatibilities Pg 7.3.5/RT 3.2.1 and Pg 7.4.7/RT 3.4.1?

[Jay R. Ashworth]

On Sat, Mar 12, 2005 at 05:02:04PM +0100, Tomas A. P. Olaj wrote:
> Running:
> 
> RT 3.4.1
> Perl 5.8.6
> Postgres 7.4.7
> ModFastCGI 2.4.2
> Apache 2.0.52
> 
> I have imported the Postgres database (former Postgres 7.3.5 and RT 3.2.1)
> into the new Postgres 7.4.7, and ran the upgrading scripts in the RT
> 3.4.1.
> 
> I´m getting this error after trying to update a password phrase in the
> "Modify the user..." part of RT 3.4.1:
> 
> System error
> 
> error:  Can't call method "new" without a package or object reference at
> /site/rt-3.4.1/lib/RT/Transaction_Overlay.pm line 910, <DATA> line 331.
> 
> The Apache log says:
> 
> [Sat Mar 12 16:50:19 2005] [error] [client 81.191.11.111] FastCGI: server
> "/site/rt-3.4.1/bin/mason_handler.fcgi" stderr: DBD::Pg::st execute
> failed: ERROR:  column "lastupdated" is of type timestamp without time
> zone but expression is of type character varying, referer:
> https://rt-test.uio.no/Admin/Users/Modify.html?id=12

Downgrade your DBD::Pg to 1.32; see if that fixes your problem.

Note that this is currently the canonical answer for "it doesn't work
with PostGres"; there's a (stupid; I agree with Jesse) change in 1.40
that breaks it's compatibility with DBIx:SearchBuilder.

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 adminstrator.  Or two.  --me