We have the same problem, but it's not a bug in SyncML.

A check is missing before kronolith/lib/Driver/sql.php on line 227 
(rev 1.204 or even 1.136.2.36)

Sometimes, the endDate is already set to 31/12/9999, so 
Date_Calc::nextDay returns Date_Calc::dateNow (in the function 
Date_Calc::dateFormat)

I'll open a bug report in Kronolith.

As far as I can see, we always retrieve all future events when doing 
slow syncs. Please provide all relevant syncml log files.

in the report i'm talking about end date in the query. Off course i 
mean the event_start and not the event_end.



Sorry for this mistype

Version: Horde Webmail RC4

Postgres: 8.1 and 8.3



When using the Funambol plugin in Outlook 2003 and i do a sync the 
first time i don't get back all the appointments made. When checking 
the debug logs created by Horde i see that the end date in the query 
isnt correct. This is the query made that is in the logs 
(PEAR_LOG_DEBUG).



May 21 10:46:03 HORDE [debug] [kronolith] 
Kronolith_Driver_sql::listEventsConditional(): user = "<myuser>"; 
query = "SELECT event_id, event_uid, event_description, 
event_location, event_private, event_status, event_attendees, 
event_keywords, event_title, event_category, event_recurcount, 
event_recurtype, event_recurenddate, event_recurinterval, 
event_recurdays, event_start, event_end, event_alarm, event_modified, 
event_exceptions, event_creator_id FROM kronolith_events WHERE 
calendar_id = ? AND ((event_end > ? AND event_start < ?) OR 
(event_recurenddate >= ? AND event_start <= ? AND event_recurtype <> 
?))"; values = "<myuser>,0000-01-01 00:00:00,2008-05-22 
00:00:00,0000-01-01 00:00:00,2008-05-22 00:00:00,0" [pid 20638 on line 
305 of 
"/home/websites/webmail_horde/horde/kronolith/lib/Driver/sql.php"]



You can see here that the end date of the event start is set to 
2008-05-22 00:00:00. which results in giving me back all appointment 
till that date. When i manually do this query in the postgres command 
line i get (464 rows) back. This is also the number i see in my 
Funambol plugin and total appointments in my Outlook. When i change 
the query on the command line and set the end-date to e.g. 2018-05-22 
00:00:00 i get (507 rows). This includes the future appointments i 
dont get with the first query.



When this recover/first sync is done the time when i connected is 
stored i asume. Next time i sync it checks for changes since that last 
time i connected. This wont give me the appointments of next week 
since they where suppose to be in the first sync and arent changed. 
When i edit a appointment and 'save as new' then it gets synced in the 
next session. Modifying the appointment wont sync it, only saving as 
new.



Same results with Thunderbird 2 and the Funambol plugin 0.4.4 and 
Lighting 0.8.