# HG changeset patch
# User jbe
# Date 1363536825 -3600
# Node ID 8344753f2ac147cc207efcc54afbaa7243c89ae2
# Parent  794974af6d6d89076aeeebfcecd31ad01ddbe1ed
For suggestions without individual rankings, set "proportional_order" to zero instead of NULL

diff -r 794974af6d6d -r 8344753f2ac1 lf_update_suggestion_order.c
--- a/lf_update_suggestion_order.c	Sun Mar 17 16:15:28 2013 +0100
+++ b/lf_update_suggestion_order.c	Sun Mar 17 17:13:45 2013 +0100
@@ -154,12 +154,12 @@
   char *cmd;
   int i;
   if (final) {
-    if (asprintf(&cmd, "BEGIN; UPDATE \"initiative\" SET \"final_suggestion_order_calculated\" = TRUE WHERE \"id\" = %s; UPDATE \"suggestion\" SET \"proportional_order\" = NULL WHERE \"initiative_id\" = %s", escaped_initiative_id, escaped_initiative_id) < 0) {
+    if (asprintf(&cmd, "BEGIN; UPDATE \"initiative\" SET \"final_suggestion_order_calculated\" = TRUE WHERE \"id\" = %s; UPDATE \"suggestion\" SET \"proportional_order\" = 0 WHERE \"initiative_id\" = %s", escaped_initiative_id, escaped_initiative_id) < 0) {
       fprintf(stderr, "Could not prepare query string in memory.\n");
       abort();
     }
   } else {
-    if (asprintf(&cmd, "BEGIN; UPDATE \"suggestion\" SET \"proportional_order\" = NULL WHERE \"initiative_id\" = %s", escaped_initiative_id) < 0) {
+    if (asprintf(&cmd, "BEGIN; UPDATE \"suggestion\" SET \"proportional_order\" = 0 WHERE \"initiative_id\" = %s", escaped_initiative_id) < 0) {
       fprintf(stderr, "Could not prepare query string in memory.\n");
       abort();
     }