Problems with sync

[decibel83]

Hi!

I have some serious problem with eGroupWare 1.4: I can’t sync it with Outlook at all!
Nor eGWOSync nor Funambol work with eGroupWare 1.4 and Outlook 2003…
eGWOSync doesn’t work because it fails the MySQL query:

"09/02/2008@2.16.25: "
"

Database error: Invalid SQL: SELECT contact_id,uid,modtime FROM egw_addressbook WHERE (egw_addressbook.contact_owner=5 OR contact_private=0 AND egw_addressbook.contact_owner IN (-1,5,0) OR egw_addressbook.contact_owner IS NULL) ORDER BY contact_id

mysql Error: 1054 (Unknown column ‘uid’ in ‘field list’)


File: /home/web/default/egroupware/etemplate/inc/class.so_sql.inc.php
Line: 734
Function: egw_db::select / so_sql::search / socontacts_sql::search / socontacts::search / contacts::old_read / boaddressbook::search / ExecMethod(addressbook.boaddressbook.search) / xmlrpc_server::parseRequest / xmlrpc_server::service

Session halted.

" "" and Funambol doesn't end the syncronization process with a curious error:

19:54:12 GMT +1:00 [DEBUG] - Modifications sent.
19:54:12 GMT +1:00 [DEBUG] - Connecting to server:80
19:54:12 GMT +1:00 [DEBUG] - Requesting resource /egroupware/rpc.php?syncml_sessionid=syncml-018f2c48aef36a797778feec3add2299
19:54:12 GMT +1:00 [DEBUG] - Sending data of size 253735…
19:54:14 GMT +1:00 [DEBUG] - Message sent
19:54:14 GMT +1:00 [DEBUG] - Finished sending data of size 253735.
19:54:14 GMT +1:00 [DEBUG] - Data sent succesfully to server. Server responds OK
19:54:14 GMT +1:00 [DEBUG] - Header:
19:54:14 GMT +1:00 [DEBUG] - Reading response…
19:54:14 GMT +1:00 [DEBUG] - Content-length: 0
19:54:14 GMT +1:00 [DEBUG] - Undefined content-length = 0. Using the maxMsgSize = 250000.
19:54:14 GMT +1:00 [DEBUG] - Receiving data of size 250000…
19:54:14 GMT +1:00 [ERROR] - Server Failure: server returned error code -1
19:54:14 GMT +1:00 [DEBUG] - ---------------------- END (mode “none”) ----------------------
19:54:14 GMT +1:00 [DEBUG] - Server requested syncmode “none” for .
19:54:14 GMT +1:00 [DEBUG] - Error occurred in sync: code 3 = Server Failure: server returned error code -1
19:54:14 GMT +1:00 [ERROR] - Error in syncing: Server Failure: server returned error code -1
19:54:14 GMT +1:00 [INFO] -

================ SYNCHRONIZATION REPORT ================

SYNCHRONIZATION COMPLETED WITH ERRORS

Last error message = "Server Failure: server returned error code -1"
Last error code = -1

I don’t have any error in the Apache error log.

What’s wrong? Could you help me please?
I can’t use eGroupWare without any syncing features with Outlook…

Thank you very much!
Bye.

[Patrick_Bihan-Faou-4]

Hi,

eGWOSync is known to be broken, however funambol should be working.

Which version of egroupware 1.4 are you using ?
Which version of funambol ?

Could you send the apache error log file for the failed sync ? The
funambol log file just tells you that there has been a problem on the
server. Investigation has to happen from there.

Thanks,

Patrick.

decibel83 a écrit :

[Jason_Schaefer-2]

Hi Patrick/community

It seemed there was going to be a maintenance release awhile ago for
these issues. What is the current status of this? MANY people are
really excited about having a functional syncML in a stable release.

Hi,

eGWOSync is known to be broken, however funambol should be working.

Which version of egroupware 1.4 are you using ?
Which version of funambol ?

Could you send the apache error log file for the failed sync ? The
funambol log file just tells you that there has been a problem on the
server. Investigation has to happen from there.

Thanks,

Patrick.

decibel83 a écrit :

Hi!

I have some serious problem with eGroupWare 1.4: I can’t sync it with
Outlook at all!
Nor eGWOSync nor Funambol work with eGroupWare 1.4 and Outlook 2003…
eGWOSync doesn’t work because it fails the MySQL query:

"09/02/2008@2.16.25: "
"

Database error: Invalid SQL: SELECT contact_id,uid,modtime FROM
egw_addressbook WHERE (egw_addressbook.contact_owner=5 OR contact_private=0
AND egw_addressbook.contact_owner IN (-1,5,0) OR
egw_addressbook.contact_owner IS NULL) ORDER BY contact_id

