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!
