# HG changeset patch
# User Chris Cannam
# Date 1315596360 -3600
# Node ID 9fabf0da3b09548af6306eb817fab1d966c143a8
# Parent  202986dd17e4e02b3622b65cf38f358b67a393e8
Select only the columns named in the GROUP BY clause, fixing #289

diff -r 202986dd17e4 -r 9fabf0da3b09 vendor/plugins/redmine_bibliography/app/controllers/publications_controller.rb
--- a/vendor/plugins/redmine_bibliography/app/controllers/publications_controller.rb	Fri Sep 09 16:56:21 2011 +0100
+++ b/vendor/plugins/redmine_bibliography/app/controllers/publications_controller.rb	Fri Sep 09 20:26:00 2011 +0100
@@ -208,7 +208,7 @@
     object_id = params[:object_id]
     @object_name = "publications[authorships_attributes][#{object_id}][search_results]"
         
-    authorships_list = Authorship.like_unique(params[:q]).find(:all, :limit => 100)
+    authorships_list = Authorship.like_unique(params[:q]).find(:all, :select => "name_on_paper,institution,email", :limit => 100)
     users_list = User.active.like(params[:q]).find(:all, :limit => 100)
 
     logger.debug "Query for \"#{params[:q]}\" returned \"#{authorships_list.size}\" authorships and \"#{users_list.size}\" users"