[dev] Re: [cvs] commit: framework/DataTree/DataTree sql.php

[Duck]

which sql server do you use?
I taseted it with mysql 4.x.

Duck

On Wednesday 01 of September 2004 04:31, Ben Chavet wrote:
> I'm also having a simular problem with kronolith.
>
> from my horde_log table:
>
> 404822 | 2004-08-31 23:28:45.363159 | HORDE            |        3 |
> [kronolith]
> DB Error: unknown error: SELECT a1.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 = 'horde.shares.kronolith' AND
> ((a1.attribute_name = 'owner' AND a1.attribute_value = 'ben') OR
> (a1.attribute_name = 'perm_users' AND a1.attribute_key = 'ben' AND CASE
> WHEN CAST(a1.attribute_value AS VARCHAR) ~ '^-?[0-9]+$' THEN
> (CAST(a1.attribute_value AS INTEGER) & 8) <> 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) & 8)
> <> 0 ELSE FALSE END) OR (a1.attribute_name = 'perm_default' AND CASE WHEN
> CAST(a1.attribute_value AS VARCHAR) ~ '^-?[0-9]+$' THEN
> (CAST(a1.attribute_value AS INTEGER) & 8) <> 0 ELSE FALSE END))  AND
> a1.attribute_name = a1.attribute_name GROUP BY a1.datatree_id ORDER BY
> c.datatree_order, c.datatree_name, c.datatree_id [nativecode=ERROR:  column
> "c.datatree_name" must appear in the GROUP BY clause or be used in an
> aggregate
> function] [on line 906 of "/var/www/mail/kronolith/lib/Kronolith.php"]
>