Tickets :: Comment on [#8590] postgresql 8.4.1 error "date/time field value out of range" using iCal/WebDAV

* Your Email Address
* Spam protection	Enter the letters below: _____ _______ ___ __ / ____\| __ \ \ / \ \ / //\ \| \| \| \| \| \ \ / / \ \_/ // \ \| \| \| \| \| \|\ \/ / \ // /\ \ \| \|____\| \|__\| \| \ / \| \|/ ____ \ \_____\|_____/ \/ \|_/_/ \_\
Comment	> The kronolith service will export an invalid iCal file due to a date > out of range error during the query to the postgresql 8.4.1 server. > The query that causes the error follows: > > > > Sep 21 11:23:57 HORDE [error] [kronolith] DB Error: unknown error: > SELECT event_id, event_uid, event_description, event_location, > event_private, event_status, event_at > > tendees, event_keywords, event_title, event_category, > event_recurcount, event_recurtype, event_recurenddate, > event_recurinterval, event_recurdays, event_start, event_e > > nd, event_alarm, event_modified, event_exceptions, event_creator_id > FROM kronolith_events WHERE calendar_id = 'username' AND ((event_end > > '0000-01-01 00:00:00' AND event_start < '9999-12-31 00:00:00') OR > (event_recurenddate >= '0000-01-01 00:00:00' AND event_start <= > '9999-12-31 00:00:00' AND event_recurtype <> 0)) [nativecode=ERROR: > date/time field value out of range: "0000-01-01 00:00:00" at > character 406] [pid 13841 on line 331 of > "/var/www/html/horde-webmail-1.2.4/kronolith/lib/Driver/sql.php"] > > > > Postgresql doesn't like the timestamp "0000-01-01 00:00:00". > Modifying the file "kronolith/lib/Driver/sql.php" to what is in the > patch fixes the problem.
Attachment
Watch this ticket