[rt-devel] RT 2.0.4 and Dates

[Sebek Pavel]

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