A user receives this advice just after login:
Errore del database!
Invalid SQL: SELECT egw_pm_projects.*,COUNT(children.link_id2) AS children,ARRAY_TO_STRING(ARRAY_AGG(DISTINCT resources.member_uid), ',') AS resources,egw_pm_projects.pm_id AS pm_id FROM egw_pm_projects LEFT JOIN egw_pm_members AS resources ON resources.pm_id = egw_pm_projects.pm_id LEFT JOIN egw_pm_members ON (egw_pm_projects.pm_id=egw_pm_members.pm_id AND egw_pm_members.member_uid IN (11 ,-1)) LEFT JOIN egw_pm_roles ON egw_pm_members.role_id=egw_pm_roles.role_id LEFT JOIN egw_links ON egw_links.link_app2='projectmanager' AND egw_links.link_app1='projectmanager' AND egw_links.link_id2=CAST(egw_pm_projects.pm_id AS varchar) LEFT JOIN egw_links AS children ON (children.link_app1='projectmanager'
AND children.link_app2='projectmanager'
AND children.link_id1=CAST(egw_pm_projects.pm_id AS varchar)) WHERE egw_pm_projects.pm_status='active' AND (pm_access='anonym' OR pm_access='public' AND pm_creator IN (11) OR pm_access='private' AND pm_creator IN (11) OR role_acl!=0) AND egw_links.link_id2 IS NULL GROUP BY egw_pm_projects.pm_id,egw_pm_projects.*, ',resources ORDER BY pm_used_time ASC
ERRORE: stringa tra virgolette non terminata a o presso "',resources ORDER BY pm_used_time ASC"
LINE 3: ...GROUP BY egw_pm_projects.pm_id,egw_pm_projects.*, ',resource...
^ (-1)
And the project manager actually does not work for this user (it is grayed out). Other users has no problem. The problem appeared after upgrade form 19 to 20, it worked fine before upgrade.
Windows Server 2012 64-Bit, PostgresSQL, EGW 20.1
