# HG changeset patch # User jbe # Date 1459881219 -7200 # Node ID f5aba1fbb8453469ba7cc77497ea6438eaf41b7e # Parent be7942edfd1ee2afb59dcf65c4218efd699f7b6c Fixed syntax error in "get_initiatives_for_notification" diff -r be7942edfd1e -r f5aba1fbb845 core.sql --- a/core.sql Tue Apr 05 20:12:24 2016 +0200 +++ b/core.sql Tue Apr 05 20:33:39 2016 +0200 @@ -3211,7 +3211,7 @@ AND "issue"."id" = "initiative"."issue_id" AND ( "issue"."closed" NOTNULL OR "issue"."fully_frozen" NOTNULL ); UPDATE "member" SET - "notification_counter" = "notification_counter" + 1 AND + "notification_counter" = "notification_counter" + 1, "notification_sent" = now() WHERE "id" = "recipient_id_p"; RETURN; diff -r be7942edfd1e -r f5aba1fbb845 update/core-update.v3.1.0-v3.2.0.sql --- a/update/core-update.v3.1.0-v3.2.0.sql Tue Apr 05 20:12:24 2016 +0200 +++ b/update/core-update.v3.1.0-v3.2.0.sql Tue Apr 05 20:33:39 2016 +0200 @@ -439,7 +439,7 @@ AND "issue"."id" = "initiative"."issue_id" AND ( "issue"."closed" NOTNULL OR "issue"."fully_frozen" NOTNULL ); UPDATE "member" SET - "notification_counter" = "notification_counter" + 1 AND + "notification_counter" = "notification_counter" + 1, "notification_sent" = now() WHERE "id" = "recipient_id_p"; RETURN;