[kronolith] Export does not work with pgsql

[Jan Schneider]

Zitat von "Marcus I. Ryan" <marcus@riboflavin.net>:

> All Dates - if I specify a range it works because it has valid dates.
>  When I select all events the query generated is:
> 
> SELECT DISTINCT e.event_id, e.event_recurtype 
>   FROM kronolith_events e 
>  WHERE e.calendar_id = 'shad@riboflavin.net' 
>    AND ((e.event_start < '9999-12-31 00:00:00.000' 
>    AND e.event_end > '0000-00-00 00:00:00.000') 
>     OR (e.event_recurenddate >= '0000-00-00 00:00:00.000' 
>    AND e.event_start <= '9999-12-31 00:00:00.000' 
>    AND e.event_recurtype != 0))
> 
> pgsql does not like months or monthdays of 00.  Changing the
> 0000-00-00 dates to 0000-01-01 fixes the problem.
> 
> I just haven't found WHERE those dates are stored...

That should be fixed now in cvs. Could try out?

Jan.

--
::::::::::::::::::::::::::::::::::::::::
AMMMa AG - discover your knowledge
:::::::::::::::::::::::::::
Detmolder Str. 25-33 :: D-33604 Bielefeld
fon +49.521.96878-0 :: fax  +49.521.96878-20
http://www.ammma.de
::::::::::::::::::::::::::::::::::::::::::::::