[sync] Re: Problem with DB PostgreSQL

[Chuck Hagenbuch]

Quoting Marc Hauswirth <marc at practeo.ch>:

> 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 ?

What version of Horde/framework/etc. are you using?

-chuck

-- 
"But she goes not abroad in search of monsters to destroy." - John 
Quincy Adams