[dev] Postgres problems with Ansel

[Jos W. van der Woude]

Hi all,

Just updated horde plus apps to latest cvs build.
The good news is that imp, ingo, turba, kronolith, nag, mnemo, gollem 
and trean all work fine. Thanks a lot guys!

Ansel does not seem to work properly in conjunction with my postgres 
(8.0.1) database.

The error returned is: "DB error: unkown error"

This is what shows up in my logs:

Mar 22 14:23:19 HORDE [error] [ansel] DB Error: unknown error: SELECT 
c.datatree_id, c.datatree_name FROM horde_datatree c LEFT
JOIN horde_datatree_attributes a1 ON a1.datatree_id = c.datatree_id 
LEFT JOIN horde_datatree_attributes a2 ON a2.datatree_id =
c.datatree_id WHERE c.group_uid = 'horde.shares.ansel' AND 
((a1.attribute_name = 'owner' AND a1.attribute_value = 'jos') OR (a
1.attribute_name = 'perm_users' AND a1.attribute_key = 'jos' AND CASE 
WHEN CAST(a1.attribute_value AS VARCHAR) ~ '^-?[0-9]+$' T
HEN (CAST(a1.attribute_value AS INTEGER) & 2) <> 0 ELSE FALSE END) OR 
(a1.attribute_name = 'perm_creator' AND CASE WHEN CAST(a1
.attribute_value AS VARCHAR) ~ '^-?[0-9]+$' THEN 
(CAST(a1.attribute_value AS INTEGER) & 2) <> 0 ELSE FALSE END) OR 
(a1.attribut
e_name = 'perm_default' AND CASE WHEN CAST(a1.attribute_value AS 
VARCHAR) ~ '^-?[0-9]+$' THEN (CAST(a1.attribute_value AS INTEG
ER) & 2) <> 0 ELSE FALSE END)) AND datatree_parents = '' AND 
a2.attribute_name = 'name'  GROUP BY c.datatree_id, c.datatree_nam
e, c.datatree_order ORDER BY a2.attribute_value ASC LIMIT 9 OFFSET 0 
[nativecode=ERROR:  column "a2.attribute_value" must appea
r in the GROUP BY clause or be used in an aggregate function] [on line 
1151 of "/usr/local/lib/php/Horde/DataTree/sql.php"]

I searched the dev list and found a message from Ben about something 
similar on Sep 6, 2004. Chuck fixed that problem the next day.

Could this be something like that?

Regards
Jos