mysql Error: 1054 (Unknown column ‘uid’ in ‘field list’)


File:
/home/web/default/egroupware/etemplate/inc/class.so_sql.inc.php
Line:
734
Function: egw_db::select / so_sql::search / socontacts_sql::search
/ socontacts::search / contacts::old_read / boaddressbook::search /
ExecMethod(addressbook.boaddressbook.search) / xmlrpc_server::parseRequest /
xmlrpc_server::service

Session halted.

" "" and Funambol doesn't end the syncronization process with a curious error:

19:54:12 GMT +1:00 [DEBUG] - Modifications sent.
19:54:12 GMT +1:00 [DEBUG] - Connecting to server:80
19:54:12 GMT +1:00 [DEBUG] - Requesting resource
/egroupware/rpc.php?syncml_sessionid=syncml-018f2c48aef36a797778feec3add2299
19:54:12 GMT +1:00 [DEBUG] - Sending data of size 253735…
19:54:14 GMT +1:00 [DEBUG] - Message sent
19:54:14 GMT +1:00 [DEBUG] - Finished sending data of size 253735.
19:54:14 GMT +1:00 [DEBUG] - Data sent succesfully to server. Server
responds OK
19:54:14 GMT +1:00 [DEBUG] - Header:
19:54:14 GMT +1:00 [DEBUG] - Reading response…
19:54:14 GMT +1:00 [DEBUG] - Content-length: 0
19:54:14 GMT +1:00 [DEBUG] - Undefined content-length = 0. Using the
maxMsgSize = 250000.
19:54:14 GMT +1:00 [DEBUG] - Receiving data of size 250000…
19:54:14 GMT +1:00 [ERROR] - Server Failure: server returned error code -1
19:54:14 GMT +1:00 [DEBUG] - ---------------------- END (mode “none”)

19:54:14 GMT +1:00 [DEBUG] - Server requested syncmode “none” for .
19:54:14 GMT +1:00 [DEBUG] - Error occurred in sync: code 3 = Server
Failure: server returned error code -1
19:54:14 GMT +1:00 [ERROR] - Error in syncing: Server Failure: server
returned error code -1
19:54:14 GMT +1:00 [INFO] -

================ SYNCHRONIZATION REPORT ================

SYNCHRONIZATION COMPLETED WITH ERRORS

Last error message = "Server Failure: server returned error code -1"
Last error code = -1

I don’t have any error in the Apache error log.

What’s wrong? Could you help me please?
I can’t use eGroupWare without any syncing features with Outlook…

Thank you very much!
Bye.

---

This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft® Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/

---

eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers

---

This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft® Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/

---

eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers

[decibel83]

Which version of egroupware 1.4 are you using ?
Which version of funambol ?

I’m using eGroupWare 1.4.002 and Funambol 6.5.7.

Could you send the apache error log file for the failed sync ? The
funambol log file just tells you that there has been a problem on the
server. Investigation has to happen from there.
[/quote]

This is the extract of the Apache error log:

