[eGroupWare-developers] PostgreSQL mail app error trunk@r44619

[Anthony M. <ame...@me...>]

When testing the 'mail' (not felamimail) app, I get the following error using 
PostgreSQL:

Invalid SQL: SELECT egw_ea_accounts.*,egw_ea_identities.*,(SELECT 
ARRAY_TO_STRING(ARRAY_AGG(account_id), ',') FROM egw_ea_valid WHERE 
egw_ea_valid.acc_id=egw_ea_accounts.acc_id GROUP BY egw_ea_valid.acc_id) AS 
account_id FROM egw_ea_accounts JOIN egw_ea_identities ON 
egw_ea_identities.ident_id=egw_ea_accounts.ident_id JOIN egw_ea_valid ON 
egw_ea_valid.acc_id=egw_ea_accounts.acc_id WHERE egw_ea_valid.account_id IN 
(-1,-22,-24,-23,-30,6,0) GROUP BY egw_ea_accounts.acc_id ORDER BY 
egw_ea_valid.account_id ASC,ident_org ASC,ident_realname ASC,acc_name ASC
ERROR: column "egw_ea_identities.ident_id" must appear in the GROUP BY clause 
or be used in an aggregate function
LINE 1: SELECT egw_ea_accounts.*,egw_ea_identities.*,(SELECT ARRAY_T...
^ (-1)

-A


-- 
Anthony - http://messinet.com - http://messinet.com/~amessina/gallery
8F89 5E72 8DF0 BCF0 10BE 9967 92DC 35DC B001 4A4E