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 |
file 'horde-FRAMEWORK_3-2005-05-03.tar.gz ' doesn't contain the
FRAMEWORK libs.
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
State ⇒ Not A Bug
from http://snaps.horde.org/
State ⇒ Unconfirmed
Priority ⇒ 2. Medium
Type ⇒ Bug
Summary ⇒ Datatree DB Error with Oracle 10g with Horde 3.0.4
Queue ⇒ Horde Framework Packages
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.