# HG changeset patch
# User bsw
# Date 1328639155 -3600
# Node ID bed32bf10a0bbff891618a0ad7566ad05185f4c6
# Parent  aab7b0c5543f4325f5b0a11e78b454c8e37c33dd
Fixed error when listing issues with zero population

diff -r aab7b0c5543f -r bed32bf10a0b app/main/initiative/_list.lua
--- a/app/main/initiative/_list.lua	Tue Feb 07 19:25:29 2012 +0100
+++ b/app/main/initiative/_list.lua	Tue Feb 07 19:25:55 2012 +0100
@@ -150,7 +150,7 @@
     if issue.ranks_available then
       initiatives_selector:add_order_by("initiative.rank, initiative.admitted DESC, vote_ratio(initiative.positive_votes, initiative.negative_votes) DESC, initiative.id")
     else
-      initiatives_selector:add_order_by("initiative.supporter_count::float / issue.population::float DESC, initiative.id")
+      initiatives_selector:add_order_by("CASE WHEN issue.population = 0 THEN 0 ELSE initiative.supporter_count::float / issue.population::float END DESC, initiative.id")
     end
   end