[thor] New configuration problems

[Bradley Flubacher]

Hi,
I've just installed thor hoping that it will be useful to present project
planning a progress information to highest levels of management within my
company. I installed thor (uncompressed, and moved config/*.dist to config/*
less the dist extention.., updated /horde/config/registry.php, updated the
configuration file via the horde admin page. Accepted defaults.)

When I add a page, I get a user list that contains a PEAR error:

Other		TODO
Other	1	TODO
Other	1024	TODO
Other		TODO
Other	4086 does not exist	TODO
Other		TODO
Other	Array	TODO
Other		TODO

The 4086 changes every time a create a new project.... If I create a user group
in horde called 4086 the error goes away. Here's the info from my horde log set
to debug..


Oct 24 09:29:34 HORDE [debug] [] SQL Query by Prefs_sql::retrieve(): SELECT
pref_scope, pref_name, pref_value FROM horde_prefs WHERE pref_uid = 'bflub' AND
(pref_scope = 'thor' OR pref_scope = 'horde') ORDER BY pref_scope [on line 147
of "/var/www-secure/horde/lib/Horde/Prefs/sql.php"]
Oct 24 09:29:34 HORDE [debug] [thor] SQL Query by
DataTree_sql::getByAttributes(): 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_key = ? AND a1.attribute_value \& ?)   GROUP BY c.datatree_id,
c.datatree_name, c.datatree_order ORDER BY c.datatree_order, c.datatree_name,
c.datatree_id [on line 979 of
"/var/www-secure/horde/lib/Horde/DataTree/sql.php"]
Oct 24 09:29:34 HORDE [debug] [thor] SQL Query by DataTree_sql::_loadById():
SELECT datatree_id, datatree_parents FROM horde_datatree WHERE datatree_id IN
(4040) AND group_uid = 'thor.projects' ORDER BY datatree_id [on line 270 of
"/var/www-secure/horde/lib/Horde/DataTree/sql.php"]
Oct 24 09:29:34 HORDE [debug] [thor] SQL Query by DataTree_sql::_loadById():
SELECT datatree_id, datatree_name, datatree_parents, datatree_order FROM
horde_datatree WHERE datatree_id IN (4040, 0) AND group_uid = 'thor.projects'
ORDER BY datatree_id [on line 301 of
"/var/www-secure/horde/lib/Horde/DataTree/sql.php"]
Oct 24 09:29:34 HORDE [debug] [thor] SQL Query by DataTree_sql::getAttributes():
SELECT datatree_id, attribute_name AS name, attribute_key AS "key",
attribute_value AS value FROM horde_datatree_attributes WHERE datatree_id IN
(4040) [on line 878 of "/var/www-secure/horde/lib/Horde/DataTree/sql.php"]
Oct 24 09:29:36 HORDE [debug] [thor] SQL Query by DataTree_sql::_loadById():
SELECT datatree_id, datatree_parents FROM horde_datatree WHERE datatree_id IN
(4040) AND group_uid = 'thor.projects' ORDER BY datatree_id [on line 270 of
"/var/www-secure/horde/lib/Horde/DataTree/sql.php"]
Oct 24 09:29:36 HORDE [debug] [thor] SQL Query by DataTree_sql::_loadById():
SELECT datatree_id, datatree_name, datatree_parents, datatree_order FROM
horde_datatree WHERE datatree_id IN (4040, 0) AND group_uid = 'thor.projects'
ORDER BY datatree_id [on line 301 of
"/var/www-secure/horde/lib/Horde/DataTree/sql.php"]
Oct 24 09:29:36 HORDE [debug] [thor] SQL Query by DataTree_sql::getAttributes():
SELECT attribute_name AS name, attribute_key AS "key", attribute_value AS value
FROM horde_datatree_attributes WHERE datatree_id = 4040 [on line 900 of
"/var/www-secure/horde/lib/Horde/DataTree/sql.php"]
Oct 24 09:29:36 HORDE [debug] [thor] SQL Query by DataTree_sql::getAttributes():
SELECT attribute_name AS name, attribute_key AS "key", attribute_value AS value
FROM horde_datatree_attributes WHERE datatree_id = 4040 [on line 900 of
"/var/www-secure/horde/lib/Horde/DataTree/sql.php"]
Oct 24 09:29:36 HORDE [debug] [thor] SQL Query by
DataTree_sql::_buildLoadQuery(): SELECT datatree_id, datatree_parents FROM
horde_datatree WHERE datatree_name = 'Administrators' AND group_uid =
'horde.groups' ORDER BY datatree_id [on line 175 of
"/var/www-secure/horde/lib/Horde/DataTree/sql.php"]
Oct 24 09:29:36 HORDE [debug] [thor] SQL Query by DataTree_sql::_load(): SELECT
datatree_id, datatree_name, datatree_parents, datatree_order FROM
horde_datatree WHERE (datatree_parents LIKE ':4041:4045%' OR datatree_id = 4045
OR datatree_id IN (4041)) AND group_uid = 'horde.groups' [on line 113 of
"/var/www-secure/horde/lib/Horde/DataTree/sql.php"]
Oct 24 09:29:36 HORDE [debug] [thor] SQL Query by
DataTree_sql::_buildLoadQuery(): SELECT datatree_id, datatree_parents FROM
horde_datatree WHERE datatree_name = '4045' AND group_uid = 'horde.groups'
ORDER BY datatree_id [on line 175 of
"/var/www-secure/horde/lib/Horde/DataTree/sql.php"]
Oct 24 09:29:36 HORDE [debug] [thor] SQL Query by
DataTree_sql::_buildLoadQuery(): SELECT datatree_id, datatree_parents FROM
horde_datatree WHERE datatree_name = 'Developers' AND group_uid =
'horde.groups' ORDER BY datatree_id [on line 175 of
"/var/www-secure/horde/lib/Horde/DataTree/sql.php"]
Oct 24 09:29:36 HORDE [debug] [thor] SQL Query by DataTree_sql::_load(): SELECT
datatree_id, datatree_name, datatree_parents, datatree_order FROM
horde_datatree WHERE (datatree_parents LIKE ':4041:4043%' OR datatree_id = 4043
OR datatree_id IN (4041)) AND group_uid = 'horde.groups' [on line 113 of
"/var/www-secure/horde/lib/Horde/DataTree/sql.php"]
Oct 24 09:29:36 HORDE [debug] [thor] SQL Query by
DataTree_sql::_buildLoadQuery(): SELECT datatree_id, datatree_parents FROM
horde_datatree WHERE datatree_name = '4043' AND group_uid = 'horde.groups'
ORDER BY datatree_id [on line 175 of
"/var/www-secure/horde/lib/Horde/DataTree/sql.php"]
Oct 24 09:29:36 HORDE [debug] [thor] SQL Query by
DataTree_sql::_buildLoadQuery(): SELECT datatree_id, datatree_parents FROM
horde_datatree WHERE datatree_name = '4045' AND group_uid = 'horde.groups'
ORDER BY datatree_id [on line 175 of
"/var/www-secure/horde/lib/Horde/DataTree/sql.php"]
Oct 24 09:29:36 HORDE [debug] [thor] SQL Query by
DataTree_sql::_buildLoadQuery(): SELECT datatree_id, datatree_parents FROM
horde_datatree WHERE datatree_name = '4045' AND group_uid = 'horde.groups'
ORDER BY datatree_id [on line 175 of
"/var/www-secure/horde/lib/Horde/DataTree/sql.php"]
Oct 24 09:29:36 HORDE [debug] [thor] SQL Query by
DataTree_sql::getByAttributes(): 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_key = ? AND a1.attribute_value = ?) AND (datatree_parents = ? OR
datatree_parents LIKE ?)  GROUP BY c.datatree_id, c.datatree_name,
c.datatree_order ORDER BY c.datatree_order, c.datatree_name, c.datatree_id [on
line 979 of "/var/www-secure/horde/lib/Horde/DataTree/sql.php"]
Oct 24 09:29:36 HORDE [debug] [thor] SQL Query by DataTree_sql::getAttributes():
SELECT datatree_id, attribute_name AS name, attribute_key AS "key",
attribute_value AS value FROM horde_datatree_attributes WHERE datatree_id IN ()
[on line 878 of "/var/www-secure/horde/lib/Horde/DataTree/sql.php"]
Oct 24 09:29:36 HORDE [debug] [thor] SQL Query by
DataTree_sql::_buildLoadQuery(): SELECT datatree_id, datatree_parents FROM
horde_datatree WHERE datatree_name = 'adf' AND group_uid = 'thor.items' ORDER
BY datatree_id [on line 175 of
"/var/www-secure/horde/lib/Horde/DataTree/sql.php"]
Oct 24 09:29:36 HORDE [debug] [thor] SQL Query by
DataTree_sql::_buildLoadQuery(): SELECT datatree_id, datatree_parents FROM
horde_datatree WHERE datatree_name = 'adf' AND group_uid = 'thor.items' ORDER
BY datatree_id [on line 175 of
"/var/www-secure/horde/lib/Horde/DataTree/sql.php"]
Oct 24 09:29:36 HORDE [error] [thor] adf does not exist [on line 204 of
"/var/www-secure/horde/thor/lib/Item.php"]
Oct 24 09:29:36 HORDE [debug] [thor] SQL Query by
DataTree_sql::_buildLoadQuery(): SELECT datatree_id, datatree_parents FROM
horde_datatree WHERE datatree_name = '4045' AND group_uid = 'horde.groups'
ORDER BY datatree_id [on line 175 of
"/var/www-secure/horde/lib/Horde/DataTree/sql.php"]
Oct 24 09:29:36 HORDE [debug] [thor] SQL Query by
DataTree_sql::_buildLoadQuery(): SELECT datatree_id, datatree_parents FROM
horde_datatree WHERE datatree_name = '4045' AND group_uid = 'horde.groups'
ORDER BY datatree_id [on line 175 of
"/var/www-secure/horde/lib/Horde/DataTree/sql.php"]
Oct 24 09:29:36 HORDE [debug] [thor] SQL Query by
DataTree_sql::_buildLoadQuery(): SELECT datatree_id, datatree_parents FROM
horde_datatree WHERE datatree_name = '4043' AND group_uid = 'horde.groups'
ORDER BY datatree_id [on line 175 of
"/var/www-secure/horde/lib/Horde/DataTree/sql.php"]
Oct 24 09:29:36 HORDE [debug] [thor] SQL Query by
DataTree_sql::_buildLoadQuery(): SELECT datatree_id, datatree_parents FROM
horde_datatree WHERE datatree_name = '4043' AND group_uid = 'horde.groups'
ORDER BY datatree_id [on line 175 of
"/var/www-secure/horde/lib/Horde/DataTree/sql.php"]
Oct 24 09:29:36 HORDE [debug] [thor] SQL Query by
DataTree_sql::_buildLoadQuery(): SELECT datatree_id, datatree_parents FROM
horde_datatree WHERE datatree_name = '4043' AND group_uid = 'horde.groups'
ORDER BY datatree_id [on line 175 of
"/var/www-secure/horde/lib/Horde/DataTree/sql.php"]
Oct 24 09:29:36 HORDE [debug] [thor] SQL Query by
DataTree_sql::_buildLoadQuery(): SELECT datatree_id, datatree_parents FROM
horde_datatree WHERE datatree_name = '4045' AND group_uid = 'horde.groups'
ORDER BY datatree_id [on line 175 of
"/var/www-secure/horde/lib/Horde/DataTree/sql.php"]
Oct 24 09:29:36 HORDE [debug] [thor] SQL Query by
DataTree_sql::_buildLoadQuery(): SELECT datatree_id, datatree_parents FROM
horde_datatree WHERE datatree_name = 'Wanting' AND group_uid = 'horde.groups'
ORDER BY datatree_id [on line 175 of
"/var/www-secure/horde/lib/Horde/DataTree/sql.php"]
Oct 24 09:29:36 HORDE [debug] [thor] SQL Query by DataTree_sql::_load(): SELECT
datatree_id, datatree_name, datatree_parents, datatree_order FROM
horde_datatree WHERE (datatree_parents LIKE ':4041:4049%' OR datatree_id = 4049
OR datatree_id IN (4041)) AND group_uid = 'horde.groups' [on line 113 of
"/var/www-secure/horde/lib/Horde/DataTree/sql.php"]
Oct 24 09:29:36 HORDE [debug] [thor] SQL Query by
DataTree_sql::_buildLoadQuery(): SELECT datatree_id, datatree_parents FROM
horde_datatree WHERE datatree_name = '4049' AND group_uid = 'horde.groups'
ORDER BY datatree_id [on line 175 of
"/var/www-secure/horde/lib/Horde/DataTree/sql.php"]
Oct 24 09:29:36 HORDE [debug] [thor] SQL Query by
DataTree_sql::_buildLoadQuery(): SELECT datatree_id, datatree_parents FROM
horde_datatree WHERE datatree_name = '4045' AND group_uid = 'horde.groups'
ORDER BY datatree_id [on line 175 of
"/var/www-secure/horde/lib/Horde/DataTree/sql.php"]
Oct 24 09:29:36 HORDE [debug] [thor] SQL Query by
DataTree_sql::_buildLoadQuery(): SELECT datatree_id, datatree_parents FROM
horde_datatree WHERE datatree_name = '4043' AND group_uid = 'horde.groups'
ORDER BY datatree_id [on line 175 of
"/var/www-secure/horde/lib/Horde/DataTree/sql.php"]
Oct 24 09:29:36 HORDE [debug] [thor] SQL Query by
DataTree_sql::_buildLoadQuery(): SELECT datatree_id, datatree_parents FROM
horde_datatree WHERE datatree_name = '4045' AND group_uid = 'horde.groups'
ORDER BY datatree_id [on line 175 of
"/var/www-secure/horde/lib/Horde/DataTree/sql.php"]
Oct 24 09:29:36 HORDE [debug] [thor] SQL Query by
DataTree_sql::_buildLoadQuery(): SELECT datatree_id, datatree_parents FROM
horde_datatree WHERE datatree_name = '4043' AND group_uid = 'horde.groups'
ORDER BY datatree_id [on line 175 of
"/var/www-secure/horde/lib/Horde/DataTree/sql.php"]
Oct 24 09:29:36 HORDE [debug] [thor] SQL Query by
DataTree_sql::_buildLoadQuery(): SELECT datatree_id, datatree_parents FROM
horde_datatree WHERE datatree_name = '4045' AND group_uid = 'horde.groups'
ORDER BY datatree_id [on line 175 of
"/var/www-secure/horde/lib/Horde/DataTree/sql.php"]
Oct 24 09:29:36 HORDE [debug] [thor] SQL Query by
DataTree_sql::_buildLoadQuery(): SELECT datatree_id, datatree_parents FROM
horde_datatree WHERE datatree_name = '4043' AND group_uid = 'horde.groups'
ORDER BY datatree_id [on line 175 of
"/var/www-secure/horde/lib/Horde/DataTree/sql.php"]
Oct 24 09:29:36 HORDE [debug] [thor] SQL Query by
DataTree_sql::_buildLoadQuery(): SELECT datatree_id, datatree_parents FROM
horde_datatree WHERE datatree_name = '4045' AND group_uid = 'horde.groups'
ORDER BY datatree_id [on line 175 of
"/var/www-secure/horde/lib/Horde/DataTree/sql.php"]
Oct 24 09:29:36 HORDE [debug] [thor] SQL Query by
DataTree_sql::_buildLoadQuery(): SELECT datatree_id, datatree_parents FROM
horde_datatree WHERE datatree_name = '4043' AND group_uid = 'horde.groups'
ORDER BY datatree_id [on line 175 of
"/var/www-secure/horde/lib/Horde/DataTree/sql.php"]


-- 
Bradley J. Flubacher
REMCOM, Inc.
315 S. Allen St.
Suite 222
State College, PA 16801

Voice: 888-773-6266 x232
Fax  : 888-973-6266