From: Andrey Y. <yus...@gm...> - 2014-09-22 17:24:40
|
Hi, I'm getting errors when running egroupware-epl-core-14.1.20140910-1.1.noarch with postgresql84-server-8.4.20-1.el5_10.i386: *Invalid SQL: SELECT egw_ea_accounts.*,egw_ea_identities.*,ARRAY_TO_STRING(ARRAY_AGG(all_valid.account_id), ',') AS account_id,cred_username AS acc_imap_admin_username 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 LEFT JOIN egw_ea_valid all_valid ON all_valid.acc_id=egw_ea_accounts.acc_id LEFT JOIN egw_ea_credentials ON egw_ea_credentials.acc_id=egw_ea_accounts.acc_id AND cred_type=8 GROUP BY egw_ea_accounts.acc_id,egw_ea_identities.ident_id,egw_ea_valid.account_id,egw_ea_accounts.*,egw_ea_identities.*,acc_imap_admin_username ORDER BY egw_ea_valid.account_id ASC,ident_org ASC,ident_realname ASC,acc_name ASC **ERROR: column "egw_ea_accounts.acc_name" **must appear in the GROUP BY clause or be used in an aggregate function at character 8 (-1)* *SELECT SUM(pe_completion * (CASE WHEN pe_share IS NULL AND pe_planned_time IS NULL AND pe_replanned_time IS NULL THEN 240 WHEN pe_share IS NULL AND pe_planned_time IS NULL THEN pe_replanned_time WHEN pe_share IS NULL THEN pe_planned_time ELSE pe_share END)) AS pe_sum_completion_shares,SUM(CASE WHEN pe_completion IS NULL THEN NULL ELSE (CASE WHEN pe_share IS NULL AND pe_planned_time IS NULL AND pe_replanned_time IS NULL THEN 240 WHEN pe_share IS NULL AND pe_planned_time IS NULL THEN pe_replanned_time WHEN pe_share IS NULL THEN pe_planned_time ELSE pe_share END) END) AS pe_total_shares,SUM(pe_used_time) AS pe_used_time,SUM(pe_planned_time) AS pe_planned_time,SUM(pe_replanned_time) AS pe_replanned_time,SUM(pe_used_budget) AS pe_used_budget,SUM(pe_planned_budget) AS pe_planned_budget,MIN(pe_real_start) AS pe_real_start,MIN(pe_planned_start) AS pe_planned_start,MAX(pe_real_end) AS pe_real_end,MAX(pe_planned_end) AS pe_planned_end,CASE WHEN link_app1='projectmanager' AND link_id1=CAST(pm_id AS varchar) THEN link_app2 ELSE link_app1 END AS pe_app,CASE WHEN link_app1='projectmanager' AND link_id1=CAST(pm_id AS varchar) THEN link_id2 ELSE link_id1 END AS pe_app_id,link_remark AS pe_remark FROM egw_pm_elements ,egw_links WHERE pe_id=link_id AND (pm_id IS NULL AND pe_status != 'ignore') ***ERROR: column *"egw_links.link_app1" ***must appear in the GROUP BY clause or be used in an aggregate function *at character 950 (-1)* Found the thread in -developers list with this error in about a year ago: from Anthony Messina Nov 21, 2013; 5:00am PostgreSQL mail app error What can I do with this problem? Thanks in advance, Andrey. PS: Please CC me in case of any reply. Thanks! |