[Incidencias #1901] NEW: Datatree DB Error with Oracle 10g with Horde 3.0.4

[bugs@bugs.horde.org]

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

Ticket URL: http://bugs.horde.org/ticket/?id=1901
-----------------------------------------------------------------------
 Ticket             | 1901
 Created By         | scalero at datadec.es
 Summary            | Datatree DB Error with Oracle 10g with Horde 3.0.4
 Queue              | Horde Framework Packages
 State              | Unconfirmed
 Priority           | 2. Medium
 Type               | Bug
 Owners             | 
-----------------------------------------------------------------------


scalero at datadec.es (2005-05-03 03:35) wrote:

Before to apply the patch "patch-horde-3.0.3-3.0.4.gz" to my installation
kronolith, nag and mnemo works well but after that 

nothing works.


This error appears in the horde log:

May 03 10:48:50 HORDE [error] [kronolith] DB Error: mismatch: 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 = ? AND ((a1.attribute_name = ? 

AND a1.attribute_value = ?) OR (a1.attribute_name = ? AND a1.attribute_key =
? AND bitand(a1.attribute_value,0) = 0) OR 

(a1.attribute_name = ? AND bitand(a1.attribute_value,0) = 0) OR
(a1.attribute_name = ? AND bitand(a1.attribute_value,0) = 0)) 

  GROUP BY c.datatree_id, c.datatree_name, c.datatree_order ORDER BY
c.datatree_order, c.datatree_name, c.datatree_id [on 

line 1016 of "/u01/horde/lib/Horde/DataTree/sql.php"]


The error takes place in the function 'getByAttributes' of the file
"horde/lib/Horde/DataTree/sql.php" in the line:


        $result = $this->_db->execute($stmt, $values);


And If I print the content of $values:

Array
(
    [0] => horde.shares.kronolith
    [1] => owner
    [2] => testuser
    [3] => perm_users
    [4] => testuser
    [5] => 2
    [6] => 2
    [7] => perm_creator
    [8] => 2
    [9] => 2
    [10] => perm_default
    [11] => 2
    [12] => 2
)


And I observe that several of the values appear repeated!.


Sorry but I am not a expert in Oracle nor in BBDD, and I don't find a good
possible solution. 


Greetings and thanks.


Sebastian Calero.