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

[Ben Chavet]

my postgres datatree is broken again.  I suspect this commit has 
something to do
with it.

Log entry:
Sep 05 14:43:33 HORDE [error] [nag] DB Error: unknown error: SELECT DISTINCT
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 = 'horde.shares.nag' 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 ORDER BY
c.datatree_order, c.datatree_name, c.datatree_id [nativecode=ERROR:  
for SELECT
DISTINCT, ORDER BY expressions must appear in select list] [on line 250 of
"/var/www/mail/nag/lib/Nag.php"]

--Ben

Quoting Chuck Hagenbuch <chuck at horde.org>:

> chuck       2004-09-03 09:23:54 PDT
>
>   Modified files:
>     DataTree/DataTree    sql.php
>   Log:
>   Kill GROUP BY; use DISTINCT for both variants (Duck <duck at obala.net>).
>
>   Revision  Changes    Path
>   1.143     +4 -4      framework/DataTree/DataTree/sql.php
>
>   Chora Links:
>   
> http://cvs.horde.org/diff.php/framework/DataTree/DataTree/sql.php?r1=1.142&r2=1.143&ty=u
>
> --
> To unsubscribe, mail: cvs-unsubscribe at lists.horde.org
>
>