[Tue Feb 12 15:22:27 2008] [error] [client 192.168.1.111] Array\n(\n [0] => Array\n (\n
[id] => 374\n [photo] => \n )\n\n)\n
[Tue Feb 12 15:22:27 2008] [error] [client 192.168.1.111] Array\n(\n [0] => Array\n (\n [id] => 375\n [photo] => \n )\n\n)\n
[Tue Feb 12 15:22:27 2008] [error] [client 192.168.1.111] Array\n(\n [0] => Array\n (\n [id] => 376\n [photo] => \n )\n\n)\n
[Tue Feb 12 15:22:27 2008] [error] [client 192.168.1.111] Array\n(\n [0] => Array\n (\n [id] => 377\n [photo] => \n )\n\n)\n
[Tue Feb 12 15:22:27 2008] [error] [client 192.168.1.111] Array\n(\n [0] => Array\n (\n [id] => 380\n [photo] => \n )\n\n)\n
[Tue Feb 12 15:22:27 2008] [error] [client 192.168.1.111] Array\n(\n [0] => Array\n (\n [id] => 381\n [photo] => \n )\n\n)\n
[Tue Feb 12 15:22:27 2008] [error] [client 192.168.1.111] Array\n(\n [0] => Array\n (\n [id] => 382\n [photo] => \n )\n\n)\n
[Tue Feb 12 15:22:27 2008] [error] [client 192.168.1.111] Array\n(\n [0] => Array\n (\n [id] => 383\n [photo] => \n )\n\n)\n
[Tue Feb 12 15:22:27 2008] [error] [client 192.168.1.111] Array\n(\n [0] => Array\n (\n [id] => 384\n [photo] => \n )\n\n)\n
[Tue Feb 12 15:22:27 2008] [error] [client 192.168.1.111] Array\n(\n [0] => Array\n (\n [id] => 385\n [photo] => \n )\n\n)\n
[Tue Feb 12 15:22:27 2008] [error] [client 192.168.1.111] Array\n(\n [0] => Array\n (\n [id] => 386\n [photo] => \n )\n\n)\n
[Tue Feb 12 15:22:27 2008] [error] [client 192.168.1.111] Array\n(\n [0] => Array\n (\n [id] => 387\n [photo] => \n )\n\n)\n
[Tue Feb 12 15:22:27 2008] [error] [client 192.168.1.111] Array\n(\n [0] => Array\n (\n [id] => 389\n [photo] => \n )\n\n)\n
[Tue Feb 12 15:22:27 2008] [error] [client 192.168.1.111] Array\n(\n [0] => Array\n (\n [id] => 390\n [photo] => \n )\n\n)\n
[Tue Feb 12 15:22:27 2008] [error] [client 192.168.1.111] Array\n(\n [0] => Array\n (\n [id] => 391\n [photo] => \n )\n\n)\n
[Tue Feb 12 15:22:27 2008] [error] [client 192.168.1.111] Array\n(\n [0] => Array\n (\n [id] => 392\n [photo] => \n )\n\n)\n
[Tue Feb 12 15:22:27 2008] [error] [client 192.168.1.111] Array\n(\n [0] => Array\n (\n [id] => 393\n [photo] => \n )\n\n)\n
[Tue Feb 12 15:22:27 2008] [error] [client 192.168.1.111] Array\n(\n [0] => Array\n (\n [id] => 394\n [photo] => \n )\n\n)\n
[Tue Feb 12 15:22:27 2008] [error] [client 192.168.1.111] Array\n(\n [0] => Array\n (\n [id] => 395\n [photo] => \n )\n\n)\n
[Tue Feb 12 15:22:27 2008] [error] [client 192.168.1.111] Array\n(\n [0] => Array\n (\n [id] => 396\n [photo] => \n )\n\n)\n
[Tue Feb 12 15:22:27 2008] [error] [client 192.168.1.111] Array\n(\n [0] => Array\n (\n [id] => 397\n [photo] => \n )\n\n)\n
[Tue Feb 12 15:22:27 2008] [error] [client 192.168.1.111] Array\n(\n [0] => Array\n (\n [id] => 398\n [photo] => \n )\n\n)\n
[Tue Feb 12 15:22:27 2008] [error] [client 192.168.1.111] Array\n(\n [0] => Array\n (\n [id] => 399\n [photo] => \n )\n\n)\n
[Tue Feb 12 15:22:27 2008] [error] [client 192.168.1.111] Array\n(\n [0] => Array\n (\n [id] => 400\n [photo] => \n )\n\n)\n
[Tue Feb 12 15:22:27 2008] [error] [client 192.168.1.111] Array\n(\n [0] => Array\n (\n [id] => 402\n [photo] => \n )\n\n)\n
[Tue Feb 12 15:22:27 2008] [error] [client 192.168.1.111] Array\n(\n [0] => Array\n (\n [id] => 410\n [photo] => \n )\n\n)\n
[Tue Feb 12 15:22:27 2008] [error] [client 192.168.1.111] Array\n(\n [0] => Array\n (\n [id] => 412\n [photo] => \n )\n\n)\n
[Tue Feb 12 15:22:27 2008] [error] [client 192.168.1.111] Array\n(\n [0] => Array\n (\n [id] => 413\n [photo] => \n )\n\n)\n
[Tue Feb 12 15:22:27 2008] [error] [client 192.168.1.111] Array\n(\n [0] => Array\n (\n [id] => 414\n [photo] => \n )\n\n)\n

This is the extract of the /tmp/egroupware_syncml.log:

