From 24d6a6dbe77a63944b97b1e715437951d92600d3 Mon Sep 17 00:00:00 2001 From: Sungmin Kim Date: Tue, 8 Oct 2013 12:03:38 +0900 Subject: [PATCH] [Title] Fixed query project list in projects page. --- dibs-web/app/controllers/projects_controller.rb | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/dibs-web/app/controllers/projects_controller.rb b/dibs-web/app/controllers/projects_controller.rb index 30ad127..47c69e7 100644 --- a/dibs-web/app/controllers/projects_controller.rb +++ b/dibs-web/app/controllers/projects_controller.rb @@ -160,9 +160,9 @@ class ProjectsController < ApplicationController , projects.id AS project_id , users.email AS maintainer FROM projects - , users + LEFT JOIN users + ON users.id = projects.user_id WHERE projects.distribution_id = #{dist_id} - AND users.id = projects.user_id ORDER BY projects.name") #generate to XML -- 2.34.1