[Tickets #6731] Funambol sync query problem

[bugs at horde.org]

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

Ticket URL: http://bugs.horde.org/ticket/6731
-----------------------------------------------------------------------
 Ticket             | 6731
 Created By         | b.van.lent at prompt.nl
 Summary            | Funambol sync query problem
 Queue              | SyncML
 Type               | Bug
 State              | Unconfirmed
 Priority           | 1. Low
 Milestone          |
 Patch              |
 Owners             |
-----------------------------------------------------------------------


b.van.lent at prompt.nl (2008-05-21 05:33) wrote:

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.