[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