[kronolith] Need help debugging SyncML...
Eric Knudstrup
eknuds-kronolith at knudstrup.org
Tue Jul 24 22:23:11 UTC 2007
I'm having trouble getting SyncML to work at all with Horde Groupware
1.0.1. It was working for some time, then just died. It's been a while
since this happened so I'm not sure what changed.
I'm using the Synthesis client and it just says that the server didn't
return any SyncML data.
Eric
Jul 24 15:11:11 HORDE [debug] [horde] SyncML: New session created:
syncml1D15BBE5CD14A2C5EE7361C20B8AF36AA660DD9654 [on line 172 of
"/home/httpd/https/horde-webmail-1.0/lib/SyncML.php"]
Jul 24 15:11:11 HORDE [debug] [horde] SyncML: checking auth for
user=eknuds [on line 261 of
"/home/httpd/https/horde-webmail-1.0/lib/SyncML/State.php"]
Jul 24 15:11:11 HORDE [debug] [imp] SQL Query by Prefs_sql::retrieve():
SELECT pref_scope, pref_name, pref_value FROM horde_prefs WHERE pref_uid
= ? AND (pref_scope = ? OR pref_scope = 'horde') ORDER BY pref_scope [on
line 137 of "/home/httpd/https/horde-webmail-1.0/lib/Horde/Prefs/sql.php"]
Jul 24 15:11:12 HORDE [debug] [imp] SQL Query by Prefs_sql::retrieve():
SELECT pref_scope, pref_name, pref_value FROM horde_prefs WHERE pref_uid
= ? AND (pref_scope = ? OR pref_scope = 'horde') ORDER BY pref_scope [on
line 137 of "/home/httpd/https/horde-webmail-1.0/lib/Horde/Prefs/sql.php"]
Jul 24 15:11:12 HORDE [notice] [imp] Login success for eknuds
[32.147.164.148] to {localhost:143} [on line 118 of
"/home/httpd/https/horde-webmail-1.0/imp/lib/api.php"]
Jul 24 15:11:12 HORDE [debug] [horde] SyncML: authorized=1 version=1
msgid=1 source=1D15BBE5CD14A2C5EE7361C20B8AF36AA660DD96
target=https://knudstrup.org/horde-webmail-1.0/rpc.php user=eknuds
charset=UTF-8 wbxml=1 [on line 226 of
"/home/httpd/https/horde-webmail-1.0/lib/SyncML.php"]
Jul 24 15:11:12 HORDE [debug] [horde] SyncML: looking for sync for
calendar [on line 263 of
"/home/httpd/https/horde-webmail-1.0/lib/SyncML/Command/Alert.php"]
Jul 24 15:11:12 HORDE [debug] [horde] SyncML: Create new sync for
calendar [on line 269 of
"/home/httpd/https/horde-webmail-1.0/lib/SyncML/Command/Alert.php"]
Jul 24 15:11:12 HORDE [debug] [horde] SyncML: create for
syncType=calendar [on line 51 of
"/home/httpd/https/horde-webmail-1.0/lib/SyncML/Sync.php"]
Jul 24 15:11:12 HORDE [debug] [horde] SQL Query by
DataTree_sql::_buildParentIds(): SELECT datatree_id, datatree_parents
FROM horde_datatree WHERE datatree_name = ? AND group_uid = ? ORDER BY
datatree_id [on line 261 of
"/home/httpd/https/horde-webmail-1.0/lib/Horde/DataTree/sql.php"]
Jul 24 15:11:12 HORDE [debug] [horde] SQL Query by
DataTree_sql::_load(): SELECT c.datatree_id, c.datatree_name,
c.datatree_parents, c.datatree_order FROM horde_datatree c WHERE
c.group_uid = 'syncml' AND (c.datatree_parents LIKE ':494:495:523:524%'
OR c.datatree_id = 524 OR c.datatree_id IN (494, 495, 523) OR
c.datatree_parents LIKE ':494:526:708%' OR c.datatree_id = 708 OR
c.datatree_id IN (494, 526) OR c.datatree_parents LIKE
':494:526:691:726%' OR c.datatree_id = 726 OR c.datatree_id IN (494,
526, 691)) [on line 130 of
"/home/httpd/https/horde-webmail-1.0/lib/Horde/DataTree/sql.php"]
Jul 24 15:11:12 HORDE [debug] [horde] SQL Query by
DataTree_sql::getData(): SELECT datatree_data, datatree_serialized FROM
horde_datatree WHERE datatree_id = ? [on line 952 of
"/home/httpd/https/horde-webmail-1.0/lib/Horde/DataTree/sql.php"]
Jul 24 15:11:12 HORDE [debug] [horde] SyncML: previous sync found for
database: calendar; client-ts: 20070520T123103Z [on line 89 of
"/home/httpd/https/horde-webmail-1.0/lib/SyncML/Command/Alert.php"]
Jul 24 15:11:12 HORDE [debug] [horde] SyncML: SyncML: Anchor match,
TwoWaySync since 20070520T123103Z [on line 109 of
"/home/httpd/https/horde-webmail-1.0/lib/SyncML/Command/Alert.php"]
Jul 24 15:11:12 HORDE [debug] [horde] SyncML: looking for sync for
contacts [on line 263 of
"/home/httpd/https/horde-webmail-1.0/lib/SyncML/Command/Alert.php"]
Jul 24 15:11:12 HORDE [debug] [horde] SyncML: Create new sync for
contacts [on line 269 of
"/home/httpd/https/horde-webmail-1.0/lib/SyncML/Command/Alert.php"]
Jul 24 15:11:12 HORDE [debug] [horde] SyncML: create for
syncType=contacts [on line 51 of
"/home/httpd/https/horde-webmail-1.0/lib/SyncML/Sync.php"]
Jul 24 15:11:12 HORDE [debug] [horde] SQL Query by
DataTree_sql::_buildParentIds(): SELECT datatree_id, datatree_parents
FROM horde_datatree WHERE datatree_name = ? AND group_uid = ? ORDER BY
datatree_id [on line 261 of
"/home/httpd/https/horde-webmail-1.0/lib/Horde/DataTree/sql.php"]
Jul 24 15:11:12 HORDE [debug] [horde] SQL Query by
DataTree_sql::_load(): SELECT c.datatree_id, c.datatree_name,
c.datatree_parents, c.datatree_order FROM horde_datatree c WHERE
c.group_uid = 'syncml' AND (c.datatree_parents LIKE ':494:495:496%' OR
c.datatree_id = 496 OR c.datatree_id IN (494, 495) OR c.datatree_parents
LIKE ':494:495:523:522%' OR c.datatree_id = 522 OR c.datatree_id IN
(494, 495, 523) OR c.datatree_parents LIKE ':494:526:527%' OR
c.datatree_id = 527 OR c.datatree_id IN (494, 526) OR c.datatree_parents
LIKE ':494:526:691:690%' OR c.datatree_id = 690 OR c.datatree_id IN
(494, 526, 691)) [on line 130 of
"/home/httpd/https/horde-webmail-1.0/lib/Horde/DataTree/sql.php"]
Jul 24 15:11:12 HORDE [debug] [horde] SQL Query by
DataTree_sql::getData(): SELECT datatree_data, datatree_serialized FROM
horde_datatree WHERE datatree_id = ? [on line 952 of
"/home/httpd/https/horde-webmail-1.0/lib/Horde/DataTree/sql.php"]
Jul 24 15:11:12 HORDE [debug] [horde] SyncML: previous sync found for
database: contacts; client-ts: 20070520T123103Z [on line 89 of
"/home/httpd/https/horde-webmail-1.0/lib/SyncML/Command/Alert.php"]
Jul 24 15:11:12 HORDE [debug] [horde] SyncML: SyncML: Anchor match,
TwoWaySync since 20070520T123103Z [on line 109 of
"/home/httpd/https/horde-webmail-1.0/lib/SyncML/Command/Alert.php"]
Jul 24 15:11:12 HORDE [debug] [horde] SyncML: SyncML: return message
completed [on line 513 of
"/home/httpd/https/horde-webmail-1.0/lib/SyncML.php"]
Jul 24 15:11:15 HORDE [debug] [horde] SyncML: Existing session
continued: syncml1D15BBE5CD14A2C5EE7361C20B8AF36AA660DD9654 [on line 180
of "/home/httpd/https/horde-webmail-1.0/lib/SyncML.php"]
Jul 24 15:11:15 HORDE [debug] [horde] SyncML: authorized=1 version=1
msgid=2 source=1D15BBE5CD14A2C5EE7361C20B8AF36AA660DD96
target=https://knudstrup.org/horde-webmail-1.0/rpc.php user=eknuds
charset=UTF-8 wbxml=1 [on line 226 of
"/home/httpd/https/horde-webmail-1.0/lib/SyncML.php"]
Jul 24 15:11:15 HORDE [debug] [horde] SyncML: handleSync for
syncType=calendar [on line 175 of
"/home/httpd/https/horde-webmail-1.0/lib/SyncML/Sync.php"]
Jul 24 15:11:15 HORDE [debug] [horde] SyncML: Using device class
syncml_device_synthesis [on line 65 of
"/home/httpd/https/horde-webmail-1.0/lib/SyncML/Device.php"]
Jul 24 15:11:15 HORDE [debug] [horde] SQL Query by
Prefs_sql::retrieve(): SELECT pref_scope, pref_name, pref_value FROM
horde_prefs WHERE pref_uid = ? AND (pref_scope = ? OR pref_scope =
'horde') ORDER BY pref_scope [on line 137 of
"/home/httpd/https/horde-webmail-1.0/lib/Horde/Prefs/sql.php"]
Jul 24 15:11:15 HORDE [debug] [kronolith] Hook _horde_hook_share_init in
application horde not called. [on line 1470 of
"/home/httpd/https/horde-webmail-1.0/lib/Horde.php"]
Jul 24 15:11:15 HORDE [debug] [kronolith] SQL Query by
DataTree_sql::getByAttributes(): SELECT c.datatree_id, c.datatree_name
FROM horde_datatree c LEFT JOIN horde_datatree_attributes a1 ON
a1.datatree_id = c.datatree_id WHERE c.group_uid = ? AND
(a1.attribute_name = ? AND a1.attribute_key = ?) GROUP BY
c.datatree_id, c.datatree_name, c.datatree_order ORDER BY
c.datatree_order, c.datatree_name, c.datatree_id [on line 1114 of
"/home/httpd/https/horde-webmail-1.0/lib/Horde/DataTree/sql.php"]
Jul 24 15:11:15 HORDE [debug] [kronolith] SQL Query by
DataTree_sql::getByAttributes(): SELECT c.datatree_id, c.datatree_name
FROM horde_datatree c LEFT JOIN horde_datatree_attributes a1 ON
a1.datatree_id = c.datatree_id WHERE c.group_uid = ? AND
((a1.attribute_name = ? AND a1.attribute_value = ?) OR
(a1.attribute_name = ? AND a1.attribute_key = ? AND a1.attribute_value
\& ?) OR (a1.attribute_name = ? AND a1.attribute_value \& ?) OR
(a1.attribute_name = ? AND a1.attribute_value \& ?)) GROUP BY
c.datatree_id, c.datatree_name, c.datatree_order ORDER BY
c.datatree_order, c.datatree_name, c.datatree_id [on line 1114 of
"/home/httpd/https/horde-webmail-1.0/lib/Horde/DataTree/sql.php"]
Jul 24 15:11:15 HORDE [debug] [kronolith] SQL Query by
DataTree_sql::_loadById(): SELECT datatree_id, datatree_parents FROM
horde_datatree WHERE datatree_id IN (459, 464) AND group_uid =
'horde.shares.kronolith' ORDER BY datatree_id [on line 342 of
"/home/httpd/https/horde-webmail-1.0/lib/Horde/DataTree/sql.php"]
Jul 24 15:11:15 HORDE [debug] [kronolith] SQL Query by
DataTree_sql::_loadById(): SELECT datatree_id, datatree_name,
datatree_parents, datatree_order FROM horde_datatree WHERE datatree_id
IN (?, ?, ?) AND group_uid = ? ORDER BY datatree_id [on line 375 of
"/home/httpd/https/horde-webmail-1.0/lib/Horde/DataTree/sql.php"]
Jul 24 15:11:15 HORDE [debug] [kronolith] SQL Query by
DataTree_sql::getAttributes(): SELECT datatree_id, attribute_name AS
name, attribute_key AS "key", attribute_value AS value FROM
horde_datatree_attributes WHERE datatree_id IN (459, 464) [on line 995
of "/home/httpd/https/horde-webmail-1.0/lib/Horde/DataTree/sql.php"]
Jul 24 15:11:15 HORDE [debug] [horde] SQL Query by
DataTree_sql::_buildParentIds(): SELECT datatree_id, datatree_parents
FROM horde_datatree WHERE datatree_name = ? AND group_uid = ? ORDER BY
datatree_id [on line 261 of
"/home/httpd/https/horde-webmail-1.0/lib/Horde/DataTree/sql.php"]
Jul 24 15:11:15 HORDE [debug] [horde] SQL Query by
DataTree_sql::_load(): SELECT c.datatree_id, c.datatree_name,
c.datatree_parents, c.datatree_order FROM horde_datatree c WHERE
c.group_uid = 'syncml' [on line 130 of
"/home/httpd/https/horde-webmail-1.0/lib/Horde/DataTree/sql.php"]
Jul 24 15:11:15 HORDE [debug] [horde] SQL Query by
DataTree_sql::_buildParentIds(): SELECT datatree_id, datatree_parents
FROM horde_datatree WHERE datatree_name = ? AND group_uid = ? ORDER BY
datatree_id [on line 261 of
"/home/httpd/https/horde-webmail-1.0/lib/Horde/DataTree/sql.php"]
Jul 24 15:11:15 HORDE [debug] [horde] SQL Query by
DataTree_sql::_load(): SELECT c.datatree_id, c.datatree_name,
c.datatree_parents, c.datatree_order FROM horde_datatree c WHERE
c.group_uid = 'syncml' [on line 130 of
"/home/httpd/https/horde-webmail-1.0/lib/Horde/DataTree/sql.php"]
Jul 24 15:11:15 HORDE [warning] [horde] SyncML: Unable to create delete
for 20070628202715.5id8zhwszzsw at www.knudstrup.org: locid not found in
map [on line 192 of
"/home/httpd/https/horde-webmail-1.0/lib/SyncML/Backend.php"]
Jul 24 15:11:15 HORDE [debug] [horde] SyncML: add modifications
retrieved. count=10 [on line 234 of
"/home/httpd/https/horde-webmail-1.0/lib/SyncML/Backend.php"]
Jul 24 15:11:15 HORDE [debug] [horde] SQL Query by
DataTree_sql::_buildParentIds(): SELECT datatree_id, datatree_parents
FROM horde_datatree WHERE datatree_name = ? AND group_uid = ? ORDER BY
datatree_id [on line 261 of
"/home/httpd/https/horde-webmail-1.0/lib/Horde/DataTree/sql.php"]
Jul 24 15:11:15 HORDE [debug] [horde] SQL Query by
DataTree_sql::_load(): SELECT c.datatree_id, c.datatree_name,
c.datatree_parents, c.datatree_order FROM horde_datatree c WHERE
c.group_uid = 'syncml' [on line 130 of
"/home/httpd/https/horde-webmail-1.0/lib/Horde/DataTree/sql.php"]
Jul 24 15:11:16 HORDE [debug] [horde] SQL Query by
DataTree_sql::_buildParentIds(): SELECT datatree_id, datatree_parents
FROM horde_datatree WHERE datatree_name = ? AND group_uid = ? ORDER BY
datatree_id [on line 261 of
"/home/httpd/https/horde-webmail-1.0/lib/Horde/DataTree/sql.php"]
Jul 24 15:11:16 HORDE [debug] [horde] SQL Query by
DataTree_sql::_load(): SELECT c.datatree_id, c.datatree_name,
c.datatree_parents, c.datatree_order FROM horde_datatree c WHERE
c.group_uid = 'syncml' [on line 130 of
"/home/httpd/https/horde-webmail-1.0/lib/Horde/DataTree/sql.php"]
Jul 24 15:11:16 HORDE [debug] [horde] SQL Query by
DataTree_sql::_buildParentIds(): SELECT datatree_id, datatree_parents
FROM horde_datatree WHERE datatree_name = ? AND group_uid = ? ORDER BY
datatree_id [on line 261 of
"/home/httpd/https/horde-webmail-1.0/lib/Horde/DataTree/sql.php"]
Jul 24 15:11:16 HORDE [debug] [horde] SQL Query by
DataTree_sql::_load(): SELECT c.datatree_id, c.datatree_name,
c.datatree_parents, c.datatree_order FROM horde_datatree c WHERE
c.group_uid = 'syncml' [on line 130 of
"/home/httpd/https/horde-webmail-1.0/lib/Horde/DataTree/sql.php"]
Jul 24 15:11:16 HORDE [debug] [horde] SQL Query by
DataTree_sql::_buildParentIds(): SELECT datatree_id, datatree_parents
FROM horde_datatree WHERE datatree_name = ? AND group_uid = ? ORDER BY
datatree_id [on line 261 of
"/home/httpd/https/horde-webmail-1.0/lib/Horde/DataTree/sql.php"]
Jul 24 15:11:16 HORDE [debug] [horde] SQL Query by
DataTree_sql::_load(): SELECT c.datatree_id, c.datatree_name,
c.datatree_parents, c.datatree_order FROM horde_datatree c WHERE
c.group_uid = 'syncml' [on line 130 of
"/home/httpd/https/horde-webmail-1.0/lib/Horde/DataTree/sql.php"]
Jul 24 15:11:16 HORDE [debug] [horde] SQL Query by
DataTree_sql::_buildParentIds(): SELECT datatree_id, datatree_parents
FROM horde_datatree WHERE datatree_name = ? AND group_uid = ? ORDER BY
datatree_id [on line 261 of
"/home/httpd/https/horde-webmail-1.0/lib/Horde/DataTree/sql.php"]
Jul 24 15:11:16 HORDE [debug] [horde] SQL Query by
DataTree_sql::_load(): SELECT c.datatree_id, c.datatree_name,
c.datatree_parents, c.datatree_order FROM horde_datatree c WHERE
c.group_uid = 'syncml' [on line 130 of
"/home/httpd/https/horde-webmail-1.0/lib/Horde/DataTree/sql.php"]
Jul 24 15:11:16 HORDE [debug] [horde] SQL Query by
DataTree_sql::_buildParentIds(): SELECT datatree_id, datatree_parents
FROM horde_datatree WHERE datatree_name = ? AND group_uid = ? ORDER BY
datatree_id [on line 261 of
"/home/httpd/https/horde-webmail-1.0/lib/Horde/DataTree/sql.php"]
Jul 24 15:11:16 HORDE [debug] [horde] SQL Query by
DataTree_sql::_load(): SELECT c.datatree_id, c.datatree_name,
c.datatree_parents, c.datatree_order FROM horde_datatree c WHERE
c.group_uid = 'syncml' [on line 130 of
"/home/httpd/https/horde-webmail-1.0/lib/Horde/DataTree/sql.php"]
Jul 24 15:11:16 HORDE [debug] [horde] SQL Query by
DataTree_sql::_buildParentIds(): SELECT datatree_id, datatree_parents
FROM horde_datatree WHERE datatree_name = ? AND group_uid = ? ORDER BY
datatree_id [on line 261 of
"/home/httpd/https/horde-webmail-1.0/lib/Horde/DataTree/sql.php"]
Jul 24 15:11:16 HORDE [debug] [horde] SQL Query by
DataTree_sql::_load(): SELECT c.datatree_id, c.datatree_name,
c.datatree_parents, c.datatree_order FROM horde_datatree c WHERE
c.group_uid = 'syncml' [on line 130 of
"/home/httpd/https/horde-webmail-1.0/lib/Horde/DataTree/sql.php"]
Jul 24 15:11:16 HORDE [debug] [horde] SQL Query by
DataTree_sql::_buildParentIds(): SELECT datatree_id, datatree_parents
FROM horde_datatree WHERE datatree_name = ? AND group_uid = ? ORDER BY
datatree_id [on line 261 of
"/home/httpd/https/horde-webmail-1.0/lib/Horde/DataTree/sql.php"]
Jul 24 15:11:16 HORDE [debug] [horde] SQL Query by
DataTree_sql::_load(): SELECT c.datatree_id, c.datatree_name,
c.datatree_parents, c.datatree_order FROM horde_datatree c WHERE
c.group_uid = 'syncml' [on line 130 of
"/home/httpd/https/horde-webmail-1.0/lib/Horde/DataTree/sql.php"]
Jul 24 15:11:16 HORDE [debug] [horde] SQL Query by
DataTree_sql::_buildParentIds(): SELECT datatree_id, datatree_parents
FROM horde_datatree WHERE datatree_name = ? AND group_uid = ? ORDER BY
datatree_id [on line 261 of
"/home/httpd/https/horde-webmail-1.0/lib/Horde/DataTree/sql.php"]
Jul 24 15:11:16 HORDE [debug] [horde] SQL Query by
DataTree_sql::_load(): SELECT c.datatree_id, c.datatree_name,
c.datatree_parents, c.datatree_order FROM horde_datatree c WHERE
c.group_uid = 'syncml' [on line 130 of
"/home/httpd/https/horde-webmail-1.0/lib/Horde/DataTree/sql.php"]
Jul 24 15:11:16 HORDE [debug] [horde] SQL Query by
DataTree_sql::_buildParentIds(): SELECT datatree_id, datatree_parents
FROM horde_datatree WHERE datatree_name = ? AND group_uid = ? ORDER BY
datatree_id [on line 261 of
"/home/httpd/https/horde-webmail-1.0/lib/Horde/DataTree/sql.php"]
Jul 24 15:11:16 HORDE [debug] [horde] SQL Query by
DataTree_sql::_load(): SELECT c.datatree_id, c.datatree_name,
c.datatree_parents, c.datatree_order FROM horde_datatree c WHERE
c.group_uid = 'syncml' [on line 130 of
"/home/httpd/https/horde-webmail-1.0/lib/Horde/DataTree/sql.php"]
Jul 24 15:11:16 HORDE [debug] [horde] SQL Query by
DataTree_sql::_buildParentIds(): SELECT datatree_id, datatree_parents
FROM horde_datatree WHERE datatree_name = ? AND group_uid = ? ORDER BY
datatree_id [on line 261 of
"/home/httpd/https/horde-webmail-1.0/lib/Horde/DataTree/sql.php"]
Jul 24 15:11:16 HORDE [debug] [horde] SQL Query by
DataTree_sql::_load(): SELECT c.datatree_id, c.datatree_name,
c.datatree_parents, c.datatree_order FROM horde_datatree c WHERE
c.group_uid = 'syncml' [on line 130 of
"/home/httpd/https/horde-webmail-1.0/lib/Horde/DataTree/sql.php"]
Jul 24 15:11:16 HORDE [debug] [horde] SQL Query by
DataTree_sql::_buildParentIds(): SELECT datatree_id, datatree_parents
FROM horde_datatree WHERE datatree_name = ? AND group_uid = ? ORDER BY
datatree_id [on line 261 of
"/home/httpd/https/horde-webmail-1.0/lib/Horde/DataTree/sql.php"]
Jul 24 15:11:16 HORDE [debug] [horde] SQL Query by
DataTree_sql::_load(): SELECT c.datatree_id, c.datatree_name,
c.datatree_parents, c.datatree_order FROM horde_datatree c WHERE
c.group_uid = 'syncml' [on line 130 of
"/home/httpd/https/horde-webmail-1.0/lib/Horde/DataTree/sql.php"]
Jul 24 15:11:16 HORDE [debug] [horde] SQL Query by
DataTree_sql::_buildParentIds(): SELECT datatree_id, datatree_parents
FROM horde_datatree WHERE datatree_name = ? AND group_uid = ? ORDER BY
datatree_id [on line 261 of
"/home/httpd/https/horde-webmail-1.0/lib/Horde/DataTree/sql.php"]
Jul 24 15:11:16 HORDE [debug] [horde] SQL Query by
DataTree_sql::_load(): SELECT c.datatree_id, c.datatree_name,
c.datatree_parents, c.datatree_order FROM horde_datatree c WHERE
c.group_uid = 'syncml' [on line 130 of
"/home/httpd/https/horde-webmail-1.0/lib/Horde/DataTree/sql.php"]
Jul 24 15:11:16 HORDE [debug] [horde] SQL Query by
DataTree_sql::_buildParentIds(): SELECT datatree_id, datatree_parents
FROM horde_datatree WHERE datatree_name = ? AND group_uid = ? ORDER BY
datatree_id [on line 261 of
"/home/httpd/https/horde-webmail-1.0/lib/Horde/DataTree/sql.php"]
Jul 24 15:11:16 HORDE [debug] [horde] SQL Query by
DataTree_sql::_load(): SELECT c.datatree_id, c.datatree_name,
c.datatree_parents, c.datatree_order FROM horde_datatree c WHERE
c.group_uid = 'syncml' [on line 130 of
"/home/httpd/https/horde-webmail-1.0/lib/Horde/DataTree/sql.php"]
Jul 24 15:11:16 HORDE [debug] [horde] SQL Query by
DataTree_sql::_buildParentIds(): SELECT datatree_id, datatree_parents
FROM horde_datatree WHERE datatree_name = ? AND group_uid = ? ORDER BY
datatree_id [on line 261 of
"/home/httpd/https/horde-webmail-1.0/lib/Horde/DataTree/sql.php"]
Jul 24 15:11:16 HORDE [debug] [horde] SQL Query by
DataTree_sql::_load(): SELECT c.datatree_id, c.datatree_name,
c.datatree_parents, c.datatree_order FROM horde_datatree c WHERE
c.group_uid = 'syncml' [on line 130 of
"/home/httpd/https/horde-webmail-1.0/lib/Horde/DataTree/sql.php"]
Jul 24 15:11:16 HORDE [debug] [horde] SQL Query by
DataTree_sql::_buildParentIds(): SELECT datatree_id, datatree_parents
FROM horde_datatree WHERE datatree_name = ? AND group_uid = ? ORDER BY
datatree_id [on line 261 of
"/home/httpd/https/horde-webmail-1.0/lib/Horde/DataTree/sql.php"]
Jul 24 15:11:16 HORDE [debug] [horde] SQL Query by
DataTree_sql::_load(): SELECT c.datatree_id, c.datatree_name,
c.datatree_parents, c.datatree_order FROM horde_datatree c WHERE
c.group_uid = 'syncml' [on line 130 of
"/home/httpd/https/horde-webmail-1.0/lib/Horde/DataTree/sql.php"]
Jul 24 15:11:16 HORDE [debug] [horde] SQL Query by
DataTree_sql::_buildParentIds(): SELECT datatree_id, datatree_parents
FROM horde_datatree WHERE datatree_name = ? AND group_uid = ? ORDER BY
datatree_id [on line 261 of
"/home/httpd/https/horde-webmail-1.0/lib/Horde/DataTree/sql.php"]
Jul 24 15:11:16 HORDE [debug] [horde] SQL Query by
DataTree_sql::_load(): SELECT c.datatree_id, c.datatree_name,
c.datatree_parents, c.datatree_order FROM horde_datatree c WHERE
c.group_uid = 'syncml' [on line 130 of
"/home/httpd/https/horde-webmail-1.0/lib/Horde/DataTree/sql.php"]
Jul 24 15:11:16 HORDE [debug] [horde] SQL Query by
DataTree_sql::_buildParentIds(): SELECT datatree_id, datatree_parents
FROM horde_datatree WHERE datatree_name = ? AND group_uid = ? ORDER BY
datatree_id [on line 261 of
"/home/httpd/https/horde-webmail-1.0/lib/Horde/DataTree/sql.php"]
Jul 24 15:11:16 HORDE [debug] [horde] SQL Query by
DataTree_sql::_load(): SELECT c.datatree_id, c.datatree_name,
c.datatree_parents, c.datatree_order FROM horde_datatree c WHERE
c.group_uid = 'syncml' [on line 130 of
"/home/httpd/https/horde-webmail-1.0/lib/Horde/DataTree/sql.php"]
Jul 24 15:11:17 HORDE [debug] [horde] SyncML: add:
20070722081357.5o16f7yo190c at www.knudstrup.org [on line 232 of
"/home/httpd/https/horde-webmail-1.0/lib/SyncML/Sync.php"]
Jul 24 15:11:17 HORDE [debug] [kronolith] SQL event fetch by eknuds:
query = "SELECT event_id, event_uid, calendar_id, event_description,
event_location, event_status, event_attendees, event_keywords,
event_title, event_category, 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 event_uid = ?" [on line 395 of
"/home/httpd/https/horde-webmail-1.0/kronolith/lib/Driver/sql.php"]
Jul 24 15:11:17 HORDE [debug] [kronolith] SQL Query by
DataTree_sql::getByAttributes(): SELECT c.datatree_id, c.datatree_name
FROM horde_datatree c LEFT JOIN horde_datatree_attributes a1 ON
a1.datatree_id = c.datatree_id WHERE c.group_uid = ? AND
(a1.attribute_name = ? AND a1.attribute_key = ?) GROUP BY
c.datatree_id, c.datatree_name, c.datatree_order ORDER BY
c.datatree_order, c.datatree_name, c.datatree_id [on line 1114 of
"/home/httpd/https/horde-webmail-1.0/lib/Horde/DataTree/sql.php"]
Jul 24 15:11:17 HORDE [debug] [kronolith] SQL Query by
DataTree_sql::getByAttributes(): SELECT c.datatree_id, c.datatree_name
FROM horde_datatree c LEFT JOIN horde_datatree_attributes a1 ON
a1.datatree_id = c.datatree_id LEFT JOIN horde_datatree_attributes a2 ON
a2.datatree_id = c.datatree_id WHERE c.group_uid = ? AND
(((a1.attribute_name = ? AND a1.attribute_value = ?) OR
(a1.attribute_name = ? AND a1.attribute_key = ? AND a1.attribute_value
\& ?) OR (a1.attribute_name = ? AND a1.attribute_value \& ?) OR
(a1.attribute_name = ? AND a1.attribute_value \& ?)) AND
a2.attribute_name = ? AND a2.attribute_value = ?) AND a1.datatree_id =
a2.datatree_id GROUP BY c.datatree_id, c.datatree_name, c.datatree_order
ORDER BY c.datatree_order, c.datatree_name, c.datatree_id [on line 1114
of "/home/httpd/https/horde-webmail-1.0/lib/Horde/DataTree/sql.php"]
Jul 24 15:11:17 HORDE [debug] [kronolith] SQL Query by
DataTree_sql::getAttributes(): SELECT datatree_id, attribute_name AS
name, attribute_key AS "key", attribute_value AS value FROM
horde_datatree_attributes WHERE datatree_id IN (459) [on line 995 of
"/home/httpd/https/horde-webmail-1.0/lib/Horde/DataTree/sql.php"]
Jul 24 15:11:17 HORDE [debug] [kronolith] SQL Query by
DataTree_sql::getByAttributes(): SELECT c.datatree_id, c.datatree_name
FROM horde_datatree c LEFT JOIN horde_datatree_attributes a1 ON
a1.datatree_id = c.datatree_id WHERE c.group_uid = ? AND
(a1.attribute_name = ? AND a1.attribute_key = ?) GROUP BY
c.datatree_id, c.datatree_name, c.datatree_order ORDER BY
c.datatree_order, c.datatree_name, c.datatree_id [on line 1114 of
"/home/httpd/https/horde-webmail-1.0/lib/Horde/DataTree/sql.php"]
Jul 24 15:11:17 HORDE [debug] [kronolith] SQL Query by
DataTree_sql::getByAttributes(): SELECT c.datatree_id, c.datatree_name
FROM horde_datatree c LEFT JOIN horde_datatree_attributes a1 ON
a1.datatree_id = c.datatree_id WHERE c.group_uid = ? AND
((a1.attribute_name = ? AND a1.attribute_value = ?) OR
(a1.attribute_name = ? AND a1.attribute_key = ? AND a1.attribute_value
\& ?) OR (a1.attribute_name = ? AND a1.attribute_value \& ?) OR
(a1.attribute_name = ? AND a1.attribute_value \& ?)) GROUP BY
c.datatree_id, c.datatree_name, c.datatree_order ORDER BY
c.datatree_order, c.datatree_name, c.datatree_id [on line 1114 of
"/home/httpd/https/horde-webmail-1.0/lib/Horde/DataTree/sql.php"]
Jul 24 15:11:17 HORDE [debug] [kronolith] SQL Query by
DataTree_sql::getAttributes(): SELECT datatree_id, attribute_name AS
name, attribute_key AS "key", attribute_value AS value FROM
horde_datatree_attributes WHERE datatree_id IN (459, 464) [on line 995
of "/home/httpd/https/horde-webmail-1.0/lib/Horde/DataTree/sql.php"]
Jul 24 15:11:17 HORDE [debug] [horde] SyncML: add:
20070723010603.1638e0e50zmo at www.knudstrup.org [on line 232 of
"/home/httpd/https/horde-webmail-1.0/lib/SyncML/Sync.php"]
Jul 24 15:11:17 HORDE [debug] [kronolith] SQL event fetch by eknuds:
query = "SELECT event_id, event_uid, calendar_id, event_description,
event_location, event_status, event_attendees, event_keywords,
event_title, event_category, 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 event_uid = ?" [on line 395 of
"/home/httpd/https/horde-webmail-1.0/kronolith/lib/Driver/sql.php"]
Jul 24 15:11:17 HORDE [debug] [horde] SyncML: add:
20070722085534.2hrg87l6696o at www.knudstrup.org [on line 232 of
"/home/httpd/https/horde-webmail-1.0/lib/SyncML/Sync.php"]
Jul 24 15:11:17 HORDE [debug] [kronolith] SQL event fetch by eknuds:
query = "SELECT event_id, event_uid, calendar_id, event_description,
event_location, event_status, event_attendees, event_keywords,
event_title, event_category, 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 event_uid = ?" [on line 395 of
"/home/httpd/https/horde-webmail-1.0/kronolith/lib/Driver/sql.php"]
Jul 24 15:11:17 HORDE [debug] [horde] SyncML: add:
20070612003414.2948u3mqu2zo at www.knudstrup.org [on line 232 of
"/home/httpd/https/horde-webmail-1.0/lib/SyncML/Sync.php"]
Jul 24 15:11:17 HORDE [debug] [kronolith] SQL event fetch by eknuds:
query = "SELECT event_id, event_uid, calendar_id, event_description,
event_location, event_status, event_attendees, event_keywords,
event_title, event_category, 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 event_uid = ?" [on line 395 of
"/home/httpd/https/horde-webmail-1.0/kronolith/lib/Driver/sql.php"]
Jul 24 15:11:17 HORDE [debug] [horde] SyncML: add:
20070611131348.7d58xridwysk at www.knudstrup.org [on line 232 of
"/home/httpd/https/horde-webmail-1.0/lib/SyncML/Sync.php"]
Jul 24 15:11:17 HORDE [debug] [kronolith] SQL event fetch by eknuds:
query = "SELECT event_id, event_uid, calendar_id, event_description,
event_location, event_status, event_attendees, event_keywords,
event_title, event_category, 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 event_uid = ?" [on line 395 of
"/home/httpd/https/horde-webmail-1.0/kronolith/lib/Driver/sql.php"]
Jul 24 15:11:17 HORDE [debug] [horde] SyncML: add:
20070606133524.3m4qn5xk0zac at www.knudstrup.org [on line 232 of
"/home/httpd/https/horde-webmail-1.0/lib/SyncML/Sync.php"]
Jul 24 15:11:17 HORDE [debug] [kronolith] SQL event fetch by eknuds:
query = "SELECT event_id, event_uid, calendar_id, event_description,
event_location, event_status, event_attendees, event_keywords,
event_title, event_category, 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 event_uid = ?" [on line 395 of
"/home/httpd/https/horde-webmail-1.0/kronolith/lib/Driver/sql.php"]
Jul 24 15:11:17 HORDE [debug] [horde] SyncML: add:
20070607191136.2qtytkog8eec at www.knudstrup.org [on line 232 of
"/home/httpd/https/horde-webmail-1.0/lib/SyncML/Sync.php"]
Jul 24 15:11:17 HORDE [debug] [kronolith] SQL event fetch by eknuds:
query = "SELECT event_id, event_uid, calendar_id, event_description,
event_location, event_status, event_attendees, event_keywords,
event_title, event_category, 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 event_uid = ?" [on line 395 of
"/home/httpd/https/horde-webmail-1.0/kronolith/lib/Driver/sql.php"]
Jul 24 15:11:17 HORDE [debug] [horde] SyncML: add:
20070628202715.5id8zhwszzsw at www.knudstrup.org [on line 232 of
"/home/httpd/https/horde-webmail-1.0/lib/SyncML/Sync.php"]
Jul 24 15:11:17 HORDE [debug] [kronolith] SQL event fetch by eknuds:
query = "SELECT event_id, event_uid, calendar_id, event_description,
event_location, event_status, event_attendees, event_keywords,
event_title, event_category, 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 event_uid = ?" [on line 395 of
"/home/httpd/https/horde-webmail-1.0/kronolith/lib/Driver/sql.php"]
Jul 24 15:11:17 HORDE [debug] [horde] SyncML: api export call for
20070628202715.5id8zhwszzsw at www.knudstrup.org failed:
20070628202715.5id8zhwszzsw at www.knudstrup.org not found [on line 260 of
"/home/httpd/https/horde-webmail-1.0/lib/SyncML/Sync.php"]
Jul 24 15:11:17 HORDE [debug] [horde] SyncML: add:
20070629002246.57chydut9aos at www.knudstrup.org [on line 232 of
"/home/httpd/https/horde-webmail-1.0/lib/SyncML/Sync.php"]
Jul 24 15:11:17 HORDE [debug] [kronolith] SQL event fetch by eknuds:
query = "SELECT event_id, event_uid, calendar_id, event_description,
event_location, event_status, event_attendees, event_keywords,
event_title, event_category, 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 event_uid = ?" [on line 395 of
"/home/httpd/https/horde-webmail-1.0/kronolith/lib/Driver/sql.php"]
Jul 24 15:11:17 HORDE [debug] [horde] SyncML: add:
20070710055756.3zq343y5fayo at www.knudstrup.org [on line 232 of
"/home/httpd/https/horde-webmail-1.0/lib/SyncML/Sync.php"]
Jul 24 15:11:17 HORDE [debug] [kronolith] SQL event fetch by eknuds:
query = "SELECT event_id, event_uid, calendar_id, event_description,
event_location, event_status, event_attendees, event_keywords,
event_title, event_category, 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 event_uid = ?" [on line 395 of
"/home/httpd/https/horde-webmail-1.0/kronolith/lib/Driver/sql.php"]
Jul 24 15:11:17 HORDE [warning] [horde] SyncML: Unable to create change
for 20070611131348.7d58xridwysk at www.knudstrup.org: client-id not found
in map. Trying add instead. [on line 137 of
"/home/httpd/https/horde-webmail-1.0/lib/SyncML/Backend.php"]
Jul 24 15:11:17 HORDE [warning] [horde] SyncML: Unable to create change
for 20070606133524.3m4qn5xk0zac at www.knudstrup.org: client-id not found
in map. Trying add instead. [on line 137 of
"/home/httpd/https/horde-webmail-1.0/lib/SyncML/Backend.php"]
Jul 24 15:11:17 HORDE [warning] [horde] SyncML: Unable to create change
for 20070629002246.57chydut9aos at www.knudstrup.org: client-id not found
in map. Trying add instead. [on line 137 of
"/home/httpd/https/horde-webmail-1.0/lib/SyncML/Backend.php"]
Jul 24 15:11:17 HORDE [debug] [horde] SyncML: handleSync for
syncType=contacts [on line 175 of
"/home/httpd/https/horde-webmail-1.0/lib/SyncML/Sync.php"]
Jul 24 15:11:17 HORDE [debug] [horde] SQL Query by
Prefs_sql::retrieve(): SELECT pref_scope, pref_name, pref_value FROM
horde_prefs WHERE pref_uid = ? AND (pref_scope = ? OR pref_scope =
'horde') ORDER BY pref_scope [on line 137 of
"/home/httpd/https/horde-webmail-1.0/lib/Horde/Prefs/sql.php"]
Jul 24 15:11:17 HORDE [debug] [turba] Hook _horde_hook_share_init in
application horde not called. [on line 1470 of
"/home/httpd/https/horde-webmail-1.0/lib/Horde.php"]
Jul 24 15:11:17 HORDE [debug] [turba] SQL Query by
DataTree_sql::getByAttributes(): SELECT c.datatree_id, c.datatree_name
FROM horde_datatree c LEFT JOIN horde_datatree_attributes a1 ON
a1.datatree_id = c.datatree_id WHERE c.group_uid = ? AND
(a1.attribute_name = ? AND a1.attribute_key = ?) GROUP BY
c.datatree_id, c.datatree_name, c.datatree_order ORDER BY
c.datatree_order, c.datatree_name, c.datatree_id [on line 1114 of
"/home/httpd/https/horde-webmail-1.0/lib/Horde/DataTree/sql.php"]
Jul 24 15:11:17 HORDE [debug] [turba] SQL Query by
DataTree_sql::getByAttributes(): SELECT c.datatree_id, c.datatree_name
FROM horde_datatree c LEFT JOIN horde_datatree_attributes a1 ON
a1.datatree_id = c.datatree_id WHERE c.group_uid = ? AND
((a1.attribute_name = ? AND a1.attribute_value = ?) OR
(a1.attribute_name = ? AND a1.attribute_key = ? AND a1.attribute_value
\& ?) OR (a1.attribute_name = ? AND a1.attribute_value \& ?) OR
(a1.attribute_name = ? AND a1.attribute_value \& ?)) GROUP BY
c.datatree_id, c.datatree_name, c.datatree_order ORDER BY
c.datatree_order, c.datatree_name, c.datatree_id [on line 1114 of
"/home/httpd/https/horde-webmail-1.0/lib/Horde/DataTree/sql.php"]
Jul 24 15:11:17 HORDE [debug] [turba] SQL Query by
DataTree_sql::_loadById(): SELECT datatree_id, datatree_parents FROM
horde_datatree WHERE datatree_id IN (456) AND group_uid =
'horde.shares.turba' ORDER BY datatree_id [on line 342 of
"/home/httpd/https/horde-webmail-1.0/lib/Horde/DataTree/sql.php"]
Jul 24 15:11:17 HORDE [debug] [turba] SQL Query by
DataTree_sql::_loadById(): SELECT datatree_id, datatree_name,
datatree_parents, datatree_order FROM horde_datatree WHERE datatree_id
IN (?, ?) AND group_uid = ? ORDER BY datatree_id [on line 375 of
"/home/httpd/https/horde-webmail-1.0/lib/Horde/DataTree/sql.php"]
Jul 24 15:11:17 HORDE [debug] [turba] SQL Query by
DataTree_sql::getAttributes(): SELECT datatree_id, attribute_name AS
name, attribute_key AS "key", attribute_value AS value FROM
horde_datatree_attributes WHERE datatree_id IN (456) [on line 995 of
"/home/httpd/https/horde-webmail-1.0/lib/Horde/DataTree/sql.php"]
Jul 24 15:11:17 HORDE [debug] [horde] SyncML: add modifications
retrieved. count=0 [on line 234 of
"/home/httpd/https/horde-webmail-1.0/lib/SyncML/Backend.php"]
Jul 24 15:11:17 HORDE [debug] [horde] SQL Query by
DataTree_sql::getData(): SELECT datatree_data, datatree_serialized FROM
horde_datatree WHERE datatree_id = ? [on line 952 of
"/home/httpd/https/horde-webmail-1.0/lib/Horde/DataTree/sql.php"]
Jul 24 15:11:17 HORDE [debug] [turba] SQL query by
Turba_Driver_sql::_search(): SELECT object_id, owner_id, object_type,
object_members, object_uid, object_name, object_email, object_alias,
object_homeaddress, object_workaddress, object_homephone,
object_workphone, object_cellphone, object_fax, object_title,
object_company, object_notes, object_pgppublickey,
object_smimepublickey, object_freebusyurl FROM turba_objects WHERE
(owner_id = ? AND (LOWER(object_uid) LIKE LOWER(?))) [on line 126 of
"/home/httpd/https/horde-webmail-1.0/turba/lib/Driver/sql.php"]
More information about the kronolith
mailing list