[rt-devel] RT 2.0.4 and Dates

Jesse jesse at fsck.com
Fri Jul 27 01:28:10 EDT 2001


DBIx-SearchBuilder 0.41, which fixes this issue, has just entered CPAN.
I'd love to know that this fixes things ;)

        -j


On Fri, Jul 27, 2001 at 12:17:49AM +0100, Feargal Reilly wrote:
> 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.
> 



-- 
jesse reed vincent -- root at eruditorum.org -- jesse at fsck.com 
70EBAC90: 2A07 FC22 7DB4 42C1 9D71 0108 41A3 3FB3 70EB AC90

There are no supercomputer applications that are solvable that cannot be solved
in finite time using a fucking TRS-80 with approprite disk/tape drives.  Zero.
									-Tanj
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 240 bytes
Desc: not available
Url : http://pallas.eruditorum.org/pipermail/rt-devel/attachments/20010727/0296fe83/attachment.pgp


More information about the Rt-devel mailing list