[sync] Re: syncml and p910i

Tim Nijenbrink horde at magni.nl
Thu Mar 17 04:11:20 PST 2005 

Quoting Jan Schneider <jan at horde.org>:

> Zitat von Tim Nijenbrink <horde at magni.nl>:
>
>> While syncing the addressbook of my newly cvs updated horde with my p910i
>> through rpc.php I only seem to be able to sync items from the phone to the
>> server not the other way around.
>>
>> The following error is written to the log:
>> ------------------
>> Mar 17 10:57:56 HORDE [error] [nag] DB Error: mismatch [on line 1101 of
>> "/usr/share/pear/Horde/DataTree/sql.php"]
>> Mar 17 10:57:56 HORDE [error] [horde] DB Error: mismatch [on line 54 of
>> "/usr/share/pear/Horde/SyncML/Sync/TwoWaySync.php"]
>> ----------------
>
> Turn on debug logging and post the sql query right before the error
> log. And make sure that you checkout is up to date, a related bug has
> been fixed yesterday.
>
> Jan.
>
> --
> Do you need professional PHP or Horde consulting?
> http://horde.org/consulting/
> --
> sync mailing list - Join the hunt: http://horde.org/bounties/#sync
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: sync-unsubscribe at lists.horde.org
>
>

Jan,

cvs is up-to-date, turning debugging on gives me the following sql 
-queries right before the error:
---------- debug log --------------
Mar 17 12:51:52 HORDE [debug] [horde] SQL Query by 
Prefs_sql::retrieve(): SELECT pref_scope, pref_name, pref_value FROM 
horde_prefs WHERE pref_uid = 'tim at tiserver.ath.cx' AND (pref_scope = 
'nag' OR pref_scope = 'horde') ORDER BY pref_scope [on line 147 of 
"/usr/share/pear/Horde/Prefs/sql.php"]
Mar 17 12:51:53 HORDE [debug] [nag] 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 1093 of 
"/usr/share/pear/Horde/DataTree/sql.php"]
Mar 17 12:51:53 HORDE [debug] [nag] 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 1093 of "/usr/share/pear/Horde/DataTree/sql.php"]
Mar 17 12:51:53 HORDE [debug] [nag] SQL Query by 
DataTree_sql::_loadById(): SELECT datatree_id, datatree_parents FROM 
horde_datatree WHERE datatree_id IN (8) AND group_uid = 
'horde.shares.nag' ORDER BY datatree_id [on line 301 of 
"/usr/share/pear/Horde/DataTree/sql.php"]
Mar 17 12:51:53 HORDE [debug] [nag] SQL Query by 
DataTree_sql::_loadById(): SELECT datatree_id, datatree_name, 
datatree_parents, datatree_order FROM horde_datatree WHERE datatree_id 
IN (8, 0) AND group_uid = 'horde.shares.nag' ORDER BY datatree_id [on 
line 332 of "/usr/share/pear/Horde/DataTree/sql.php"]
Mar 17 12:51:53 HORDE [debug] [nag] 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 (8) [on line 992 of 
"/usr/share/pear/Horde/DataTree/sql.php"]
Mar 17 12:51:53 HORDE [debug] [nag] 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 1093 of 
"/usr/share/pear/Horde/DataTree/sql.php"]
Mar 17 12:51:53 HORDE [debug] [nag] 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 1093 of 
"/usr/share/pear/Horde/DataTree/sql.php"]
Mar 17 12:51:53 HORDE [debug] [nag] 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 (8) [on line 992 of 
"/usr/share/pear/Horde/DataTree/sql.php"]
Mar 17 12:51:53 HORDE [debug] [nag] 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 1093 of 
"/usr/share/pear/Horde/DataTree/sql.php"]
Mar 17 12:51:53 HORDE [debug] [nag] 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 1093 of 
"/usr/share/pear/Horde/DataTree/sql.php"]
Mar 17 12:51:53 HORDE [debug] [nag] 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 (8) [on line 992 of 
"/usr/share/pear/Horde/DataTree/sql.php"]
Mar 17 12:51:53 HORDE [debug] [nag] 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 1093 of 
"/usr/share/pear/Horde/DataTree/sql.php"]
Mar 17 12:51:53 HORDE [debug] [nag] 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 1093 of "/usr/share/pear/Horde/DataTree/sql.php"]
Mar 17 12:51:53 HORDE [debug] [nag] 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 (8) [on line 992 of 
"/usr/share/pear/Horde/DataTree/sql.php"]
Mar 17 12:51:53 HORDE [debug] [nag] SQL Query by 
DataTree_sql::_buildParentIds(): SELECT datatree_id, datatree_parents 
FROM horde_datatree WHERE datatree_name = 'nag' AND group_uid = 
'horde.history' ORDER BY datatree_id [on line 221 of 
"/usr/share/pear/Horde/DataTree/sql.php"]
Mar 17 12:51:53 HORDE [debug] [nag] SQL Query by DataTree_sql::_load(): 
SELECT datatree_id, datatree_name, datatree_parents, datatree_order 
FROM horde_datatree WHERE group_uid = 'horde.history' AND () [on line 
113 of "/usr/share/pear/Horde/DataTree/sql.php"]
Mar 17 12:51:53 HORDE [debug] [nag] SQL Query by 
DataTree_sql::getByAttributes():  [on line 1093 of 
"/usr/share/pear/Horde/DataTree/sql.php"]
---------------


Tim

----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.

More information about the sync mailing list