# HG changeset patch # User jbe # Date 1589709532 -7200 # Node ID a94f7cb8ed199a23839dc25681e342255d718013 # Parent 22c6d1da7d781291a46f36f8ff65c4b0f0b13e9d Fixed bug in take_snapshot function regarding issue_privilege (use issue_id_p instead of issue_id_v) diff -r 22c6d1da7d78 -r a94f7cb8ed19 core.sql --- a/core.sql Sat May 16 17:59:54 2020 +0200 +++ b/core.sql Sun May 17 11:58:52 2020 +0200 @@ -5384,7 +5384,7 @@ ON "privilege"."unit_id" = "unit_id_v" AND "privilege"."member_id" = "member"."id" LEFT JOIN "issue_privilege" - ON "issue_privilege"."issue_id" = "issue_id_v" + ON "issue_privilege"."issue_id" = "issue_id_p" AND "issue_privilege"."member_id" = "member"."id" WHERE "member"."active" AND COALESCE( "issue_privilege"."voting_right", "privilege"."voting_right");