Ralf,
The issue is a “quotation” sign instead of a comma. And a missing “.*”.
Please see the SQL-query Egroupware is sending:
++++
SELECT egw_pm_projects.*,
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 (1000 ,-1003,-1004,-1006,-1007,-1009,-1010)
)
LEFT JOIN egw_pm_roles ON
egw_pm_members.role_id=egw_pm_roles.role_id
LEFT JOIN egw_links ON
link_app2='projectmanager’
AND link_app1='projectmanager’
AND link_id2=CAST(egw_pm_projects.pm_id AS varchar)
WHERE pm_status='active’
AND (pm_access='anonym’
OR pm_access='public’
AND pm_creator IN (-1007,1001,1000,-1009,-1010,-1003,1003)
OR pm_access='private’
AND pm_creator IN (1000)
OR role_acl!=0
) AND link_id2 IS NULL
GROUP BY egw_pm_projects.pm_id,egw_pm_projects.*,’,resources
ORDER BY pm_modified DESC
++++
In the above, the issue is in the “GROUP BY” line:
+++
GROUP BY
egw_pm_projects.pm_id,
egw_pm_projects.*,
’,
resources
+++
There are 4 items:
egw_pm_projects.pm_id (which is fine)
egw_pm_projects.* (which is also fine, but also includes the previous one)
’ (Yes, this is a single quote. I believe this is issue 1)
resources (This is an alias as defined in “LEFT JOIN egw_pm_members as
resources”, replacing this with “resources.*” might be the correct option)
This would lead to the following GROUP BY statement:
++++
GROUP BY
egw_pm_projects.pm_id,
egw_pm_projects.,
resources.
++++
This returns my active projects (As they were in the latest release for 18.1)
Kind regards,
Joost Roeleveld
Ralf,
Thank you for your reply, but there is no difference between that version
and the one I have.
The file I used for the install is:
http://sourceforge.net/projects/egroupware/files/eGroupware-14.2/eGroupware-> 14.2.20150212/egroupware-epl-14.2.20150212.tar.bz2
Kind regards,
Joost
Hi Joost,
that has been fixed:
http://svn.stylite.de/viewvc/egroupware?revision=51558&view=revision
Either download the fixes file from above link or wait for next
maintenance package, probably on Monday.
Ralf
Hi,
I just completed an upgrade from 1.8 to 14.2 (the latest released
version)
When I try to access the Project Manager, I get a message with the
following:
+++++++++++++
Database error
Invalid SQL: SELECT
egw_pm_projects.,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 (1000
,-1003,-1004,-1006,-1007,-1009,-1010))
LEFT JOIN egw_pm_roles ON egw_pm_members.role_id=egw_pm_roles.role_id
LEFT
JOIN egw_links ON link_app2=‘projectmanager’ AND
link_app1='projectmanager’
AND link_id2=CAST(egw_pm_projects.pm_id AS varchar) WHERE
pm_status=‘active’ AND (pm_access=‘anonym’ OR pm_access=‘public’ AND
pm_creator IN
(-1007,1001,1000,-1009,-1010,-1003,1003) OR pm_access=‘private’ AND
pm_creator IN (1000) OR role_acl!=0) AND link_id2 IS NULL GROUP BY
egw_pm_projects.pm_id,egw_pm_projects.,’,resources ORDER BY pm_modified
DESC ERROR: unterminated quoted string at or near "’,resources ORDER BY
pm_modified DESC"
LINE 1: … GROUP BY
egw_pm_projects.pm_id,egw_pm_projects.*,’,resource…
++++++++++++++++
Taking the query listed above, when I replace the following:
"GROUP BY egw_pm_projects.pm_id,egw_pm_projects.*,’,resources"
with:
"GROUP BY egw_pm_projects.pm_id"
directly on the database, I get the list of projects.
Can you please look into this and let me know how to resolve this?
I am using PostgreSQL as database.
Many thanks,
Joost
–
---- Dive into the World of Parallel Programming. The Go Parallel
Website,
sponsored by Intel and developed in partnership with Slashdot Media, is
your hub for all things parallel software development, from weekly
thought leadership blogs to news, videos, case studies, tutorials and
more. Take a look and join the conversation now.
http://goparallel.sourceforge.net/
eGroupWare-users mailing list
eGroupWare-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-users
– Dive into the World of Parallel Programming. The Go Parallel Website,
sponsored by Intel and developed in partnership with Slashdot Media, is
your hub for all things parallel software development, from weekly thought
leadership blogs to news, videos, case studies, tutorials and more. Take a
look and join the conversation now. http://goparallel.sourceforge.net/
eGroupWare-users mailing list
eGroupWare-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-users
Dive into the World of Parallel Programming. The Go Parallel Website,
sponsored by Intel and developed in partnership with Slashdot Media, is your
hub for all things parallel software development, from weekly thought
leadership blogs to news, videos, case studies, tutorials and more. Take a
look and join the conversation now. http://goparallel.sourceforge.net/
eGroupWare-users mailing list
eGroupWare-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-users
