[kronolith] Export does not work with pgsql

[Marcus I. Ryan]

That's fixed it.  Thanks!
-- 
Marcus I. Ryan, marcus@riboflavin.net
-----------------------------------------------------------------------
 "Love is a snowmobile racing across the tundra and then suddenly it
 flips over, pinning you underneath.  At night, the ice weasels come."
                 -- Matt Groening
-----------------------------------------------------------------------


Quoting Jan Schneider <jan@horde.org>:

> 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
> ::::::::::::::::::::::::::::::::::::::::::::::
> 
> -- 
> Kronolith mailing list: http://horde.org/kronolith/
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: kronolith-unsubscribe@lists.horde.org
> 
>