nextcloud/passman

Postgres Sharing issue

Ouverte

#581 ouverte le 13 mai 2019

 (0 commentaire) (0 réaction) (1 personne assignée)JavaScript (115 forks)auto 404
Mediocre issuebuggood first issue

Métriques du dépôt

Stars
 (821 étoiles)
Métriques de merge PR
 (Métriques PR en attente)

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.

Guide contributeur