GitLab

Created by: chrivers

When I try to go to /explore, I get a 500 error. I have the following in the log file:

Started GET "/explore" for 89.186.160.9 at 2014-09-30 09:55:29 +0200
Processing by Explore::ProjectsController#trending as HTML
PG::Error: ERROR:  column "projects.name" must appear in the GROUP BY clause or be used in an aggregate function
LINE 1: SELECT  projects.*, count(notes.id) as ncount FROM "projects...
                ^
: SELECT  projects.*, count(notes.id) as ncount FROM "projects" INNER JOIN "notes" ON "notes"."project_id" = "projects"."id" WHERE (projects.id IN (4,1,2,31,25,35,8,9,10,11,12,14,7,16,29,50,6,51,15,46,49,18,41,37,39,43,42,45,44,48,40,28,34,21,19,23,20,24,22) OR projects.visibility_level IN (20,10)) AND (notes.created_at > '2014-08-30') GROUP BY projects.id  ORDER BY ncount DESC LIMIT 10 OFFSET 0
Completed 500 Internal Server Error in 19ms

ActionView::Template::Error (PG::Error: ERROR:  column "projects.name" must appear in the GROUP BY clause or be used in an aggregate function
LINE 1: SELECT  projects.*, count(notes.id) as ncount FROM "projects...
                ^
: SELECT  projects.*, count(notes.id) as ncount FROM "projects" INNER JOIN "notes" ON "notes"."project_id" = "projects"."id" WHERE (projects.id IN (4,1,2,31,25,35,8,9,10,11,12,14,7,16,29,50,6,51,15,46,49,18,41,37,39,43,42,45,44,48,40,28,34,21,19,23,20,24,22) OR projects.visibility_level IN (20,10)) AND (notes.created_at > '2014-08-30') GROUP BY projects.id  ORDER BY ncount DESC LIMIT 10 OFFSET 0):
     5:   %hr
     6:   .public-projects
     7:     %ul.bordered-list
     8:       = render @trending_projects
     9: 
    10:   .center
    11:     = link_to 'Show all projects', explore_projects_path, class: 'btn btn-primary'
  app/views/explore/projects/trending.html.haml:8:in `_app_views_explore_projects_trending_html_haml___4167947021893168324_69830791692080'