nextcloud/passman

Postgres Sharing issue

オープン

#581 opened on 2019/05/13

 (0 件のコメント) (0 件のリアクション) (1 人の担当者)JavaScript (115 件のフォーク)auto 404
Mediocre issuebuggood first issue

Repository metrics

Stars
 (821 個のスター)
PR merge metrics
 (PR metrics pending)

説明

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.

コントリビューターガイド