[thor] New configuration problems

[Carlos Pedrinaci]

Hi,

I have created a new project in an empty installation and I didn't manage to 
reproduce your error.  I have however noticed that the team management 
section is not working properly, since it is not showing any user.
I will deal with this asap.

I'd need more information about your case...
What's the Horde version you are using?
What are you using for handling groups?
Also a log including the creation of the project would be good.

Carlos

On Monday 24 October 2005 15:53, Bradley Flubacher wrote:
> 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