Elxis CMS Forum

Extensions => Components => Topic started by: forgetms on March 10, 2010, 03:20:12

Title: Bubbles: GROUP BY error
Post by: forgetms on March 10, 2010, 03:20:12

ERROR:  column "u.email" must appear in the GROUP BY clause or be used in an aggregate function at character 8
STATEMENT:  SELECT u.email FROM users u
    LEFT JOIN bubbles b ON b.uid=u.id
    WHERE u.block='0' AND u.id <> '0'
    AND ((b.parent='52') OR (b.id = '52'))
    AND b.uid <> '0'
    GROUP BY u.id

Does replacing "GROUP BY" with "ORDER BY" at line 414 for bubbles.php fix the problem?

Regards,

CN

Title: Re: Bubbles: GROUP BY error
Post by: datahell on March 10, 2010, 09:43:28

Add u.email In the group by clause:

GROUP BY u.id, u.email