nextcloud/passman

Postgres Sharing issue

Aberta

#581 aberto em 13 de mai. de 2019

 (0 comentário) (0 reação) (1 responsável)JavaScript (115 forks)auto 404
Mediocre issuebuggood first issue

Métricas do repositório

Stars
 (821 estrelas)
Métricas de merge de PR
 (Métricas PR pendentes)

Description

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.

Guia do colaborador