Tickets :: Comment on [#6731] Funambol sync query problem

* Your Email Address
* Spam protection	Enter the letters below: . .\ /._..___.__. \|_/ >< \| [__ [__] \| \/ \_\|_[___\| \|
Comment	> 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.
Attachment
Watch this ticket

Saved Queries