liquid_feedback_core

changeset 617:8e9d0878b5dc

Bugfix in function "featured_initiative" regarding reference to "issue_privilege" instead of "privilege"
author jbe
date Mon Oct 05 16:18:17 2020 +0200 (3 months ago)
parents ae53fc96c953
children 5b3b20f1278d
files core.sql update/core-update.v4.2.0-v4.2.1.sql
line diff
     1.1 --- a/core.sql	Tue Jul 28 18:57:20 2020 +0200
     1.2 +++ b/core.sql	Mon Oct 05 16:18:17 2020 +0200
     1.3 @@ -4174,8 +4174,8 @@
     1.4                "privilege"."member_id" = "recipient_id_p" AND
     1.5                "privilege"."unit_id" = "area"."unit_id"
     1.6              LEFT JOIN "issue_privilege" ON
     1.7 -              "privilege"."member_id" = "recipient_id_p" AND
     1.8 -              "privilege"."issue_id" = "initiative"."issue_id"
     1.9 +              "issue_privilege"."member_id" = "recipient_id_p" AND
    1.10 +              "issue_privilege"."issue_id" = "initiative"."issue_id"
    1.11              LEFT JOIN "subscription" ON
    1.12                "subscription"."member_id" = "recipient_id_p" AND
    1.13                "subscription"."unit_id" = "area"."unit_id"
     2.1 --- a/update/core-update.v4.2.0-v4.2.1.sql	Tue Jul 28 18:57:20 2020 +0200
     2.2 +++ b/update/core-update.v4.2.0-v4.2.1.sql	Mon Oct 05 16:18:17 2020 +0200
     2.3 @@ -184,8 +184,8 @@
     2.4                "privilege"."member_id" = "recipient_id_p" AND
     2.5                "privilege"."unit_id" = "area"."unit_id"
     2.6              LEFT JOIN "issue_privilege" ON
     2.7 -              "privilege"."member_id" = "recipient_id_p" AND
     2.8 -              "privilege"."issue_id" = "initiative"."issue_id"
     2.9 +              "issue_privilege"."member_id" = "recipient_id_p" AND
    2.10 +              "issue_privilege"."issue_id" = "initiative"."issue_id"
    2.11              LEFT JOIN "subscription" ON
    2.12                "subscription"."member_id" = "recipient_id_p" AND
    2.13                "subscription"."unit_id" = "area"."unit_id"

Impressum / About Us