[sync] Invalid address book: localsql

[Ronan SALMON]

This is what I can see. The column device looks blank :-(.

Device	Database	Server-TS	Client-TS	Delete
	contacts	17/01/2008 18:06	1200586404


Here are some logs from /tmp/horde.log :
Jan 17 18:52:18 HORDE [debug] [horde] SyncML: slowsync-add:  
20080117180913.465617vlk8qpv4ys at webmail.mbpgroup.local ignored [pid  
22401 on line 192 of "/usr/share/pear/SyncML/Backend/Horde.php"]
Jan 17 18:52:18 HORDE [debug] [horde] SyncML: slowsync-add:  
20080117162614.10894q1dam7ty16o at webmail.mbpgroup.local ignored [pid  
22401 on line 192 of "/usr/share/pear/SyncML/Backend/Horde.php"]
Jan 17 18:52:18 HORDE [debug] [horde] SyncML: sending 0 server changes  
for syncType=scard [pid 22401 on line 337 of  
"/usr/share/pear/SyncML/Sync.php"]
Jan 17 18:52:18 HORDE [debug] [horde] SyncML: Received Final from  
client. [pid 22401 on line 31 of  
"/usr/share/pear/SyncML/Command/Final.php"]
Jan 17 18:52:18 HORDE [debug] [horde] SyncML: Sending Final to client.  
[pid 22401 on line 512 of "/usr/share/pear/SyncML.php"]
Jan 17 18:52:18 HORDE [debug] [horde] SyncML: SyncML: return message  
completed [pid 22401 on line 547 of "/usr/share/pear/SyncML.php"]
Jan 17 18:52:18 HORDE [debug] [horde] SyncML: Finished at 2008-01-17  
18:52:18. Packet logged in /tmp/sync/syncml_server_171.xml [pid 22401  
on line 824 of "/usr/share/pear/SyncML/Backend.php"]
Jan 17 18:52:18 HORDE [debug] [horde] SyncML: Backend of class  
SyncML_Backend_Horde created [pid 22401 on line 251 of  
"/usr/share/pear/SyncML/Backend.php"]
Jan 17 18:52:18 HORDE [debug] [horde] SyncML: Existing session  
continued: 0db2bce8f70f47c2a6f3b05d2689cc54 [pid 22401 on line 43 of  
"/usr/share/pear/SyncML/Command/SyncHdr.php"]
Jan 17 18:52:18 HORDE [debug] [horde] SyncML: authorized=1 version=1  
msgid=3 source=fol-TUJQMDAwRjFGMjdENzJEOnJzYWxtb24=  
target=http://192.168.1.70/horde/rpc.php user=rsalmon charset=UTF-8  
wbxml= [pid 22401 on line 447 of "/usr/share/pear/SyncML.php"]
Jan 17 18:52:18 HORDE [debug] [horde] SyncML: HandleFinal for state=3  
[pid 22401 on line 539 of "/usr/share/pear/SyncML/Sync.php"]
Jan 17 18:52:18 HORDE [debug] [horde] SyncML: Received Final from  
client. [pid 22401 on line 31 of  
"/usr/share/pear/SyncML/Command/Final.php"]
Jan 17 18:52:18 HORDE [debug] [horde] SyncML: Sending Final to client.  
[pid 22401 on line 512 of "/usr/share/pear/SyncML.php"]
Jan 17 18:52:18 HORDE [debug] [horde] SQL Query by  
DataTree_sql::_exists(): SELECT datatree_id FROM horde_datatree WHERE  
group_uid = ? AND datatree_name = ? AND datatree_parents = ?, array (
   0 => 'horde.syncml',
   1 => 'rsalmon',
   2 => '',
) [pid 22401 on line 398 of "/usr/share/pear/Horde/DataTree/sql.php"]
Jan 17 18:52:18 HORDE [debug] [horde] SQL Query by  
DataTree_sql::_exists(): SELECT datatree_id FROM horde_datatree WHERE  
group_uid = ? AND datatree_name = ? AND datatree_parents = ?, array (
   0 => 'horde.syncml',
   1 => 'rsalmon',
   2 => '',
) [pid 22401 on line 398 of "/usr/share/pear/Horde/DataTree/sql.php"]
Jan 17 18:52:18 HORDE [debug] [horde] SQL Query by  
DataTree_sql::add(): INSERT INTO horde_datatree (datatree_id,  
group_uid, datatree_name, datatree_order, datatree_data, user_uid,  
datatree_serialized, datatree_parents) VALUES (?, ?, ?, ?, ?, ?, ?,  
?), array (
   0 => 210,
   1 => 'horde.syncml',
   2 => 'contacts',
   3 => NULL,
   4 =>  
'a:2:{s:12:"ClientAnchor";s:10:"1200589154";s:12:"ServerAnchor";i:1200592336;}',
   5 => 'rsalmon',
   6 => 15,
   7 => ':0:0',
) [pid 22401 on line 612 of "/usr/share/pear/Horde/DataTree/sql.php"]
Jan 17 18:52:18 HORDE [info] [horde] SyncML: Successful sync of scard!  
Summary: failures=0; client(Add,Replace,Delete,AddReplaces)=0,5,0,0;  
server(Add,Replace,Delete)=0,0,0 [pid 22401 on line 621 of  
"/usr/share/pear/SyncML/Sync.php"]
Jan 17 18:52:18 HORDE [debug] [horde] SyncML: Finished at 2008-01-17  
18:52:18. Packet logged in /tmp/sync/syncml_server_172.xml [pid 22401  
on line 824 of "/usr/share/pear/SyncML/Backend.php"]



Ronan.


Quoting Jan Schneider <jan at horde.org>:

> Zitat von Ronan SALMON <rsalmon at mbpgroup.com>:
>
>> I can sync contacts now, thanks Jan.
>>
>> The only think, now is that horde is always asking for a slowsync.
>> I delete All SyncML Data and this is what I get after syncing
twice :
>
>> DEBUG:  SyncML: No info about previous syncs found for device  
>> fol-TUJQMDAwRjFGMjdENzJEOnJzYWxtb24= and database scard
>
> Check if entries for this device-database-combination exist, in
your
> SyncML options and the admin's DataTree browser.
>
> Jan.
>
> -- 
> Do you need professional PHP or Horde consulting?
> http://horde.org/consulting/
>
>