[kronolith] Sync problems with Kronolith and Horde 4

[Claudio Prono]

Hello all,

I have always used Funambol Mozilla Sync to sync the calendars on
Kronolith and Horde. But now, after the update of Horde to the version
4, and Kronolith to the versione 3.0.2, the sync fails and into the logs
i can read this:

When i sync, i have this error into the logs:

2011-05-03T15:19:07+02:00 DEBUG: HORDE [kronolith] SQL  (0.0005s)
        SELECT event_id, event_uid, calendar_id, 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
          event_uid =
         
'20110503124426.awmOSANRg2JNv9yKCmoRMCA at webmail.mediaservice.net' [pid
10760 on line 783 of "/usr/share/php5/PEAR/Horde/Db/Adapter/Base.php"]
2011-05-03T15:19:07+02:00 EMERG: HORDE [horde]
20110503124426.awmOSANRg2JNv9yKCmoRMCA at webmail.mediaservice.net not
found [pid 10760 on line 484 of
"/srv/www/horde.new/horde/kronolith/lib/Driver/Sql.php"]
2011-05-03T15:19:07+02:00 DEBUG:  1. Horde_Rpc_Syncml->getResponse()
/srv/www/horde.new/horde/rpc.php:128
 2. Horde_SyncMl_ContentHandler->process()
/usr/share/php5/PEAR/Horde/Rpc/Syncml.php:52
 3. xml_parse() /usr/share/php5/PEAR/Horde/SyncMl/ContentHandler.php:131
 4. Horde_SyncMl_ContentHandler->_endElement()
 5. Horde_SyncMl_ContentHandler->endElement()
/usr/share/php5/PEAR/Horde/SyncMl/ContentHandler.php:217
 6. Horde_SyncMl_ContentHandler->handleCommand()
/usr/share/php5/PEAR/Horde/SyncMl/ContentHandler.php:304
 7. Horde_SyncMl_Command_Sync->handleCommand()
/usr/share/php5/PEAR/Horde/SyncMl/ContentHandler.php:434
 8. Horde_SyncMl_Sync->handleClientSyncItem()
/usr/share/php5/PEAR/Horde/SyncMl/Command/Sync.php:306
 9. Horde_SyncMl_Backend_Horde->replaceEntry()
/usr/share/php5/PEAR/Horde/SyncMl/Sync.php:310
10. Horde_Registry->call()
/usr/share/php5/PEAR/Horde/SyncMl/Backend/Horde.php:404
11. Horde_Registry->callByPackage()
/usr/share/php5/PEAR/Horde/Registry.php:958
12. call_user_func_array() /usr/share/php5/PEAR/Horde/Registry.php:999
13. Kronolith_Api->replace()
14. Kronolith_Driver_Sql->getByUID()
/srv/www/horde.new/horde/kronolith/lib/Api.php:940

And the Funambol plugin exits with error code -1. What can be wrong now?

Effectively, if i try to do the following query on the mysql database by hand, it produces an empty set:

SELECT event_id, event_uid, calendar_id, 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
          event_uid ='20110503124426.awmOSANRg2JNv9yKCmoRMCA at webmail.mediaservice.net';

Any hint of why that event_uid is not present? And why that causes a syncronization failure?

Cordially,

Claudio Prono.




-- 
--------------------------------------------------------------------------------
Claudio Prono                         OPST
System Developer               
                                      Gsm: +39-349-54.33.258
@PSS Srl                              Tel: +39-011-32.72.100
Via San Bernardino, 17                Fax: +39-011-32.46.497
10141 Torino - ITALY                  http://atpss.net/disclaimer
--------------------------------------------------------------------------------
PGP Key - http://keys.atpss.net/c_prono.asc