liquid_feedback_core

changeset 506:f5aba1fbb845

Fixed syntax error in "get_initiatives_for_notification"
author jbe
date Tue Apr 05 20:33:39 2016 +0200 (2016-04-05)
parents be7942edfd1e
children 7bc72214ecc9
files core.sql update/core-update.v3.1.0-v3.2.0.sql
line diff
     1.1 --- a/core.sql	Tue Apr 05 20:12:24 2016 +0200
     1.2 +++ b/core.sql	Tue Apr 05 20:33:39 2016 +0200
     1.3 @@ -3211,7 +3211,7 @@
     1.4          AND "issue"."id" = "initiative"."issue_id"
     1.5          AND ( "issue"."closed" NOTNULL OR "issue"."fully_frozen" NOTNULL );
     1.6        UPDATE "member" SET
     1.7 -        "notification_counter" = "notification_counter" + 1 AND
     1.8 +        "notification_counter" = "notification_counter" + 1,
     1.9          "notification_sent" = now()
    1.10          WHERE "id" = "recipient_id_p";
    1.11        RETURN;
     2.1 --- a/update/core-update.v3.1.0-v3.2.0.sql	Tue Apr 05 20:12:24 2016 +0200
     2.2 +++ b/update/core-update.v3.1.0-v3.2.0.sql	Tue Apr 05 20:33:39 2016 +0200
     2.3 @@ -439,7 +439,7 @@
     2.4          AND "issue"."id" = "initiative"."issue_id"
     2.5          AND ( "issue"."closed" NOTNULL OR "issue"."fully_frozen" NOTNULL );
     2.6        UPDATE "member" SET
     2.7 -        "notification_counter" = "notification_counter" + 1 AND
     2.8 +        "notification_counter" = "notification_counter" + 1,
     2.9          "notification_sent" = now()
    2.10          WHERE "id" = "recipient_id_p";
    2.11        RETURN;

Impressum / About Us