From: Klaus L. S. <kl...@st...> - 2013-11-26 08:27:22
|
please try Revision 44651 That should fix the SQL error. -- kl...@st... Stylite AG Developement [ open style of IT ] Morschheimer Strasse 15 67292 Kirchheimbolanden fon 06352 . 70629-0 fax 06352 . 70629-30 www.stylite.de | www.egroupware.org Managing Directors: Andre Keller | Ralf Becker | Gudrun Mueller Chairman of the supervisory board: Prof. Dr. Birger Leon Kropshofer VAT DE214280951 | Registered HRB 31158 Kaiserslautern Germany ----------------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) > > -A > > > -- > Anthony - http://messinet.com - http://messinet.com/~amessina/gallery > 8F89 5E72 8DF0 BCF0 10BE 9967 92DC 35DC B001 4A4E > __________________________________________________ > > -------------------------------------------------------------------- > ---------- > Shape the Mobile Experience: Free Subscription > Software experts and developers: Be at the forefront of tech innovation. > Intel(R) Software Adrenaline delivers strategic insight and game-changing > conversations that shape the rapidly evolving mobile landscape. Sign up now. > > http://pubads.g.doubleclick.net/gampad/clk?id=63431311&iu=/4140/ostg > .clktrk __________________________________________________ > _______________________________________________ > eGroupWare-developers mailing list > eGr...@li... > https://lists.sourceforge.net/lists/listinfo/egroupware-developers > |