{"action":"opened","issue":{"url":"https://api.github.com/repos/infoeducatie/infoeducatie-api/issues/168","labels_url":"https://api.github.com/repos/infoeducatie/infoeducatie-api/issues/168/labels{/name}","comments_url":"https://api.github.com/repos/infoeducatie/infoeducatie-api/issues/168/comments","events_url":"https://api.github.com/repos/infoeducatie/infoeducatie-api/issues/168/events","html_url":"https://github.com/infoeducatie/infoeducatie-api/issues/168","id":98144071,"number":168,"title":"Fix projects bug","user":{"login":"robertdolca","id":383543,"avatar_url":"https://avatars.githubusercontent.com/u/383543?v=3","gravatar_id":"","url":"https://api.github.com/users/robertdolca","html_url":"https://github.com/robertdolca","followers_url":"https://api.github.com/users/robertdolca/followers","following_url":"https://api.github.com/users/robertdolca/following{/other_user}","gists_url":"https://api.github.com/users/robertdolca/gists{/gist_id}","starred_url":"https://api.github.com/users/robertdolca/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/robertdolca/subscriptions","organizations_url":"https://api.github.com/users/robertdolca/orgs","repos_url":"https://api.github.com/users/robertdolca/repos","events_url":"https://api.github.com/users/robertdolca/events{/privacy}","received_events_url":"https://api.github.com/users/robertdolca/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":0,"created_at":"2015-07-30T11:23:44Z","updated_at":"2015-07-30T11:23:44Z","closed_at":null,"body":"```\r\nActionView::Template::Error: PG::GroupingError: ERROR:  column \"contestants.county\" must appear in the GROUP BY clause or be used in an aggregate function\r\nLINE 1: SELECT contestants.county, projects.* FROM \"projects\" INNER ...\r\n               ^\r\n: SELECT contestants.county, projects.* FROM \"projects\" INNER JOIN \"colaborators\" ON \"colaborators\".\"project_id\" = \"projects\".\"id\" INNER JOIN \"contestants\" ON \"contestants\".\"id\" = \"colaborators\".\"contestant_id\" WHERE \"projects\".\"finished\" = $1 AND \"projects\".\"status\" = $2 AND \"contestants\".\"edition_id\" = 1 GROUP BY \"projects\".\"id\"  ORDER BY contestants.county\r\n````"}}