Last active
December 19, 2015 10:09
-
-
Save damien/5937815 to your computer and use it in GitHub Desktop.
This SQL query isn't working. :(
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SELECT DISTINCT "posts".* | |
| FROM "posts" | |
| INNER JOIN memberships ON posts.group_id = memberships.group_id | |
| WHERE (("posts"."published" = 't' | |
| AND "memberships"."user_id" = 17403 | |
| OR "posts"."published" = 't' | |
| AND "posts"."user_id" = 17403)) | |
| ORDER BY COALESCE(posts.liked_at, posts.updated_at, posts.created_at) DESC LIMIT 20 | |
| OFFSET 0 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| ActiveRecord::StatementInvalid - PG::Error: ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list | |
| LINE 1: ...d" = 't' AND "posts"."user_id" = 17403)) ORDER BY COALESCE(p... | |
| ^: SELECT DISTINCT "posts".* FROM "posts" INNER JOIN memberships ON posts.group_id = memberships.group_id WHERE (("posts"."published" = 't' AND "memberships"."user_id" = 17403 OR "posts"."published" = 't' AND "posts"."user_id" = 17403)) ORDER BY COALESCE(posts.liked_at, posts.updated_at, posts.created_at) DESC LIMIT 20 OFFSET 0: | |
| (gem) activerecord-3.2.13/lib/active_record/connection_adapters/abstract_adapter.rb:291:in `translate_exception' | |
| (gem) activerecord-3.2.13/lib/active_record/connection_adapters/postgresql_adapter.rb:1153:in `translate_exception' | |
| (gem) activerecord-3.2.13/lib/active_record/connection_adapters/abstract_adapter.rb:284:in `rescue in log' | |
| (gem) activerecord-3.2.13/lib/active_record/connection_adapters/abstract_adapter.rb:280:in `log' | |
| (gem) activerecord-3.2.13/lib/active_record/connection_adapters/postgresql_adapter.rb:659:in `exec_query' | |
| (gem) activerecord-3.2.13/lib/active_record/connection_adapters/postgresql_adapter.rb:1256:in `select' | |
| (gem) activerecord-3.2.13/lib/active_record/connection_adapters/abstract/database_statements.rb:18:in `select_all' | |
| (gem) activerecord-3.2.13/lib/active_record/connection_adapters/abstract/query_cache.rb:61:in `block in select_all' | |
| (gem) activerecord-3.2.13/lib/active_record/connection_adapters/abstract/query_cache.rb:75:in `cache_sql' | |
| (gem) activerecord-3.2.13/lib/active_record/connection_adapters/abstract/query_cache.rb:61:in `select_all' | |
| (gem) activerecord-3.2.13/lib/active_record/querying.rb:38:in `block in find_by_sql' | |
| (gem) activerecord-3.2.13/lib/active_record/explain.rb:41:in `logging_query_plan' | |
| (gem) activerecord-3.2.13/lib/active_record/querying.rb:37:in `find_by_sql' | |
| (gem) activerecord-3.2.13/lib/active_record/relation.rb:171:in `exec_queries' | |
| (gem) activerecord-3.2.13/lib/active_record/relation.rb:160:in `block in to_a' | |
| (gem) activerecord-3.2.13/lib/active_record/explain.rb:34:in `logging_query_plan' | |
| (gem) activerecord-3.2.13/lib/active_record/relation.rb:159:in `to_a' | |
| (gem) will_paginate-3.0.2/lib/will_paginate/active_record.rb:107:in `block in to_a' | |
| (gem) will_paginate-3.0.2/lib/will_paginate/collection.rb:96:in `create' | |
| (gem) will_paginate-3.0.2/lib/will_paginate/active_record.rb:106:in `to_a' | |
| (gem) activerecord-3.2.13/lib/active_record/relation/delegation.rb:6:in `map' | |
| (gem) draper-1.1.0/lib/draper/collection_decorator.rb:37:in `decorated_collection' | |
| (gem) draper-1.1.0/lib/draper/delegation.rb:10:in `to_ary' | |
| (gem) actionpack-3.2.13/lib/action_view/renderer/partial_renderer.rb:318:in `collection' | |
| (gem) actionpack-3.2.13/lib/action_view/renderer/partial_renderer.rb:287:in `setup' | |
| (gem) actionpack-3.2.13/lib/action_view/renderer/partial_renderer.rb:221:in `render' | |
| (gem) actionpack-3.2.13/lib/action_view/renderer/renderer.rb:41:in `render_partial' | |
| (gem) actionpack-3.2.13/lib/action_view/renderer/renderer.rb:15:in `render' | |
| (gem) actionpack-3.2.13/lib/action_view/helpers/rendering_helper.rb:24:in `render' | |
| (gem) haml-3.1.8/lib/haml/helpers/action_view_mods.rb:11:in `block in render_with_haml' | |
| (gem) haml-3.1.8/lib/haml/helpers.rb:90:in `non_haml' | |
| (gem) haml-3.1.8/lib/haml/helpers/action_view_mods.rb:11:in `render_with_haml' | |
| app/views/posts/_posts.html.haml:14:in `_app_views_posts__posts_html_haml__2540062176085841074_70330495397880' | |
| (gem) actionpack-3.2.13/lib/action_view/template.rb:145:in `block in render' | |
| (gem) activesupport-3.2.13/lib/active_support/notifications.rb:125:in `instrument' | |
| (gem) actionpack-3.2.13/lib/action_view/template.rb:143:in `render' | |
| (gem) actionpack-3.2.13/lib/action_view/renderer/partial_renderer.rb:265:in `render_partial' | |
| (gem) actionpack-3.2.13/lib/action_view/renderer/partial_renderer.rb:238:in `block in render' | |
| (gem) actionpack-3.2.13/lib/action_view/renderer/abstract_renderer.rb:38:in `block in instrument' | |
| (gem) activesupport-3.2.13/lib/active_support/notifications.rb:123:in `block in instrument' | |
| (gem) activesupport-3.2.13/lib/active_support/notifications/instrumenter.rb:20:in `instrument' | |
| (gem) activesupport-3.2.13/lib/active_support/notifications.rb:123:in `instrument' | |
| (gem) actionpack-3.2.13/lib/action_view/renderer/abstract_renderer.rb:38:in `instrument' | |
| (gem) actionpack-3.2.13/lib/action_view/renderer/partial_renderer.rb:237:in `render' | |
| (gem) actionpack-3.2.13/lib/action_view/renderer/renderer.rb:41:in `render_partial' | |
| (gem) actionpack-3.2.13/lib/action_view/helpers/rendering_helper.rb:27:in `render' | |
| (gem) haml-3.1.8/lib/haml/helpers/action_view_mods.rb:11:in `block in render_with_haml' | |
| (gem) haml-3.1.8/lib/haml/helpers.rb:90:in `non_haml' | |
| (gem) haml-3.1.8/lib/haml/helpers/action_view_mods.rb:11:in `render_with_haml' | |
| app/views/posts/index.html.haml:1:in `_app_views_posts_index_html_haml___1838442534378328469_70330495256720' | |
| (gem) actionpack-3.2.13/lib/action_view/template.rb:145:in `block in render' | |
| (gem) activesupport-3.2.13/lib/active_support/notifications.rb:125:in `instrument' | |
| (gem) actionpack-3.2.13/lib/action_view/template.rb:143:in `render' | |
| (gem) actionpack-3.2.13/lib/action_view/renderer/template_renderer.rb:47:in `block (2 levels) in render_template' | |
| (gem) actionpack-3.2.13/lib/action_view/renderer/abstract_renderer.rb:38:in `block in instrument' | |
| (gem) activesupport-3.2.13/lib/active_support/notifications.rb:123:in `block in instrument' | |
| (gem) activesupport-3.2.13/lib/active_support/notifications/instrumenter.rb:20:in `instrument' | |
| (gem) activesupport-3.2.13/lib/active_support/notifications.rb:123:in `instrument' | |
| (gem) actionpack-3.2.13/lib/action_view/renderer/abstract_renderer.rb:38:in `instrument' | |
| (gem) actionpack-3.2.13/lib/action_view/renderer/template_renderer.rb:46:in `block in render_template' | |
| (gem) actionpack-3.2.13/lib/action_view/renderer/template_renderer.rb:54:in `render_with_layout' | |
| (gem) actionpack-3.2.13/lib/action_view/renderer/template_renderer.rb:45:in `render_template' | |
| (gem) actionpack-3.2.13/lib/action_view/renderer/template_renderer.rb:18:in `render' | |
| (gem) actionpack-3.2.13/lib/action_view/renderer/renderer.rb:36:in `render_template' | |
| (gem) actionpack-3.2.13/lib/action_view/renderer/renderer.rb:17:in `render' | |
| (gem) actionpack-3.2.13/lib/abstract_controller/rendering.rb:110:in `_render_template' | |
| (gem) actionpack-3.2.13/lib/action_controller/metal/streaming.rb:225:in `_render_template' | |
| (gem) actionpack-3.2.13/lib/abstract_controller/rendering.rb:103:in `render_to_body' | |
| (gem) actionpack-3.2.13/lib/action_controller/metal/renderers.rb:28:in `render_to_body' | |
| (gem) actionpack-3.2.13/lib/action_controller/metal/compatibility.rb:50:in `render_to_body' | |
| (gem) actionpack-3.2.13/lib/abstract_controller/rendering.rb:88:in `render' | |
| (gem) actionpack-3.2.13/lib/action_controller/metal/rendering.rb:16:in `render' | |
| (gem) actionpack-3.2.13/lib/action_controller/metal/instrumentation.rb:40:in `block (2 levels) in render' | |
| (gem) activesupport-3.2.13/lib/active_support/core_ext/benchmark.rb:5:in `block in ms' | |
| /Users/damien/.rvm/rubies/ruby-2.0.0-p247/lib/ruby/2.0.0/benchmark.rb:296:in `realtime' | |
| (gem) activesupport-3.2.13/lib/active_support/core_ext/benchmark.rb:5:in `ms' | |
| (gem) actionpack-3.2.13/lib/action_controller/metal/instrumentation.rb:40:in `block in render' | |
| (gem) actionpack-3.2.13/lib/action_controller/metal/instrumentation.rb:83:in `cleanup_view_runtime' | |
| (gem) activerecord-3.2.13/lib/active_record/railties/controller_runtime.rb:24:in `cleanup_view_runtime' | |
| (gem) actionpack-3.2.13/lib/action_controller/metal/instrumentation.rb:39:in `render' | |
| (gem) actionpack-3.2.13/lib/action_controller/metal/implicit_render.rb:10:in `default_render' | |
| (gem) actionpack-3.2.13/lib/action_controller/metal/mime_responds.rb:196:in `respond_to' | |
| app/controllers/posts_controller.rb:28:in `index' | |
| (gem) actionpack-3.2.13/lib/action_controller/metal/implicit_render.rb:4:in `send_action' | |
| (gem) actionpack-3.2.13/lib/abstract_controller/base.rb:167:in `process_action' | |
| (gem) actionpack-3.2.13/lib/action_controller/metal/rendering.rb:10:in `process_action' | |
| (gem) actionpack-3.2.13/lib/abstract_controller/callbacks.rb:18:in `block in process_action' | |
| (gem) activesupport-3.2.13/lib/active_support/callbacks.rb:480:in `_run__876551880304347918__process_action__4302725865183270318__callbacks' | |
| (gem) activesupport-3.2.13/lib/active_support/callbacks.rb:405:in `__run_callback' | |
| (gem) activesupport-3.2.13/lib/active_support/callbacks.rb:385:in `_run_process_action_callbacks' | |
| (gem) activesupport-3.2.13/lib/active_support/callbacks.rb:81:in `run_callbacks' | |
| (gem) actionpack-3.2.13/lib/abstract_controller/callbacks.rb:17:in `process_action' | |
| (gem) actionpack-3.2.13/lib/action_controller/metal/rescue.rb:29:in `process_action' | |
| (gem) actionpack-3.2.13/lib/action_controller/metal/instrumentation.rb:30:in `block in process_action' | |
| (gem) activesupport-3.2.13/lib/active_support/notifications.rb:123:in `block in instrument' | |
| (gem) activesupport-3.2.13/lib/active_support/notifications/instrumenter.rb:20:in `instrument' | |
| (gem) activesupport-3.2.13/lib/active_support/notifications.rb:123:in `instrument' | |
| (gem) actionpack-3.2.13/lib/action_controller/metal/instrumentation.rb:29:in `process_action' | |
| (gem) actionpack-3.2.13/lib/action_controller/metal/params_wrapper.rb:207:in `process_action' | |
| (gem) activerecord-3.2.13/lib/active_record/railties/controller_runtime.rb:18:in `process_action' | |
| (gem) actionpack-3.2.13/lib/abstract_controller/base.rb:121:in `process' | |
| (gem) actionpack-3.2.13/lib/abstract_controller/rendering.rb:45:in `process' | |
| (gem) actionpack-3.2.13/lib/action_controller/metal.rb:203:in `dispatch' | |
| (gem) actionpack-3.2.13/lib/action_controller/metal/rack_delegation.rb:14:in `dispatch' | |
| (gem) actionpack-3.2.13/lib/action_controller/metal.rb:246:in `block in action' | |
| (gem) actionpack-3.2.13/lib/action_dispatch/routing/route_set.rb:73:in `dispatch' | |
| (gem) actionpack-3.2.13/lib/action_dispatch/routing/route_set.rb:36:in `call' | |
| (gem) journey-1.0.4/lib/journey/router.rb:68:in `block in call' | |
| (gem) journey-1.0.4/lib/journey/router.rb:56:in `call' | |
| (gem) actionpack-3.2.13/lib/action_dispatch/routing/route_set.rb:612:in `call' | |
| (gem) omniauth-1.1.4/lib/omniauth/strategy.rb:184:in `call!' | |
| (gem) omniauth-1.1.4/lib/omniauth/strategy.rb:164:in `call' | |
| (gem) request_store-1.0.5/lib/request_store/middleware.rb:9:in `call' | |
| (gem) sass-3.2.6/lib/sass/plugin/rack.rb:54:in `call' | |
| (gem) warden-1.2.1/lib/warden/manager.rb:35:in `block in call' | |
| (gem) warden-1.2.1/lib/warden/manager.rb:34:in `call' | |
| (gem) actionpack-3.2.13/lib/action_dispatch/middleware/best_standards_support.rb:17:in `call' | |
| (gem) rack-1.4.5/lib/rack/etag.rb:23:in `call' | |
| (gem) rack-1.4.5/lib/rack/conditionalget.rb:25:in `call' | |
| (gem) actionpack-3.2.13/lib/action_dispatch/middleware/head.rb:14:in `call' | |
| (gem) actionpack-3.2.13/lib/action_dispatch/middleware/params_parser.rb:21:in `call' | |
| (gem) actionpack-3.2.13/lib/action_dispatch/middleware/flash.rb:242:in `call' | |
| (gem) rack-1.4.5/lib/rack/session/abstract/id.rb:210:in `context' | |
| (gem) rack-1.4.5/lib/rack/session/abstract/id.rb:205:in `call' | |
| (gem) actionpack-3.2.13/lib/action_dispatch/middleware/cookies.rb:341:in `call' | |
| (gem) activerecord-3.2.13/lib/active_record/query_cache.rb:64:in `call' | |
| (gem) activerecord-3.2.13/lib/active_record/connection_adapters/abstract/connection_pool.rb:479:in `call' | |
| (gem) actionpack-3.2.13/lib/action_dispatch/middleware/callbacks.rb:28:in `block in call' | |
| (gem) activesupport-3.2.13/lib/active_support/callbacks.rb:405:in `_run__2572427623322022936__call__4058806809280766064__callbacks' | |
| (gem) activesupport-3.2.13/lib/active_support/callbacks.rb:405:in `__run_callback' | |
| (gem) activesupport-3.2.13/lib/active_support/callbacks.rb:385:in `_run_call_callbacks' | |
| (gem) activesupport-3.2.13/lib/active_support/callbacks.rb:81:in `run_callbacks' | |
| (gem) actionpack-3.2.13/lib/action_dispatch/middleware/callbacks.rb:27:in `call' | |
| (gem) actionpack-3.2.13/lib/action_dispatch/middleware/reloader.rb:65:in `call' | |
| (gem) actionpack-3.2.13/lib/action_dispatch/middleware/remote_ip.rb:31:in `call' | |
| (gem) airbrake-3.1.8/lib/airbrake/rails/middleware.rb:15:in `call' | |
| (gem) better_errors-0.8.0/lib/better_errors/middleware.rb:84:in `protected_app_call' | |
| (gem) better_errors-0.8.0/lib/better_errors/middleware.rb:79:in `better_errors_call' | |
| (gem) better_errors-0.8.0/lib/better_errors/middleware.rb:56:in `call' | |
| (gem) actionpack-3.2.13/lib/action_dispatch/middleware/debug_exceptions.rb:16:in `call' | |
| (gem) actionpack-3.2.13/lib/action_dispatch/middleware/show_exceptions.rb:56:in `call' | |
| (gem) railties-3.2.13/lib/rails/rack/logger.rb:32:in `call_app' | |
| (gem) railties-3.2.13/lib/rails/rack/logger.rb:16:in `block in call' | |
| (gem) activesupport-3.2.13/lib/active_support/tagged_logging.rb:22:in `tagged' | |
| (gem) railties-3.2.13/lib/rails/rack/logger.rb:16:in `call' | |
| (gem) quiet_assets-1.0.2/lib/quiet_assets.rb:18:in `call_with_quiet_assets' | |
| (gem) actionpack-3.2.13/lib/action_dispatch/middleware/request_id.rb:22:in `call' | |
| (gem) rack-1.4.5/lib/rack/methodoverride.rb:21:in `call' | |
| (gem) rack-1.4.5/lib/rack/runtime.rb:17:in `call' | |
| (gem) rack-1.4.5/lib/rack/lock.rb:15:in `call' | |
| (gem) actionpack-3.2.13/lib/action_dispatch/middleware/static.rb:63:in `call' | |
| (gem) airbrake-3.1.8/lib/airbrake/user_informer.rb:16:in `_call' | |
| (gem) airbrake-3.1.8/lib/airbrake/user_informer.rb:12:in `call' | |
| (gem) railties-3.2.13/lib/rails/engine.rb:479:in `call' | |
| (gem) railties-3.2.13/lib/rails/application.rb:223:in `call' | |
| (gem) rack-1.4.5/lib/rack/content_length.rb:14:in `call' | |
| (gem) railties-3.2.13/lib/rails/rack/log_tailer.rb:17:in `call' | |
| (gem) unicorn-4.6.2/lib/unicorn/http_server.rb:552:in `process_client' | |
| (gem) unicorn-4.6.2/lib/unicorn/http_server.rb:632:in `worker_loop' | |
| (gem) unicorn-4.6.2/lib/unicorn/http_server.rb:500:in `spawn_missing_workers' | |
| (gem) unicorn-4.6.2/lib/unicorn/http_server.rb:142:in `start' | |
| (gem) unicorn-rails-1.0.1/lib/unicorn/rails.rb:20:in `run' | |
| (gem) rack-1.4.5/lib/rack/server.rb:268:in `start' | |
| (gem) railties-3.2.13/lib/rails/commands/server.rb:70:in `start' | |
| (gem) railties-3.2.13/lib/rails/commands.rb:55:in `block in <top (required)>' | |
| (gem) railties-3.2.13/lib/rails/commands.rb:50:in `<top (required)>' | |
| script/rails:6:in `<main>' |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment