My environment:
Operating system: Windows Server 2012 R2
DB: PostgresSQL 9.6
PHP Version 7.3
Apache 2.4
I have downloaded the Docker Zip package and overwrited the folder /htdocs/egroupware, as usual, and the I ran the setup utility, as usual.
If I try to login as regular user I have this error:
Database error
Invalid SQL: SELECT egw_pm_projects.*,count(children.link_id2) AS children,ARRAY_TO_STRING(ARRAY_AGG(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 (5 ,-2)) LEFT JOIN egw_pm_roles ON egw_pm_members.role_id=egw_pm_roles.role_id LEFT JOIN egw_links AS children ON (children.link_app1=“projectmanager”
_ AND children.link_app2=“projectmanager”_
_ AND children.link_id1=egw_pm_projects.pm_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) WHERE egw_pm_projects.pm_status=‘active’ AND (pm_access=‘anonym’ OR pm_access=‘public’ AND pm_creator IN (-1,10,6,11,7,-2,5) OR pm_access=‘private’ AND pm_creator IN (5) OR role_acl!=0) AND egw_links.link_id2 IS NULL GROUP BY egw_pm_projects.pm_id,egw_pm_projects.* ORDER BY pm_used_time ASC_
ERRORE: la colonna “projectmanager” non esiste
LINE 1: …JOIN egw_links AS children ON (children.link_app1="projectma…
_ ^ (-1)_
and actually the projectmanager dosen’t work.
Try to connect as admin I have this situation:
What can I do to correct the situation?
