# HG changeset patch
# User bsw
# Date 1328641411 -3600
# Node ID 08a5e1226da25b947cce336c307af286c321e2a0
# Parent  55c2806c7113795fdde2f2170e166b785e771854
Fixed error when issue population is zero

diff -r 55c2806c7113 -r 08a5e1226da2 app/main/initiative/_list.lua
--- a/app/main/initiative/_list.lua	Tue Feb 07 19:59:24 2012 +0100
+++ b/app/main/initiative/_list.lua	Tue Feb 07 20:03:31 2012 +0100
@@ -122,7 +122,7 @@
   order_filter[#order_filter+1] = {
     name = "potential_support",
     label = _"Potential support",
-    selector_modifier = function(selector) selector:add_order_by("initiative.supporter_count::float / issue.population::float DESC, initiative.id") end
+    selector_modifier = function(selector) selector:add_order_by("CASE WHEN issue.population = 0 THEN 0 ELSE initiative.supporter_count::float / issue.population::float END DESC, initiative.id") end
   }
 
   order_filter[#order_filter+1] = {