6.0.0-beta1
9/24/25

[#1901] Datatree DB Error with Oracle 10g with Horde 3.0.4
Summary Datatree DB Error with Oracle 10g with Horde 3.0.4
Queue Horde Framework Packages
Type Bug
State Not A Bug
Priority 2. Medium
Owners
Requester scalero (at) datadec (dot) es
Created 05/03/2005 (7449 days ago)
Due
Updated 05/03/2005 (7449 days ago)
Assigned
Resolved 05/03/2005 (7449 days ago)
Github Issue Link
Github Pull Request
Milestone
Patch No

History
05/03/2005 02:49:50 PM scalero (at) datadec (dot) es Comment #5 Reply to this comment
OK but what is the file I have to download and install?? because the 
file 'horde-FRAMEWORK_3-2005-05-03.tar.gz ' doesn't contain the 
FRAMEWORK  libs.
05/03/2005 02:38:51 PM Jan Schneider Comment #4 Reply to this comment
You can't simply upgrade single files.
05/03/2005 02:36:53 PM scalero (at) datadec (dot) es Comment #3 Reply to this comment
Sorry but I tested this files of CVS in FRAMEWORK_3 branch and, But it 
doesn't work for me:



- /framework/DataTree/DataTree.php          --> 1.151.2.3

- /framework/DataTree/DataTree/sql.php    --> 1.156.2.9



I am making something bad?



Thanks.



Sebastian Calero
05/03/2005 10:44:13 AM Jan Schneider Comment #2
State ⇒ Not A Bug
Reply to this comment
This has been fixed in CVS already, please try a FRAMEWORK_3 snapshot 
from http://snaps.horde.org/
05/03/2005 10:35:20 AM scalero (at) datadec (dot) es Comment #1
State ⇒ Unconfirmed
Priority ⇒ 2. Medium
Type ⇒ Bug
Summary ⇒ Datatree DB Error with Oracle 10g with Horde 3.0.4
Queue ⇒ Horde Framework Packages
Reply to this comment
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.

Saved Queries