From f94be4f8ab84d78800e46860994fbd91634111c8 2007-08-15 10:45:46
From: Jean-Philippe Lang <jp_lang@yahoo.fr>
Date: 2007-08-15 10:45:46
Subject: [PATCH] Fixed: SQL error on roadmap and changelog if there is no tracker to display.

git-svn-id: http://redmine.rubyforge.org/svn/trunk@636 e93f8b46-1217-0410-a6f0-8f06a7374b81

---

diff --git a/app/views/projects/changelog.rhtml b/app/views/projects/changelog.rhtml
index c761594..490b857 100644
--- a/app/views/projects/changelog.rhtml
+++ b/app/views/projects/changelog.rhtml
@@ -24,7 +24,8 @@
     <% issues = version.fixed_issues.find(:all,
                                  :include => [:status, :tracker],
                                  :conditions => ["#{IssueStatus.table_name}.is_closed=? AND #{Issue.table_name}.tracker_id in (#{@selected_tracker_ids.join(',')})", true],
-                                 :order => "#{Tracker.table_name}.position")
+                                 :order => "#{Tracker.table_name}.position") unless @selected_tracker_ids.empty?
+       issues ||= []
     %>
     <% if !issues.empty? %>
     <ul>
diff --git a/app/views/projects/roadmap.rhtml b/app/views/projects/roadmap.rhtml
index 9deb6d2..1011bcb 100644
--- a/app/views/projects/roadmap.rhtml
+++ b/app/views/projects/roadmap.rhtml
@@ -27,7 +27,8 @@
     <% issues = version.fixed_issues.find(:all,
                                  :include => [:status, :tracker],
                                  :conditions => ["tracker_id in (#{@selected_tracker_ids.join(',')})"],
-                                 :order => "#{Tracker.table_name}.position")
+                                 :order => "#{Tracker.table_name}.position") unless @selected_tracker_ids.empty?
+       issues ||= []
 
        total = issues.size
        complete = issues.inject(0) {|c,i| i.status.is_closed? ? c + 1 : c }