Hi,
I’m trying to sync my PDA (SHARP W-ZERO3, Windows Mobile, funambol v3.0.31) & egroupware 1.2.105 via SyncML.
First time they synced successfully with Replace Local Data mode.
However, when I tried to sync them with Replace Local Data mode (not Update Local Data model) again, the server returned the following error message:
21:34:33:280 [DEBUG] - Requesting resource /egroupware/rpc.php?syncml_sessionid=syncml-xxxxxxxxxxxxxxx
21:34:36:623 [DEBUG] - Message sent
21:34:36:639 [DEBUG] - Reading response…
21:34:36:655 [DEBUG] - Content-length: 850
21:34:36:670 [DEBUG] - Response read
21:34:36:701 [DEBUG] -
Database error: Invalid SQL: UPDATE egw_cal_user SET cal_recur_date=cal_recur_date+6048000 WHERE cal_id=966 AND cal_recur_date != 0
mysql Error: 1062 (Duplicate entry ‘966-1167008400-u-27’ for key 1)
Function: socal::move / socal::save / bocalupdate::save / bocalupdate::update / sifcalendar::addSIF / _egwsifcalendarsync_replace(calendar-966-xxxxxxxxxxxxxxxxxxxxx) / call_user_func_array(_egwsifcalendarsync_replace) / Registry::callByPackage / Registry::call / Horde_SyncML_Sync_SlowSync::runSyncCommand / Horde_SyncML_Sync::nextSyncCommand / Horde_SyncML_Command_Sync::output / Horde_SyncML_SyncMLBody::endElement / Horde_RPC_syncml::endElement / Horde_RPC_syncml::_endElement / xml_parse(Resource id #90) / Horde_RPC_syncml::_parse / Horde_RPC_syncml::getResponse
Session halted.
21:34:36:717 [ERROR] - Server Failure: server returned error code -1
21:34:36:733 [ERROR] - Error in syncing: Server Failure: server returned error code -1
21:34:36:764 [INFO] - Calendar sync completed with errors
Unfortunately I couldn’t find which part caused this problem.
Can anyone tell me which part should I check or the solution of this problem?
Thank you very much.
Heiga Zen
