nextcloud/passman

Postgres Sharing issue

Offen

#581 geöffnet am 13.05.2019

 (0 Kommentare) (0 Reaktionen) (1 zugewiesene Person)JavaScript (115 Forks)auto 404
Mediocre issuebuggood first issue

Repository-Metriken

Stars
 (821 Sterne)
PR-Merge-Metriken
 (PR-Metriken ausstehend)

Beschreibung

There is an issue with sharing credentials while using a postgres database the query at https://github.com/nextcloud/passman/blob/master/lib/Db/ShareRequestMapper.php#L64

Postrgre does not support this kind of grouping so it should be achieved another way.

The error is: An exception occurred while executing 'SELECT *, target_user_id FROM oc_passman_share_request WHERE item_guid = ? GROUP BY target_user_id;' with params ["FFDAF598-D722-4095-9BEC-B18884DE66BF"]: SQLSTATE[42803]: Grouping error: 7 ERROR: column "oc_passman_share_request.id" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: SELECT *, target_user_id FROM oc_passman_share_request WHERE...

This seems to be affecting new share requests, can't test it more deeply right now, i'm afraid.


Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.

Contributor Guide