[sync] Re: Problem with DB PostgreSQL

[Marc Hauswirth]

Chuck Hagenbuch wrote:

>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
>  
>
Sorry, on the latest CVS version of all the horde framework and kronolith,
PHP 4.3.9
Pear extensions : stable
Pear DB 1.7.6   stable

And PostgreSQL 7.2.1 (on Linux / Debian Woody)

Marc