{"action":"opened","issue":{"url":"https://api.github.com/repos/ajc113/currents/issues/2","repository_url":"https://api.github.com/repos/ajc113/currents","labels_url":"https://api.github.com/repos/ajc113/currents/issues/2/labels{/name}","comments_url":"https://api.github.com/repos/ajc113/currents/issues/2/comments","events_url":"https://api.github.com/repos/ajc113/currents/issues/2/events","html_url":"https://github.com/ajc113/currents/issues/2","id":196809544,"number":2,"title":"ReportsController#index (ActionView::Template::Error) \"PG::InvalidColumnReference: ERROR:  for SELECT DISTINCT, ORDER BY expressions must appear in select list\nLINE 1: ...\"reports\" WHERE \"reports\".\"user_id\" = $1  ORDER BY date DESC\n                                                              ^\n: SELECT DISTINCT(target_species) FROM \"reports\" WHERE \"reports\".\"user_id\" = $1  ORDER BY date DESC\"","user":{"login":"ajc113","id":16250062,"avatar_url":"https://avatars.githubusercontent.com/u/16250062?v=3","gravatar_id":"","url":"https://api.github.com/users/ajc113","html_url":"https://github.com/ajc113","followers_url":"https://api.github.com/users/ajc113/followers","following_url":"https://api.github.com/users/ajc113/following{/other_user}","gists_url":"https://api.github.com/users/ajc113/gists{/gist_id}","starred_url":"https://api.github.com/users/ajc113/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ajc113/subscriptions","organizations_url":"https://api.github.com/users/ajc113/orgs","repos_url":"https://api.github.com/users/ajc113/repos","events_url":"https://api.github.com/users/ajc113/events{/privacy}","received_events_url":"https://api.github.com/users/ajc113/received_events","type":"User","site_admin":false},"labels":[{"id":366303000,"url":"https://api.github.com/repos/ajc113/currents/labels/bug","name":"bug","color":"ee0701","default":true}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2016-12-20T23:40:49Z","updated_at":"2016-12-20T23:40:49Z","closed_at":null,"body":"<table><tr><th>Exception</th><td>PG::InvalidColumnReference: ERROR:  for SELECT DISTINCT, ORDER BY expressions must appear in select list\nLINE 1: ...&quot;reports&quot; WHERE &quot;reports&quot;.&quot;user_id&quot; = $1  ORDER BY date DESC\n                                                              ^\n: SELECT DISTINCT(target_species) FROM &quot;reports&quot; WHERE &quot;reports&quot;.&quot;user_id&quot; = $1  ORDER BY date DESC</td></tr><tr><th>Last Occurrence</th><td>December 20, 2016 23:40:49 +0000</td></tr><tr><th>Count</th><td>1</td></tr></table>\n\n## Stack Trace\n<pre>[bundle].../gems/activerecord-4.2.5.1/lib/active_record/connection_adapters/postgresql_adapter.rb:637:in `prepare'\n[bundle].../gems/activerecord-4.2.5.1/lib/active_record/connection_adapters/postgresql_adapter.rb:637:in `prepare_statement'\n[bundle].../gems/activerecord-4.2.5.1/lib/active_record/connection_adapters/postgresql_adapter.rb:596:in `exec_cache'\n[bundle].../gems/activerecord-4.2.5.1/lib/active_record/connection_adapters/postgresql_adapter.rb:585:in `execute_and_clear'\n[bundle].../gems/activerecord-4.2.5.1/lib/active_record/connection_adapters/postgresql/database_statements.rb:160:in `exec_query'\n[bundle].../gems/activerecord-4.2.5.1/lib/active_record/connection_adapters/abstract/database_statements.rb:355:in `select'\n[bundle].../gems/activerecord-4.2.5.1/lib/active_record/connection_adapters/abstract/database_statements.rb:32:in `select_all'\n[bundle].../gems/activerecord-4.2.5.1/lib/active_record/connection_adapters/abstract/query_cache.rb:68:in `block in select_all'\n[bundle].../gems/activerecord-4.2.5.1/lib/active_record/connection_adapters/abstract/query_cache.rb:83:in `cache_sql'\n[bundle].../gems/activerecord-4.2.5.1/lib/active_record/connection_adapters/abstract/query_cache.rb:68:in `select_all'\n[bundle].../gems/activerecord-4.2.5.1/lib/active_record/querying.rb:39:in `find_by_sql'\n[bundle].../gems/activerecord-4.2.5.1/lib/active_record/relation.rb:639:in `exec_queries'\n[bundle].../gems/activerecord-4.2.5.1/lib/active_record/association_relation.rb:32:in `exec_queries'\n[bundle].../gems/activerecord-4.2.5.1/lib/active_record/relation.rb:515:in `load'\n[bundle].../gems/activerecord-4.2.5.1/lib/active_record/relation.rb:243:in `to_a'\n[bundle].../gems/activerecord-4.2.5.1/lib/active_record/relation/delegation.rb:46:in `each'\n<a href='https://github.com/ajc113/currents/blob/88b2390ab66816a3b49b48171b3fc2adec1d6a12/app/views/reports/index.html.erb#L81'>[app].../app/views/reports/index.html.erb:81:in `_app_views_reports_index_html_erb___3860958823891173679_70283443737140'</a>\n[bundle].../gems/actionview-4.2.5.1/lib/action_view/template.rb:145:in `block in render'\n[bundle].../gems/activesupport-4.2.5.1/lib/active_support/notifications.rb:166:in `instrument'\n[bundle].../gems/actionview-4.2.5.1/lib/action_view/template.rb:333:in `instrument'\n[bundle].../gems/actionview-4.2.5.1/lib/action_view/template.rb:143:in `render'\n[bundle].../gems/actionview-4.2.5.1/lib/action_view/renderer/template_renderer.rb:54:in `block (2 levels) in render_template'\n[bundle].../gems/actionview-4.2.5.1/lib/action_view/renderer/abstract_renderer.rb:39:in `block in instrument'\n[bundle].../gems/activesupport-4.2.5.1/lib/active_support/notifications.rb:164:in `block in instrument'\n[bundle].../gems/activesupport-4.2.5.1/lib/active_support/notifications/instrumenter.rb:20:in `instrument'\n[bundle].../gems/activesupport-4.2.5.1/lib/active_support/notifications.rb:164:in `instrument'\n[bundle].../gems/actionview-4.2.5.1/lib/action_view/renderer/abstract_renderer.rb:39:in `instrument'\n[bundle].../gems/actionview-4.2.5.1/lib/action_view/renderer/template_renderer.rb:53:in `block in render_template'\n[bundle].../gems/actionview-4.2.5.1/lib/action_view/renderer/template_renderer.rb:61:in `render_with_layout'\n[bundle].../gems/actionview-4.2.5.1/lib/action_view/renderer/template_renderer.rb:52:in `render_template'\n[bundle].../gems/actionview-4.2.5.1/lib/action_view/renderer/template_renderer.rb:14:in `render'\n[bundle].../gems/actionview-4.2.5.1/lib/action_view/renderer/renderer.rb:42:in `render_template'\n[bundle].../gems/actionview-4.2.5.1/lib/action_view/renderer/renderer.rb:23:in `render'\n[bundle].../gems/actionview-4.2.5.1/lib/action_view/rendering.rb:100:in `_render_template'\n[bundle].../gems/actionpack-4.2.5.1/lib/action_controller/metal/streaming.rb:217:in `_render_template'\n[bundle].../gems/actionview-4.2.5.1/lib/action_view/rendering.rb:83:in `render_to_body'\n[bundle].../gems/actionpack-4.2.5.1/lib/action_controller/metal/rendering.rb:32:in `render_to_body'\n[bundle].../gems/actionpack-4.2.5.1/lib/action_controller/metal/renderers.rb:37:in `render_to_body'\n[bundle].../gems/actionpack-4.2.5.1/lib/abstract_controller/rendering.rb:25:in `render'\n[bundle].../gems/actionpack-4.2.5.1/lib/action_controller/metal/rendering.rb:16:in `render'\n[bundle].../gems/actionpack-4.2.5.1/lib/action_controller/metal/instrumentation.rb:44:in `block (2 levels) in render'\n[bundle].../gems/activesupport-4.2.5.1/lib/active_support/core_ext/benchmark.rb:12:in `block in ms'\n<a href='https://github.com/ajc113/currents/blob/88b2390ab66816a3b49b48171b3fc2adec1d6a12/vendor/ruby-2.2.4/lib/ruby/2.2.0/benchmark.rb#L303'>[app].../vendor/ruby-2.2.4/lib/ruby/2.2.0/benchmark.rb:303:in `realtime'</a>\n[bundle].../gems/activesupport-4.2.5.1/lib/active_support/core_ext/benchmark.rb:12:in `ms'\n[bundle].../gems/actionpack-4.2.5.1/lib/action_controller/metal/instrumentation.rb:44:in `block in render'\n[bundle].../gems/actionpack-4.2.5.1/lib/action_controller/metal/instrumentation.rb:87:in `cleanup_view_runtime'\n[bundle].../gems/activerecord-4.2.5.1/lib/active_record/railties/controller_runtime.rb:25:in `cleanup_view_runtime'\n[bundle].../gems/actionpack-4.2.5.1/lib/action_controller/metal/instrumentation.rb:43:in `render'\n[bundle].../gems/actionpack-4.2.5.1/lib/action_controller/metal/implicit_render.rb:10:in `default_render'\n[bundle].../gems/actionpack-4.2.5.1/lib/action_controller/metal/implicit_render.rb:5:in `send_action'\n[bundle].../gems/actionpack-4.2.5.1/lib/abstract_controller/base.rb:198:in `process_action'\n[bundle].../gems/actionpack-4.2.5.1/lib/action_controller/metal/rendering.rb:10:in `process_action'\n[bundle].../gems/actionpack-4.2.5.1/lib/abstract_controller/callbacks.rb:20:in `block in process_action'\n[bundle].../gems/activesupport-4.2.5.1/lib/active_support/callbacks.rb:117:in `call'\n[bundle].../gems/activesupport-4.2.5.1/lib/active_support/callbacks.rb:117:in `call'\n[bundle].../gems/activesupport-4.2.5.1/lib/active_support/callbacks.rb:555:in `block (2 levels) in compile'\n[bundle].../gems/activesupport-4.2.5.1/lib/active_support/callbacks.rb:505:in `call'\n[bundle].../gems/activesupport-4.2.5.1/lib/active_support/callbacks.rb:505:in `call'\n[bundle].../gems/activesupport-4.2.5.1/lib/active_support/callbacks.rb:92:in `__run_callbacks__'\n[bundle].../gems/activesupport-4.2.5.1/lib/active_support/callbacks.rb:778:in `_run_process_action_callbacks'\n[bundle].../gems/activesupport-4.2.5.1/lib/active_support/callbacks.rb:81:in `run_callbacks'\n[bundle].../gems/actionpack-4.2.5.1/lib/abstract_controller/callbacks.rb:19:in `process_action'\n[bundle].../gems/actionpack-4.2.5.1/lib/action_controller/metal/rescue.rb:29:in `process_action'\n[bundle].../gems/actionpack-4.2.5.1/lib/action_controller/metal/instrumentation.rb:32:in `block in process_action'\n[bundle].../gems/activesupport-4.2.5.1/lib/active_support/notifications.rb:164:in `block in instrument'\n[bundle].../gems/activesupport-4.2.5.1/lib/active_support/notifications/instrumenter.rb:20:in `instrument'\n[bundle].../gems/activesupport-4.2.5.1/lib/active_support/notifications.rb:164:in `instrument'\n[bundle].../gems/actionpack-4.2.5.1/lib/action_controller/metal/instrumentation.rb:30:in `process_action'\n[bundle].../gems/actionpack-4.2.5.1/lib/action_controller/metal/params_wrapper.rb:250:in `process_action'\n[bundle].../gems/activerecord-4.2.5.1/lib/active_record/railties/controller_runtime.rb:18:in `process_action'\n[bundle].../gems/actionpack-4.2.5.1/lib/abstract_controller/base.rb:137:in `process'\n[bundle].../gems/actionview-4.2.5.1/lib/action_view/rendering.rb:30:in `process'\n[bundle].../gems/actionpack-4.2.5.1/lib/action_controller/metal.rb:196:in `dispatch'\n[bundle].../gems/actionpack-4.2.5.1/lib/action_controller/metal/rack_delegation.rb:13:in `dispatch'\n[bundle].../gems/actionpack-4.2.5.1/lib/action_controller/metal.rb:237:in `block in action'\n[bundle].../gems/actionpack-4.2.5.1/lib/action_dispatch/routing/route_set.rb:74:in `call'\n[bundle].../gems/actionpack-4.2.5.1/lib/action_dispatch/routing/route_set.rb:74:in `dispatch'\n[bundle].../gems/actionpack-4.2.5.1/lib/action_dispatch/routing/route_set.rb:43:in `serve'\n[bundle].../gems/actionpack-4.2.5.1/lib/action_dispatch/journey/router.rb:43:in `block in serve'\n[bundle].../gems/actionpack-4.2.5.1/lib/action_dispatch/journey/router.rb:30:in `each'\n[bundle].../gems/actionpack-4.2.5.1/lib/action_dispatch/journey/router.rb:30:in `serve'\n[bundle].../gems/actionpack-4.2.5.1/lib/action_dispatch/routing/route_set.rb:815:in `call'\n[bundle].../gems/party_foul-1.5.5/lib/party_foul/middleware.rb:8:in `call'\n[bundle].../gems/warden-1.2.6/lib/warden/manager.rb:35:in `block in call'\n[bundle].../gems/warden-1.2.6/lib/warden/manager.rb:34:in `catch'\n[bundle].../gems/warden-1.2.6/lib/warden/manager.rb:34:in `call'\n[bundle].../gems/rack-1.6.4/lib/rack/etag.rb:24:in `call'\n[bundle].../gems/rack-1.6.4/lib/rack/conditionalget.rb:25:in `call'\n[bundle].../gems/rack-1.6.4/lib/rack/head.rb:13:in `call'\n[bundle].../gems/actionpack-4.2.5.1/lib/action_dispatch/middleware/params_parser.rb:27:in `call'\n[bundle].../gems/actionpack-4.2.5.1/lib/action_dispatch/middleware/flash.rb:260:in `call'\n[bundle].../gems/rack-1.6.4/lib/rack/session/abstract/id.rb:225:in `context'\n[bundle].../gems/rack-1.6.4/lib/rack/session/abstract/id.rb:220:in `call'\n[bundle].../gems/actionpack-4.2.5.1/lib/action_dispatch/middleware/cookies.rb:560:in `call'\n[bundle].../gems/activerecord-4.2.5.1/lib/active_record/query_cache.rb:36:in `call'\n[bundle].../gems/activerecord-4.2.5.1/lib/active_record/connection_adapters/abstract/connection_pool.rb:653:in `call'\n[bundle].../gems/actionpack-4.2.5.1/lib/action_dispatch/middleware/callbacks.rb:29:in `block in call'\n[bundle].../gems/activesupport-4.2.5.1/lib/active_support/callbacks.rb:88:in `__run_callbacks__'\n[bundle].../gems/activesupport-4.2.5.1/lib/active_support/callbacks.rb:778:in `_run_call_callbacks'\n[bundle].../gems/activesupport-4.2.5.1/lib/active_support/callbacks.rb:81:in `run_callbacks'\n[bundle].../gems/actionpack-4.2.5.1/lib/action_dispatch/middleware/callbacks.rb:27:in `call'\n[bundle].../gems/actionpack-4.2.5.1/lib/action_dispatch/middleware/remote_ip.rb:78:in `call'\n[bundle].../gems/actionpack-4.2.5.1/lib/action_dispatch/middleware/debug_exceptions.rb:17:in `call'\n[bundle].../gems/actionpack-4.2.5.1/lib/action_dispatch/middleware/show_exceptions.rb:30:in `call'\n[bundle].../gems/railties-4.2.5.1/lib/rails/rack/logger.rb:38:in `call_app'\n[bundle].../gems/railties-4.2.5.1/lib/rails/rack/logger.rb:20:in `block in call'\n[bundle].../gems/activesupport-4.2.5.1/lib/active_support/tagged_logging.rb:68:in `block in tagged'\n[bundle].../gems/activesupport-4.2.5.1/lib/active_support/tagged_logging.rb:26:in `tagged'\n[bundle].../gems/activesupport-4.2.5.1/lib/active_support/tagged_logging.rb:68:in `tagged'\n[bundle].../gems/railties-4.2.5.1/lib/rails/rack/logger.rb:20:in `call'\n[bundle].../gems/actionpack-4.2.5.1/lib/action_dispatch/middleware/request_id.rb:21:in `call'\n[bundle].../gems/rack-1.6.4/lib/rack/methodoverride.rb:22:in `call'\n[bundle].../gems/rack-1.6.4/lib/rack/runtime.rb:18:in `call'\n[bundle].../gems/activesupport-4.2.5.1/lib/active_support/cache/strategy/local_cache_middleware.rb:28:in `call'\n[bundle].../gems/actionpack-4.2.5.1/lib/action_dispatch/middleware/static.rb:116:in `call'\n[bundle].../gems/rack-1.6.4/lib/rack/sendfile.rb:113:in `call'\n[bundle].../gems/railties-4.2.5.1/lib/rails/engine.rb:518:in `call'\n[bundle].../gems/railties-4.2.5.1/lib/rails/application.rb:165:in `call'\n[bundle].../gems/rack-1.6.4/lib/rack/content_length.rb:15:in `call'\n[bundle].../gems/puma-3.4.0/lib/puma/configuration.rb:224:in `call'\n[bundle].../gems/puma-3.4.0/lib/puma/server.rb:569:in `handle_request'\n[bundle].../gems/puma-3.4.0/lib/puma/server.rb:406:in `process_client'\n[bundle].../gems/puma-3.4.0/lib/puma/server.rb:271:in `block in run'\n[bundle].../gems/puma-3.4.0/lib/puma/thread_pool.rb:114:in `call'\n[bundle].../gems/puma-3.4.0/lib/puma/thread_pool.rb:114:in `block in spawn_thread'</pre>\nFingerprint: `c48dabd745cf5d1bd654a5ad60795fefc85c2bff`\n"}}
{"actor":{"display_login":"ajc113"}}