[Tickets #1439] NEW: DataTree sql is not Oracle compatible

[bugs at bugs.horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/?id=1439
-----------------------------------------------------------------------
 Ticket             | 1439
 Created By         | selsky at columbia.edu
 Summary            | DataTree sql is not Oracle compatible
 Queue              | Horde Base
 Version            | 3.0.3
 State              | Unconfirmed
 Priority           | 2. Medium
 Type               | Bug
 Owners             | 
-----------------------------------------------------------------------


selsky at columbia.edu (2005-02-25 00:48) wrote:

I'm trying to use Kronolith 2.0.2 and when I go to add a new entry, I get
the following error in horde.log:

Feb 25 03:09:39 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 WHERE
c.group_uid = 'horde.shares.kronolith' AND ((a1.attribute_name = 'owner' AND
a1.attribute_value = 'user at localhost') OR (a1.attribute_name = 'perm_users'
AND a1.attribute_key = 'user at localhost' AND bitand(a1.attribute_value,2) =
2) OR (a1.attribute_name = 'perm_creator' AND bitand(a1.attribute_value,2) =
2) OR (a1.attribute_name = 'perm_default' AND bitand(a1.attribute_value,2) =
2))   GROUP BY c.datatree_id, c.datatree_name, c.datatree_order ORDER BY
c.datatree_order, c.datatree_name, c.datatree_id [nativecode=ORA-00932:
inconsistent datatypes: expected - got CLOB] [on line 975 of
"/etc/httpd/htdocs/horde/lib/Horde/DataTree/sql.php"]

This sounds like a variation of http://bugs.horde.org/ticket/?id=443