changeset 671:9fabf0da3b09 live

Select only the columns named in the GROUP BY clause, fixing #289
author Chris Cannam
date Fri, 09 Sep 2011 20:26:00 +0100
parents 202986dd17e4
children a3f745b2ddbd
files vendor/plugins/redmine_bibliography/app/controllers/publications_controller.rb
diffstat 1 files changed, 1 insertions(+), 1 deletions(-) [+]
line wrap: on
line diff
--- 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"