Skip to content

Instantly share code, notes, and snippets.

@urbanautomaton
Created May 14, 2011 13:38
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save urbanautomaton/972217 to your computer and use it in GitHub Desktop.
Save urbanautomaton/972217 to your computer and use it in GitHub Desktop.
ActiveAdmin join scope error: stack trace
Mysql2::Error: Column 'id' in order clause is ambiguous: SELECT COUNT(*) AS count_all, users.id AS users_id FROM `users` LEFT JOIN followings ON users.id = followings.followee_id GROUP BY users.id WHERE COUNT(followings.followee_id) > 10 ORDER BY id desc
activerecord (3.0.7) lib/active_record/connection_adapters/abstract_adapter.rb:207:in `rescue in log'
activerecord (3.0.7) lib/active_record/connection_adapters/abstract_adapter.rb:199:in `log'
mysql2 (0.2.6) lib/active_record/connection_adapters/mysql2_adapter.rb:314:in `execute'
mysql2 (0.2.6) lib/active_record/connection_adapters/mysql2_adapter.rb:635:in `select'
activerecord (3.0.7) lib/active_record/connection_adapters/abstract/database_statements.rb:7:in `select_all'
activerecord (3.0.7) lib/active_record/connection_adapters/abstract/query_cache.rb:54:in `block in select_all'
activerecord (3.0.7) lib/active_record/connection_adapters/abstract/query_cache.rb:68:in `cache_sql'
activerecord (3.0.7) lib/active_record/connection_adapters/abstract/query_cache.rb:54:in `select_all'
activerecord (3.0.7) lib/active_record/relation/calculations.rb:235:in `execute_grouped_calculation'
activerecord (3.0.7) lib/active_record/relation/calculations.rb:180:in `perform_calculation'
activerecord (3.0.7) lib/active_record/relation/calculations.rb:152:in `calculate'
activerecord (3.0.7) lib/active_record/relation/calculations.rb:58:in `count'
/Users/simon/.rvm/gems/ruby-1.9.2-p180/bundler/gems/active_admin-c20ac3f6016e/lib/active_admin/views/components/scopes.rb:52:in `get_scope_count'
/Users/simon/.rvm/gems/ruby-1.9.2-p180/bundler/gems/active_admin-c20ac3f6016e/lib/active_admin/views/components/scopes.rb:46:in `block in scope_count'
/Users/simon/.rvm/gems/ruby-1.9.2-p180/bundler/gems/active_admin-c20ac3f6016e/lib/active_admin/arbre/html.rb:41:in `block in build_tag'
/Users/simon/.rvm/gems/ruby-1.9.2-p180/bundler/gems/active_admin-c20ac3f6016e/lib/active_admin/arbre/html.rb:69:in `with_current_dom_context'
/Users/simon/.rvm/gems/ruby-1.9.2-p180/bundler/gems/active_admin-c20ac3f6016e/lib/active_admin/arbre/html.rb:40:in `build_tag'
/Users/simon/.rvm/gems/ruby-1.9.2-p180/bundler/gems/active_admin-c20ac3f6016e/lib/active_admin/arbre/html.rb:50:in `insert_tag'
/Users/simon/.rvm/gems/ruby-1.9.2-p180/bundler/gems/active_admin-c20ac3f6016e/lib/active_admin/arbre/element.rb:17:in `span'
/Users/simon/.rvm/gems/ruby-1.9.2-p180/bundler/gems/active_admin-c20ac3f6016e/lib/active_admin/views/components/scopes.rb:45:in `scope_count'
/Users/simon/.rvm/gems/ruby-1.9.2-p180/bundler/gems/active_admin-c20ac3f6016e/lib/active_admin/views/components/scopes.rb:25:in `block in build_scope'
/Users/simon/.rvm/gems/ruby-1.9.2-p180/bundler/gems/active_admin-c20ac3f6016e/lib/active_admin/arbre/html.rb:41:in `block in build_tag'
/Users/simon/.rvm/gems/ruby-1.9.2-p180/bundler/gems/active_admin-c20ac3f6016e/lib/active_admin/arbre/html.rb:69:in `with_current_dom_context'
/Users/simon/.rvm/gems/ruby-1.9.2-p180/bundler/gems/active_admin-c20ac3f6016e/lib/active_admin/arbre/html.rb:40:in `build_tag'
/Users/simon/.rvm/gems/ruby-1.9.2-p180/bundler/gems/active_admin-c20ac3f6016e/lib/active_admin/arbre/html.rb:50:in `insert_tag'
/Users/simon/.rvm/gems/ruby-1.9.2-p180/bundler/gems/active_admin-c20ac3f6016e/lib/active_admin/arbre/element.rb:17:in `span'
/Users/simon/.rvm/gems/ruby-1.9.2-p180/bundler/gems/active_admin-c20ac3f6016e/lib/active_admin/views/components/scopes.rb:18:in `build_scope'
/Users/simon/.rvm/gems/ruby-1.9.2-p180/bundler/gems/active_admin-c20ac3f6016e/lib/active_admin/views/components/scopes.rb:11:in `block in build'
/Users/simon/.rvm/gems/ruby-1.9.2-p180/bundler/gems/active_admin-c20ac3f6016e/lib/active_admin/views/components/scopes.rb:10:in `each'
/Users/simon/.rvm/gems/ruby-1.9.2-p180/bundler/gems/active_admin-c20ac3f6016e/lib/active_admin/views/components/scopes.rb:10:in `build'
/Users/simon/.rvm/gems/ruby-1.9.2-p180/bundler/gems/active_admin-c20ac3f6016e/lib/active_admin/arbre/html.rb:36:in `build_tag'
/Users/simon/.rvm/gems/ruby-1.9.2-p180/bundler/gems/active_admin-c20ac3f6016e/lib/active_admin/arbre/html.rb:50:in `insert_tag'
/Users/simon/.rvm/gems/ruby-1.9.2-p180/bundler/gems/active_admin-c20ac3f6016e/lib/active_admin/arbre/element.rb:17:in `scopes_renderer'
/Users/simon/.rvm/gems/ruby-1.9.2-p180/bundler/gems/active_admin-c20ac3f6016e/lib/active_admin/views/pages/index.rb:33:in `build_scopes'
/Users/simon/.rvm/gems/ruby-1.9.2-p180/bundler/gems/active_admin-c20ac3f6016e/lib/active_admin/views/pages/index.rb:19:in `main_content'
/Users/simon/.rvm/gems/ruby-1.9.2-p180/bundler/gems/active_admin-c20ac3f6016e/lib/active_admin/views/pages/base.rb:94:in `block (2 levels) in build_main_content_wrapper'
/Users/simon/.rvm/gems/ruby-1.9.2-p180/bundler/gems/active_admin-c20ac3f6016e/lib/active_admin/arbre/html.rb:41:in `block in build_tag'
/Users/simon/.rvm/gems/ruby-1.9.2-p180/bundler/gems/active_admin-c20ac3f6016e/lib/active_admin/arbre/html.rb:69:in `with_current_dom_context'
/Users/simon/.rvm/gems/ruby-1.9.2-p180/bundler/gems/active_admin-c20ac3f6016e/lib/active_admin/arbre/html.rb:40:in `build_tag'
/Users/simon/.rvm/gems/ruby-1.9.2-p180/bundler/gems/active_admin-c20ac3f6016e/lib/active_admin/arbre/html.rb:50:in `insert_tag'
/Users/simon/.rvm/gems/ruby-1.9.2-p180/bundler/gems/active_admin-c20ac3f6016e/lib/active_admin/arbre/element.rb:17:in `div'
/Users/simon/.rvm/gems/ruby-1.9.2-p180/bundler/gems/active_admin-c20ac3f6016e/lib/active_admin/views/pages/base.rb:93:in `block in build_main_content_wrapper'
/Users/simon/.rvm/gems/ruby-1.9.2-p180/bundler/gems/active_admin-c20ac3f6016e/lib/active_admin/arbre/html.rb:41:in `block in build_tag'
/Users/simon/.rvm/gems/ruby-1.9.2-p180/bundler/gems/active_admin-c20ac3f6016e/lib/active_admin/arbre/html.rb:69:in `with_current_dom_context'
/Users/simon/.rvm/gems/ruby-1.9.2-p180/bundler/gems/active_admin-c20ac3f6016e/lib/active_admin/arbre/html.rb:40:in `build_tag'
/Users/simon/.rvm/gems/ruby-1.9.2-p180/bundler/gems/active_admin-c20ac3f6016e/lib/active_admin/arbre/html.rb:50:in `insert_tag'
/Users/simon/.rvm/gems/ruby-1.9.2-p180/bundler/gems/active_admin-c20ac3f6016e/lib/active_admin/arbre/element.rb:17:in `div'
/Users/simon/.rvm/gems/ruby-1.9.2-p180/bundler/gems/active_admin-c20ac3f6016e/lib/active_admin/views/pages/base.rb:92:in `build_main_content_wrapper'
/Users/simon/.rvm/gems/ruby-1.9.2-p180/bundler/gems/active_admin-c20ac3f6016e/lib/active_admin/views/pages/base.rb:76:in `block in build_page_content'
/Users/simon/.rvm/gems/ruby-1.9.2-p180/bundler/gems/active_admin-c20ac3f6016e/lib/active_admin/arbre/html.rb:41:in `block in build_tag'
/Users/simon/.rvm/gems/ruby-1.9.2-p180/bundler/gems/active_admin-c20ac3f6016e/lib/active_admin/arbre/html.rb:69:in `with_current_dom_context'
/Users/simon/.rvm/gems/ruby-1.9.2-p180/bundler/gems/active_admin-c20ac3f6016e/lib/active_admin/arbre/html.rb:40:in `build_tag'
/Users/simon/.rvm/gems/ruby-1.9.2-p180/bundler/gems/active_admin-c20ac3f6016e/lib/active_admin/arbre/html.rb:50:in `insert_tag'
/Users/simon/.rvm/gems/ruby-1.9.2-p180/bundler/gems/active_admin-c20ac3f6016e/lib/active_admin/arbre/element.rb:17:in `div'
/Users/simon/.rvm/gems/ruby-1.9.2-p180/bundler/gems/active_admin-c20ac3f6016e/lib/active_admin/views/pages/base.rb:74:in `build_page_content'
/Users/simon/.rvm/gems/ruby-1.9.2-p180/bundler/gems/active_admin-c20ac3f6016e/lib/active_admin/views/pages/base.rb:33:in `block (2 levels) in build_page'
/Users/simon/.rvm/gems/ruby-1.9.2-p180/bundler/gems/active_admin-c20ac3f6016e/lib/active_admin/arbre/html.rb:41:in `block in build_tag'
/Users/simon/.rvm/gems/ruby-1.9.2-p180/bundler/gems/active_admin-c20ac3f6016e/lib/active_admin/arbre/html.rb:69:in `with_current_dom_context'
/Users/simon/.rvm/gems/ruby-1.9.2-p180/bundler/gems/active_admin-c20ac3f6016e/lib/active_admin/arbre/html.rb:40:in `build_tag'
/Users/simon/.rvm/gems/ruby-1.9.2-p180/bundler/gems/active_admin-c20ac3f6016e/lib/active_admin/arbre/html.rb:50:in `insert_tag'
/Users/simon/.rvm/gems/ruby-1.9.2-p180/bundler/gems/active_admin-c20ac3f6016e/lib/active_admin/arbre/element.rb:17:in `div'
/Users/simon/.rvm/gems/ruby-1.9.2-p180/bundler/gems/active_admin-c20ac3f6016e/lib/active_admin/views/pages/base.rb:30:in `block in build_page'
/Users/simon/.rvm/gems/ruby-1.9.2-p180/bundler/gems/active_admin-c20ac3f6016e/lib/active_admin/arbre/html.rb:69:in `with_current_dom_context'
/Users/simon/.rvm/gems/ruby-1.9.2-p180/bundler/gems/active_admin-c20ac3f6016e/lib/active_admin/views/pages/base.rb:29:in `build_page'
/Users/simon/.rvm/gems/ruby-1.9.2-p180/bundler/gems/active_admin-c20ac3f6016e/lib/active_admin/views/pages/base.rb:9:in `build'
/Users/simon/.rvm/gems/ruby-1.9.2-p180/bundler/gems/active_admin-c20ac3f6016e/lib/active_admin/arbre/html.rb:36:in `build_tag'
/Users/simon/.rvm/gems/ruby-1.9.2-p180/bundler/gems/active_admin-c20ac3f6016e/lib/active_admin/arbre/html.rb:50:in `insert_tag'
/Users/simon/.rvm/gems/ruby-1.9.2-p180/bundler/gems/active_admin-c20ac3f6016e/lib/active_admin/arbre/html.rb:14:in `method_missing'
/Users/simon/.rvm/gems/ruby-1.9.2-p180/bundler/gems/active_admin-c20ac3f6016e/lib/active_admin/view_helpers/renderer_helper.rb:21:in `render'
/Users/simon/.rvm/gems/ruby-1.9.2-p180/bundler/gems/active_admin-c20ac3f6016e/lib/active_admin/views/templates/active_admin_default/index.html.arb:1:in `___sers_simon__rvm_gems_ruby_______p____bundler_gems_active_admin_c__ac_f____e_lib_active_admin_views_templates_active_admin_default_index_html_arb__488791166648664576_2223613880_1817707663005083492'
actionpack (3.0.7) lib/action_view/template.rb:135:in `block in render'
activesupport (3.0.7) lib/active_support/notifications.rb:54:in `instrument'
actionpack (3.0.7) lib/action_view/template.rb:127:in `render'
actionpack (3.0.7) lib/action_view/render/rendering.rb:59:in `block in _render_template'
activesupport (3.0.7) lib/active_support/notifications.rb:52:in `block in instrument'
activesupport (3.0.7) lib/active_support/notifications/instrumenter.rb:21:in `instrument'
activesupport (3.0.7) lib/active_support/notifications.rb:52:in `instrument'
actionpack (3.0.7) lib/action_view/render/rendering.rb:56:in `_render_template'
actionpack (3.0.7) lib/action_view/render/rendering.rb:26:in `render'
haml (3.0.25) lib/haml/helpers/action_view_mods.rb:13:in `render_with_haml'
/Users/simon/.rvm/gems/ruby-1.9.2-p180/bundler/gems/active_admin-c20ac3f6016e/lib/active_admin/view_helpers/renderer_helper.rb:23:in `render'
actionpack (3.0.7) lib/abstract_controller/rendering.rb:115:in `_render_template'
actionpack (3.0.7) lib/abstract_controller/rendering.rb:109:in `render_to_body'
actionpack (3.0.7) lib/action_controller/metal/renderers.rb:47:in `render_to_body'
actionpack (3.0.7) lib/action_controller/metal/compatibility.rb:55:in `render_to_body'
actionpack (3.0.7) lib/abstract_controller/rendering.rb:102:in `render_to_string'
actionpack (3.0.7) lib/abstract_controller/rendering.rb:93:in `render'
actionpack (3.0.7) lib/action_controller/metal/rendering.rb:17:in `render'
actionpack (3.0.7) lib/action_controller/metal/instrumentation.rb:40:in `block (2 levels) in render'
activesupport (3.0.7) lib/active_support/core_ext/benchmark.rb:5:in `block in ms'
/Users/simon/.rvm/rubies/ruby-1.9.2-p180/lib/ruby/1.9.1/benchmark.rb:309:in `realtime'
activesupport (3.0.7) lib/active_support/core_ext/benchmark.rb:5:in `ms'
actionpack (3.0.7) lib/action_controller/metal/instrumentation.rb:40:in `block in render'
actionpack (3.0.7) lib/action_controller/metal/instrumentation.rb:78:in `cleanup_view_runtime'
activerecord (3.0.7) lib/active_record/railties/controller_runtime.rb:15:in `cleanup_view_runtime'
actionpack (3.0.7) lib/action_controller/metal/instrumentation.rb:39:in `render'
inherited_views (0.0.2) lib/inherited_views/base.rb:106:in `rescue in render_or_default'
inherited_views (0.0.2) lib/inherited_views/base.rb:104:in `render_or_default'
/Users/simon/.rvm/gems/ruby-1.9.2-p180/bundler/gems/active_admin-c20ac3f6016e/lib/active_admin/resource_controller/actions.rb:12:in `block (2 levels) in index'
actionpack (3.0.7) lib/action_controller/metal/responder.rb:190:in `call'
actionpack (3.0.7) lib/action_controller/metal/responder.rb:190:in `default_render'
actionpack (3.0.7) lib/action_controller/metal/responder.rb:126:in `to_html'
responders (0.6.4) lib/responders/flash_responder.rb:93:in `to_html'
actionpack (3.0.7) lib/action_controller/metal/responder.rb:119:in `respond'
actionpack (3.0.7) lib/action_controller/metal/responder.rb:112:in `call'
actionpack (3.0.7) lib/action_controller/metal/mime_responds.rb:232:in `respond_with'
inherited_resources (1.2.2) lib/inherited_resources/actions.rb:7:in `index'
/Users/simon/.rvm/gems/ruby-1.9.2-p180/bundler/gems/active_admin-c20ac3f6016e/lib/active_admin/resource_controller/actions.rb:10:in `index'
actionpack (3.0.7) lib/action_controller/metal/implicit_render.rb:5:in `send_action'
actionpack (3.0.7) lib/abstract_controller/base.rb:150:in `process_action'
actionpack (3.0.7) lib/action_controller/metal/rendering.rb:11:in `process_action'
actionpack (3.0.7) lib/abstract_controller/callbacks.rb:18:in `block in process_action'
activesupport (3.0.7) lib/active_support/callbacks.rb:481:in `_run__3359924473694317006__process_action__4110324983580079262__callbacks'
activesupport (3.0.7) lib/active_support/callbacks.rb:410:in `_run_process_action_callbacks'
activesupport (3.0.7) lib/active_support/callbacks.rb:94:in `run_callbacks'
actionpack (3.0.7) lib/abstract_controller/callbacks.rb:17:in `process_action'
actionpack (3.0.7) lib/action_controller/metal/instrumentation.rb:30:in `block in process_action'
activesupport (3.0.7) lib/active_support/notifications.rb:52:in `block in instrument'
activesupport (3.0.7) lib/active_support/notifications/instrumenter.rb:21:in `instrument'
activesupport (3.0.7) lib/active_support/notifications.rb:52:in `instrument'
actionpack (3.0.7) lib/action_controller/metal/instrumentation.rb:29:in `process_action'
actionpack (3.0.7) lib/action_controller/metal/rescue.rb:17:in `process_action'
actionpack (3.0.7) lib/abstract_controller/base.rb:119:in `process'
actionpack (3.0.7) lib/abstract_controller/rendering.rb:41:in `process'
actionpack (3.0.7) lib/action_controller/metal.rb:138:in `dispatch'
actionpack (3.0.7) lib/action_controller/metal/rack_delegation.rb:14:in `dispatch'
actionpack (3.0.7) lib/action_controller/metal.rb:178:in `block in action'
actionpack (3.0.7) lib/action_dispatch/routing/route_set.rb:62:in `call'
actionpack (3.0.7) lib/action_dispatch/routing/route_set.rb:62:in `dispatch'
actionpack (3.0.7) lib/action_dispatch/routing/route_set.rb:27:in `call'
rack-mount (0.6.14) lib/rack/mount/route_set.rb:148:in `block in call'
rack-mount (0.6.14) lib/rack/mount/code_generation.rb:93:in `block in recognize'
rack-mount (0.6.14) lib/rack/mount/code_generation.rb:75:in `optimized_each'
rack-mount (0.6.14) lib/rack/mount/code_generation.rb:92:in `recognize'
rack-mount (0.6.14) lib/rack/mount/route_set.rb:139:in `call'
actionpack (3.0.7) lib/action_dispatch/routing/route_set.rb:493:in `call'
oa-core (0.1.6) lib/omniauth/strategy.rb:50:in `call_app!'
oa-core (0.1.6) lib/omniauth/strategy.rb:32:in `call!'
oa-core (0.1.6) lib/omniauth/strategy.rb:19:in `call'
oa-core (0.1.6) lib/omniauth/strategy.rb:50:in `call_app!'
oa-core (0.1.6) lib/omniauth/strategy.rb:32:in `call!'
oa-core (0.1.6) lib/omniauth/strategy.rb:19:in `call'
oa-core (0.1.6) lib/omniauth/builder.rb:30:in `call'
hoptoad_notifier (2.4.6) lib/hoptoad_notifier/rack.rb:27:in `call'
haml (3.0.25) lib/sass/plugin/rack.rb:41:in `call'
warden (1.0.3) lib/warden/manager.rb:35:in `block in call'
warden (1.0.3) lib/warden/manager.rb:34:in `catch'
warden (1.0.3) lib/warden/manager.rb:34:in `call'
actionpack (3.0.7) lib/action_dispatch/middleware/best_standards_support.rb:17:in `call'
actionpack (3.0.7) lib/action_dispatch/middleware/head.rb:14:in `call'
rack (1.2.2) lib/rack/methodoverride.rb:24:in `call'
actionpack (3.0.7) lib/action_dispatch/middleware/params_parser.rb:21:in `call'
actionpack (3.0.7) lib/action_dispatch/middleware/flash.rb:182:in `call'
actionpack (3.0.7) lib/action_dispatch/middleware/session/abstract_store.rb:149:in `call'
actionpack (3.0.7) lib/action_dispatch/middleware/cookies.rb:302:in `call'
activerecord (3.0.7) lib/active_record/query_cache.rb:32:in `block in call'
activerecord (3.0.7) lib/active_record/connection_adapters/abstract/query_cache.rb:28:in `cache'
activerecord (3.0.7) lib/active_record/query_cache.rb:12:in `cache'
activerecord (3.0.7) lib/active_record/query_cache.rb:31:in `call'
activerecord (3.0.7) lib/active_record/connection_adapters/abstract/connection_pool.rb:354:in `call'
actionpack (3.0.7) lib/action_dispatch/middleware/callbacks.rb:46:in `block in call'
activesupport (3.0.7) lib/active_support/callbacks.rb:416:in `_run_call_callbacks'
actionpack (3.0.7) lib/action_dispatch/middleware/callbacks.rb:44:in `call'
rack (1.2.2) lib/rack/sendfile.rb:107:in `call'
actionpack (3.0.7) lib/action_dispatch/middleware/remote_ip.rb:48:in `call'
actionpack (3.0.7) lib/action_dispatch/middleware/show_exceptions.rb:47:in `call'
railties (3.0.7) lib/rails/rack/logger.rb:13:in `call'
rack (1.2.2) lib/rack/runtime.rb:17:in `call'
activesupport (3.0.7) lib/active_support/cache/strategy/local_cache.rb:72:in `call'
rack (1.2.2) lib/rack/lock.rb:11:in `block in call'
<internal:prelude>:10:in `synchronize'
rack (1.2.2) lib/rack/lock.rb:11:in `call'
actionpack (3.0.7) lib/action_dispatch/middleware/static.rb:30:in `call'
hoptoad_notifier (2.4.6) lib/hoptoad_notifier/user_informer.rb:12:in `call'
railties (3.0.7) lib/rails/application.rb:168:in `call'
railties (3.0.7) lib/rails/application.rb:77:in `method_missing'
rack (1.2.2) lib/rack/urlmap.rb:47:in `block in call'
rack (1.2.2) lib/rack/urlmap.rb:41:in `each'
rack (1.2.2) lib/rack/urlmap.rb:41:in `call'
railties (3.0.7) lib/rails/rack/debugger.rb:21:in `call'
railties (3.0.7) lib/rails/rack/log_tailer.rb:14:in `call'
rack (1.2.2) lib/rack/content_length.rb:13:in `call'
rack (1.2.2) lib/rack/handler/webrick.rb:52:in `service'
/Users/simon/.rvm/rubies/ruby-1.9.2-p180/lib/ruby/1.9.1/webrick/httpserver.rb:111:in `service'
/Users/simon/.rvm/rubies/ruby-1.9.2-p180/lib/ruby/1.9.1/webrick/httpserver.rb:70:in `run'
/Users/simon/.rvm/rubies/ruby-1.9.2-p180/lib/ruby/1.9.1/webrick/server.rb:183:in `block in start_thread'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment