[rt-devel] RT 2.0.4 and Dates

[Feargal Reilly]

This is casued because your postgres has a PGDATESTYLE other than ISO.
DBIx-SearchBuilder doesn't allow for this at present.

To fix it,
Make the following change to <perlpath>/DBIx/SearchBuilder/Handle/Pg.pm
After line 26, where it reads:
    $self->SimpleQuery("SET TIME ZONE 'GMT'");

put 
    $self->SimpleQuery("SET DATESTYLE TO 'ISO'");

This will ensure that RT connections are handed the correct datestyle, 
and all your other databases will be unaffected.

Don't forget to stop and restart your mod_perl apache.

-Feargal.

On Thu, 26 Jul 2001 18:43:24 +0200
Sebek Pavel <Pavel.Sebek at i.cz> wrote:

> Hi there.  I recently installed 2.0.4 and upon playing, I see "Not set"
> everywhere a time and date should be.    Everything else seems to work...
> 
> System config:
> 
> Mandrake 7.2 x86
> Apache-1.3.14 with mod_perl
> Perl 5.6.0
> Postgres 7.0.2
> testdeps passes without a problem
> 
> Can anybody  help me please
> 
> Sebek Pavel
> 
> 
> 
> _______________________________________________
> Rt-devel mailing list
> Rt-devel at lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-devel
> 


-- 
Feargal Reilly,
Systems Administrator,
The CIA.

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 230 bytes
Desc: not available
Url : http://pallas.eruditorum.org/pipermail/rt-devel/attachments/20010727/e7f59efc/attachment.pgp