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

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

I think we're closer.  Now I get (with trunk@r44679):

ERROR:  argument of AND must be type boolean, not type integer at character 78
STATEMENT:  SELECT * FROM egw_ea_credentials  WHERE acc_id=1 AND account_id IN 
(0,6) AND cred_type & 11 ORDER BY account_id ASC

-A

On Tuesday, November 26, 2013 09:27:15 AM Klaus Leithoff Stylite wrote:
> please try Revision 44651
> That should fix the SQL error.
> -- 
> kl...@st... 
>  
> ----------------Original message-----------------
> From: Anthony Messina [ame...@me... ]
> To: egr...@li... 
> Date: Wed, 20 Nov 2013 16:00:07 -0600
> -------------------------------------------------
> > 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)

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