[rt-devel] RT 2.0.4 and Dates

[Feargal Reilly]

Have you stopped and started apache?

-Feargal.

On Fri, 27 Jul 2001 09:46:44 +0200
Sebek Pavel <Pavel.Sebek at i.cz> wrote:

> Thank you for your answer, but I have still the same problem.
> I installed DBIx-SearchBuilder 0.41
> 
> Setting PGDATESTYLE:
> ------------------------------------------------------------
> Welcome to psql, the PostgreSQL interactive terminal.
> 
> Type:  \copyright for distribution terms
>         \h for help with SQL commands
>         \? for help on internal slash commands
>         \g or terminate with semicolon to execute query
>         \q to quit
> 
> rt2=# show datestyle;
> NOTICE:  DateStyle is ISO with US (NonEuropean) conventions
> SHOW VARIABLE
> rt2=#
> -------------------------------------------------------------
> 
> Can anybody  help me please once more?
> 
> Sebek Pavel
> 
> 
> 
> 
> 
> Jesse wrote:
> 
> > 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.
> >>
> >>
> > 
> > 
> > 
> 
> 
> 
> 


-- 
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/72993eb1/attachment.pgp