[sync] Problem with DB PostgreSQL

Marc Hauswirth marc at practeo.ch
Mon Apr 18 05:14:48 PDT 2005


Hello,

Trying to sync kronolith and a Sony-Ericsson phone via SyncML, it was OK 
in the direction phone->horde, but not horde->phone (on the calendar part).

I get the following error :

Apr 18 13:36:42 HORDE [error] [kronolith] DB Error: unknown error: 
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 = 'horde.history' AND (a1.attribute_key = 'ts' AND 
a1.attribute_value > 1113823972 AND a2.attribute_key = 'action' AND 
a2.attribute_value = 'modify') AND (datatree_parents = ':23' OR 
datatree_parents LIKE ':23:%') AND a1.attribute_name = a2.attribute_name 
GROUP BY c.datatree_id, c.datatree_name, c.datatree_order ORDER BY 
c.datatree_order, c.datatree_name, c.datatree_id [nativecode=ERROR: 
Unable to identify an operator '>' for types 'text' and 'integer'

Any hints about how to solve this issue ?

Regards,

Marc Hauswirth


More information about the sync mailing list