[Tickets #9229] wrong date for SQL generated

[bugs at horde.org]

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

Ticket URL: http://bugs.horde.org/ticket/9229
------------------------------------------------------------------------------
  Ticket             | 9229
  Created By         | d-fens at 00010111.de
  Summary            | wrong date for SQL generated
  Queue              | Horde Framework Packages
  Version            | Git master
  Type               | Bug
  State              | Unconfirmed
  Priority           | 2. Medium
  Milestone          |
  Patch              |
  Owners             |
------------------------------------------------------------------------------


d-fens at 00010111.de (2010-09-06 08:35) wrote:

hi,

don't know if its syncml or kronolith bug:
when tring to get the changes from the server a invalid date is generate:

2010-09-06T14:29:42+02:00 DEBUG: HORDE [kronolith]  
Kronolith_Driver_Sql::_listEventsConditional(): user = "xx at xxx.de";  
query = "SELECT event_id, event_uid, event_description,  
event_location, event_private, event_status, event_attendees,  
event_title, event_recurcount, event_url, event_recurtype,  
event_recurenddate, event_recurinterval, event_recurdays, event_start,  
event_end, event_allday, event_alarm, event_alarm_methods,  
event_modified, event_exceptions, event_creator_id, event_resources,  
event_baseid, event_exceptionoriginaldate FROM kronolith_events WHERE  
calendar_id = ? AND ((event_end >= ? AND event_start <= ?) OR  
(event_recurenddate >= ? AND event_start <= ? AND event_recurtype <>  
?))"; values = "xxx at xx.de,-0001-11-29 23:00:00,-0001-11-30  
22:59:59,-0001-11-29 23:00:00,-0001-11-30 22:59:59,0" [pid 24653 on  
line 352 of  
"/var/www/catchall/htdocs/horde/kronolith/lib/Driver/Sql.php"]