Feb 12 15:19:24 EGWSYNC [info] [] SyncML: setUID ./sifcontacts, 00000000B14AAA78FBCEA246942DB403B7121284C4172000, something went wrong!!! Mapping not found. [on line 374 of “/home/web/default/egroupware/phpgwapi/inc/horde/Horde/SyncML/State_egw.php”]
Feb 12 15:19:24 EGWSYNC [debug] [] SyncML: setUID contacts-520-5e193e9ffc2431ac5015a9788c7d3c0c => contacts-520-5e193e9ffc2431ac5015a9788c7d3c0c [on line 378 of “/home/web/default/egroupware/phpgwapi/inc/horde/Horde/SyncML/State_egw.php”]
Feb 12 15:19:24 EGWSYNC [debug] [] SyncML: setUID ./sifcontacts, 00000000B14AAA78FBCEA246942DB403B7121284C4172000, contacts-520-5e193e9ffc2431ac5015a9788c7d3c0c, 1202825964 [on line 383 of “/home/web/default/egroupware/phpgwapi/inc/horde/Horde/SyncML/State_egw.php”]
Feb 12 15:19:24 EGWSYNC [debug] [] SyncML: r/ added client entry as contacts-520-5e193e9ffc2431ac5015a9788c7d3c0c [on line 166 of “/home/web/default/egroupware/phpgwapi/inc/horde/Horde/SyncML/Sync/SlowSync.php”]
Feb 12 15:19:24 EGWSYNC [debug] [] SyncML: try to add contentype text/x-s4j-sifc to sifcontacts [on line 159 of “/home/web/default/egroupware/phpgwapi/inc/horde/Horde/SyncML/Sync/SlowSync.php”]
Feb 12 15:19:24 EGWSYNC [info] [] SyncML: setUID ./sifcontacts, 00000000B14AAA78FBCEA246942DB403B7121284E4172000, something went wrong!!! Mapping not found. [on line 374 of “/home/web/default/egroupware/phpgwapi/inc/horde/Horde/SyncML/State_egw.php”]
Feb 12 15:19:24 EGWSYNC [debug] [] SyncML: setUID contacts-521-5e193e9ffc2431ac5015a9788c7d3c0c => contacts-521-5e193e9ffc2431ac5015a9788c7d3c0c [on line 378 of “/home/web/default/egroupware/phpgwapi/inc/horde/Horde/SyncML/State_egw.php”]
Feb 12 15:19:24 EGWSYNC [debug] [] SyncML: setUID ./sifcontacts, 00000000B14AAA78FBCEA246942DB403B7121284E4172000, contacts-521-5e193e9ffc2431ac5015a9788c7d3c0c, 1202825964 [on line 383 of “/home/web/default/egroupware/phpgwapi/inc/horde/Horde/SyncML/State_egw.php”]
Feb 12 15:19:24 EGWSYNC [debug] [] SyncML: r/ added client entry as contacts-521-5e193e9ffc2431ac5015a9788c7d3c0c [on line 166 of “/home/web/default/egroupware/phpgwapi/inc/horde/Horde/SyncML/Sync/SlowSync.php”]
Feb 12 15:19:24 EGWSYNC [debug] [] SyncML: try to add contentype text/x-s4j-sifc to sifcontacts [on line 159 of “/home/web/default/egroupware/phpgwapi/inc/horde/Horde/SyncML/Sync/SlowSync.php”]
Feb 12 15:19:24 EGWSYNC [info] [] SyncML: setUID ./sifcontacts, 00000000B14AAA78FBCEA246942DB403B712128404182000, something went wrong!!! Mapping not found. [on line 374 of “/home/web/default/egroupware/phpgwapi/inc/horde/Horde/SyncML/State_egw.php”]
Feb 12 15:19:24 EGWSYNC [debug] [] SyncML: setUID contacts-522-5e193e9ffc2431ac5015a9788c7d3c0c => contacts-522-5e193e9ffc2431ac5015a9788c7d3c0c [on line 378 of “/home/web/default/egroupware/phpgwapi/inc/horde/Horde/SyncML/State_egw.php”]
Feb 12 15:19:24 EGWSYNC [debug] [] SyncML: setUID ./sifcontacts, 00000000B14AAA78FBCEA246942DB403B712128404182000, contacts-522-5e193e9ffc2431ac5015a9788c7d3c0c, 1202825964 [on line 383 of “/home/web/default/egroupware/phpgwapi/inc/horde/Horde/SyncML/State_egw.php”]
Feb 12 15:19:24 EGWSYNC [debug] [] SyncML: r/ added client entry as contacts-522-5e193e9ffc2431ac5015a9788c7d3c0c [on line 166 of “/home/web/default/egroupware/phpgwapi/inc/horde/Horde/SyncML/Sync/SlowSync.php”]
Feb 12 15:19:24 EGWSYNC [debug] [] SyncML: try to add contentype text/x-s4j-sifc to sifcontacts [on line 159 of “/home/web/default/egroupware/phpgwapi/inc/horde/Horde/SyncML/Sync/SlowSync.php”]

Bye!

[decibel83]

Could you send the apache error log file for the failed sync ? The
funambol log file just tells you that there has been a problem on the
server. Investigation has to happen from there.

Patrick,
I can let you to access to my testing server, if you want.
Please let me know.