nextcloud/passman

Postgres Sharing issue

开放

#581 创建于 2019年5月13日

 (0 条评论) (0 个反应) (1 位负责人)JavaScript (115 个派生)auto 404
Mediocre issuebuggood first issue

仓库指标

星标
 (821 个星标)
PR 合并指标
 (PR 指标待抓取)

描述

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.

贡献者指南