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

[bugs at horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/8590
------------------------------------------------------------------------------
  Ticket             | 8590
  Created By         | tx4587 at crawford.homeunix.mnet
  Summary            | postgresql 8.4.1 error "date/time field value out of
                     | range" using iCal/WebDAV
  Queue              | Kronolith
  Version            | 2.3.2
  Type               | Bug
  State              | Unconfirmed
  Priority           | 2. Medium
  Milestone          |
  Patch              | 1
  Owners             |
+New Attachment     | kronolith_sql.patch
------------------------------------------------------------------------------


tx4587 at crawford.homeunix.mnet (2009-09-21 15:09) wrote:

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.