[sync] Re: Problem with DB PostgreSQL

[Chuck Hagenbuch]

Quoting Marc Hauswirth <marc at practeo.ch>:

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

> 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

Sounds like we need a case for > and < in Horde_SQL to cast the value 
for postgresql... Send a patch, or file a bug on bugs.horde.org 
(including the full SQL error).

-chuck

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