Skip to content

Instantly share code, notes, and snippets.

@gaelanadams
Created November 8, 2012 22:51
Show Gist options
  • Select an option

  • Save gaelanadams/4042386 to your computer and use it in GitHub Desktop.

Select an option

Save gaelanadams/4042386 to your computer and use it in GitHub Desktop.
ActiveRecord::StatementInvalid in CoursesController#index
SQLite3::SQLException: no such column: true: SELECT "enrollments".* FROM "enrollments" INNER JOIN "courses" ON "courses".id = "enrollments".course_id WHERE ("enrollments".user_id = 1) AND (courses.start_at > '2012-11-08 17:39:28'
AND courses.workflow_state = 'available'
AND courses.restrict_enrollments_to_course_dates = true)
RAILS_ROOT: /home/gadams/canvas
/home/gadams/.rvm/gems/ruby-1.8.7-p371/gems/activerecord-2.3.14/lib/active_record/connection_adapters/abstract_adapter.rb:227:in `log'
/home/gadams/.rvm/gems/ruby-1.8.7-p371/gems/activerecord-2.3.14/lib/active_record/connection_adapters/sqlite_adapter.rb:172:in `execute'
/home/gadams/.rvm/gems/ruby-1.8.7-p371/gems/activerecord-2.3.14/lib/active_record/connection_adapters/sqlite_adapter.rb:418:in `catch_schema_changes'
/home/gadams/.rvm/gems/ruby-1.8.7-p371/gems/activerecord-2.3.14/lib/active_record/connection_adapters/sqlite_adapter.rb:172:in `execute'
/home/gadams/.rvm/gems/ruby-1.8.7-p371/gems/activerecord-2.3.14/lib/active_record/connection_adapters/sqlite_adapter.rb:321:in `select'
/home/gadams/.rvm/gems/ruby-1.8.7-p371/gems/activerecord-2.3.14/lib/active_record/connection_adapters/abstract/database_statements.rb:7:in `select_all_without_query_cache'
/home/gadams/.rvm/gems/ruby-1.8.7-p371/gems/activerecord-2.3.14/lib/active_record/connection_adapters/abstract/query_cache.rb:60:in `select_all'
/home/gadams/.rvm/gems/ruby-1.8.7-p371/gems/activerecord-2.3.14/lib/active_record/connection_adapters/abstract/query_cache.rb:81:in `cache_sql'
/home/gadams/.rvm/gems/ruby-1.8.7-p371/gems/activerecord-2.3.14/lib/active_record/connection_adapters/abstract/query_cache.rb:60:in `select_all'
/home/gadams/.rvm/gems/ruby-1.8.7-p371/gems/activerecord-2.3.14/lib/active_record/base.rb:665:in `find_by_sql'
/home/gadams/.rvm/gems/ruby-1.8.7-p371/gems/activerecord-2.3.14/lib/active_record/base.rb:1582:in `find_every'
/home/gadams/.rvm/gems/ruby-1.8.7-p371/gems/activerecord-2.3.14/lib/active_record/base.rb:619:in `find'
/home/gadams/.rvm/gems/ruby-1.8.7-p371/gems/activerecord-2.3.14/lib/active_record/associations/association_collection.rb:60:in `find'
/home/gadams/.rvm/gems/ruby-1.8.7-p371/gems/activerecord-2.3.14/lib/active_record/associations/association_proxy.rb:146:in `send'
/home/gadams/.rvm/gems/ruby-1.8.7-p371/gems/activerecord-2.3.14/lib/active_record/associations/association_proxy.rb:146:in `send'
/home/gadams/.rvm/gems/ruby-1.8.7-p371/gems/activerecord-2.3.14/lib/active_record/named_scope.rb:186:in `method_missing'
/home/gadams/.rvm/gems/ruby-1.8.7-p371/gems/activerecord-2.3.14/lib/active_record/base.rb:2182:in `with_scope'
/home/gadams/.rvm/gems/ruby-1.8.7-p371/gems/activerecord-2.3.14/lib/active_record/associations/association_proxy.rb:207:in `send'
/home/gadams/.rvm/gems/ruby-1.8.7-p371/gems/activerecord-2.3.14/lib/active_record/associations/association_proxy.rb:207:in `with_scope'
/home/gadams/.rvm/gems/ruby-1.8.7-p371/gems/activerecord-2.3.14/lib/active_record/named_scope.rb:118:in `__send__'
/home/gadams/.rvm/gems/ruby-1.8.7-p371/gems/activerecord-2.3.14/lib/active_record/named_scope.rb:118:in `with_scope'
/home/gadams/.rvm/gems/ruby-1.8.7-p371/gems/activerecord-2.3.14/lib/active_record/named_scope.rb:179:in `method_missing'
/home/gadams/.rvm/gems/ruby-1.8.7-p371/gems/activerecord-2.3.14/lib/active_record/named_scope.rb:193:in `load_found'
/home/gadams/.rvm/gems/ruby-1.8.7-p371/gems/activerecord-2.3.14/lib/active_record/named_scope.rb:171:in `proxy_found'
/home/gadams/.rvm/gems/ruby-1.8.7-p371/gems/activerecord-2.3.14/lib/active_record/named_scope.rb:114:in `include?'
/home/gadams/canvas/app/controllers/courses_controller.rb:118:in `index'
/home/gadams/canvas/app/controllers/courses_controller.rb:116:in `reject!'
/home/gadams/canvas/app/controllers/courses_controller.rb:116:in `index'
/home/gadams/.rvm/gems/ruby-1.8.7-p371/gems/actionpack-2.3.14/lib/action_controller/mime_responds.rb:135:in `call'
/home/gadams/.rvm/gems/ruby-1.8.7-p371/gems/actionpack-2.3.14/lib/action_controller/mime_responds.rb:135:in `custom'
/home/gadams/.rvm/gems/ruby-1.8.7-p371/gems/actionpack-2.3.14/lib/action_controller/mime_responds.rb:179:in `call'
/home/gadams/.rvm/gems/ruby-1.8.7-p371/gems/actionpack-2.3.14/lib/action_controller/mime_responds.rb:179:in `respond'
/home/gadams/.rvm/gems/ruby-1.8.7-p371/gems/actionpack-2.3.14/lib/action_controller/mime_responds.rb:173:in `each'
/home/gadams/.rvm/gems/ruby-1.8.7-p371/gems/actionpack-2.3.14/lib/action_controller/mime_responds.rb:173:in `respond'
/home/gadams/.rvm/gems/ruby-1.8.7-p371/gems/actionpack-2.3.14/lib/action_controller/mime_responds.rb:107:in `respond_to'
/home/gadams/canvas/app/controllers/courses_controller.rb:109:in `index'
/home/gadams/.rvm/gems/ruby-1.8.7-p371/gems/actionpack-2.3.14/lib/action_controller/base.rb:1333:in `send'
/home/gadams/.rvm/gems/ruby-1.8.7-p371/gems/actionpack-2.3.14/lib/action_controller/base.rb:1333:in `perform_action_without_filters'
/home/gadams/.rvm/gems/ruby-1.8.7-p371/gems/actionpack-2.3.14/lib/action_controller/filters.rb:617:in `call_filters'
/home/gadams/.rvm/gems/ruby-1.8.7-p371/gems/actionpack-2.3.14/lib/action_controller/filters.rb:638:in `run_before_filters'
/home/gadams/canvas/app/controllers/application_controller.rb:112:in `set_locale'
/home/gadams/.rvm/gems/ruby-1.8.7-p371/gems/activesupport-2.3.14/lib/active_support/callbacks.rb:178:in `send'
/home/gadams/.rvm/gems/ruby-1.8.7-p371/gems/activesupport-2.3.14/lib/active_support/callbacks.rb:178:in `evaluate_method'
/home/gadams/.rvm/gems/ruby-1.8.7-p371/gems/actionpack-2.3.14/lib/action_controller/filters.rb:186:in `call'
/home/gadams/.rvm/gems/ruby-1.8.7-p371/gems/actionpack-2.3.14/lib/action_controller/filters.rb:635:in `run_before_filters'
/home/gadams/.rvm/gems/ruby-1.8.7-p371/gems/actionpack-2.3.14/lib/action_controller/filters.rb:615:in `call_filters'
/home/gadams/.rvm/gems/ruby-1.8.7-p371/gems/actionpack-2.3.14/lib/action_controller/filters.rb:610:in `perform_action_without_benchmark'
/home/gadams/.rvm/gems/ruby-1.8.7-p371/gems/actionpack-2.3.14/lib/action_controller/benchmarking.rb:68:in `perform_action_without_rescue'
/home/gadams/.rvm/gems/ruby-1.8.7-p371/gems/activesupport-2.3.14/lib/active_support/core_ext/benchmark.rb:17:in `ms'
/home/gadams/.rvm/rubies/ruby-1.8.7-p371/lib/ruby/1.8/benchmark.rb:308:in `realtime'
/home/gadams/.rvm/gems/ruby-1.8.7-p371/gems/activesupport-2.3.14/lib/active_support/core_ext/benchmark.rb:17:in `ms'
/home/gadams/.rvm/gems/ruby-1.8.7-p371/gems/actionpack-2.3.14/lib/action_controller/benchmarking.rb:68:in `perform_action_without_rescue'
/home/gadams/.rvm/gems/ruby-1.8.7-p371/gems/actionpack-2.3.14/lib/action_controller/rescue.rb:160:in `perform_action_without_flash'
/home/gadams/.rvm/gems/ruby-1.8.7-p371/gems/actionpack-2.3.14/lib/action_controller/flash.rb:151:in `perform_action'
/home/gadams/.rvm/gems/ruby-1.8.7-p371/gems/actionpack-2.3.14/lib/action_controller/base.rb:532:in `send'
/home/gadams/.rvm/gems/ruby-1.8.7-p371/gems/actionpack-2.3.14/lib/action_controller/base.rb:532:in `process_without_filters'
/home/gadams/.rvm/gems/ruby-1.8.7-p371/gems/actionpack-2.3.14/lib/action_controller/filters.rb:606:in `process_without_compass'
/home/gadams/.rvm/gems/ruby-1.8.7-p371/gems/compass-rails-1.0.2/lib/compass-rails/railties/2_3.rb:9:in `process'
/home/gadams/.rvm/gems/ruby-1.8.7-p371/gems/actionpack-2.3.14/lib/action_controller/base.rb:391:in `process'
/home/gadams/.rvm/gems/ruby-1.8.7-p371/gems/actionpack-2.3.14/lib/action_controller/base.rb:386:in `call'
/home/gadams/.rvm/gems/ruby-1.8.7-p371/gems/actionpack-2.3.14/lib/action_controller/routing/route_set.rb:438:in `call'
/home/gadams/.rvm/gems/ruby-1.8.7-p371/gems/actionpack-2.3.14/lib/action_controller/dispatcher.rb:87:in `dispatch'
/home/gadams/.rvm/gems/ruby-1.8.7-p371/gems/actionpack-2.3.14/lib/action_controller/dispatcher.rb:121:in `_call'
/home/gadams/.rvm/gems/ruby-1.8.7-p371/gems/actionpack-2.3.14/lib/action_controller/dispatcher.rb:130:in `build_middleware_stack'
/home/gadams/.rvm/gems/ruby-1.8.7-p371/gems/activerecord-2.3.14/lib/active_record/query_cache.rb:29:in `call'
/home/gadams/.rvm/gems/ruby-1.8.7-p371/gems/activerecord-2.3.14/lib/active_record/query_cache.rb:29:in `call'
/home/gadams/.rvm/gems/ruby-1.8.7-p371/gems/activerecord-2.3.14/lib/active_record/connection_adapters/abstract/query_cache.rb:34:in `cache'
/home/gadams/.rvm/gems/ruby-1.8.7-p371/gems/activerecord-2.3.14/lib/active_record/query_cache.rb:9:in `cache'
/home/gadams/.rvm/gems/ruby-1.8.7-p371/gems/activerecord-2.3.14/lib/active_record/query_cache.rb:28:in `call'
/home/gadams/.rvm/gems/ruby-1.8.7-p371/gems/activerecord-2.3.14/lib/active_record/connection_adapters/abstract/connection_pool.rb:361:in `call'
/home/gadams/.rvm/gems/ruby-1.8.7-p371/gems/sass-3.2.1/lib/sass/plugin/rack.rb:54:in `call'
/home/gadams/.rvm/gems/ruby-1.8.7-p371/gems/actionpack-2.3.14/lib/action_controller/string_coercion.rb:25:in `call'
/home/gadams/.rvm/gems/ruby-1.8.7-p371/gems/rack-1.1.3/lib/rack/head.rb:9:in `call'
/home/gadams/.rvm/gems/ruby-1.8.7-p371/gems/rack-1.1.3/lib/rack/methodoverride.rb:24:in `call'
/home/gadams/.rvm/gems/ruby-1.8.7-p371/gems/actionpack-2.3.14/lib/action_controller/params_parser.rb:15:in `call'
/home/gadams/canvas/vendor/plugins/respondus_soap_endpoint/lib/respondus_api_middleware.rb:60:in `call'
/home/gadams/canvas/lib/request_context_generator.rb:34:in `call'
/home/gadams/canvas/app/middleware/prevent_non_multipart_parse.rb:32:in `call'
/home/gadams/canvas/app/middleware/stats_timing.rb:8:in `call'
/home/gadams/.rvm/gems/ruby-1.8.7-p371/gems/activesupport-2.3.14/lib/active_support/core_ext/benchmark.rb:17:in `ms'
/home/gadams/.rvm/rubies/ruby-1.8.7-p371/lib/ruby/1.8/benchmark.rb:308:in `realtime'
/home/gadams/.rvm/gems/ruby-1.8.7-p371/gems/activesupport-2.3.14/lib/active_support/core_ext/benchmark.rb:17:in `ms'
/home/gadams/canvas/app/middleware/stats_timing.rb:8:in `call'
/home/gadams/canvas/app/middleware/load_account.rb:12:in `call'
/home/gadams/.rvm/gems/ruby-1.8.7-p371/gems/encrypted_cookie_store-instructure-1.0.1/lib/encrypted_cookie_store.rb:32:in `call'
/home/gadams/.rvm/gems/ruby-1.8.7-p371/gems/actionpack-2.3.14/lib/action_controller/failsafe.rb:26:in `call'
/home/gadams/.rvm/gems/ruby-1.8.7-p371/gems/rack-1.1.3/lib/rack/lock.rb:11:in `call'
/home/gadams/.rvm/gems/ruby-1.8.7-p371/gems/rack-1.1.3/lib/rack/lock.rb:11:in `synchronize'
/home/gadams/.rvm/gems/ruby-1.8.7-p371/gems/rack-1.1.3/lib/rack/lock.rb:11:in `call'
/home/gadams/.rvm/gems/ruby-1.8.7-p371/gems/actionpack-2.3.14/lib/action_controller/dispatcher.rb:106:in `call'
/home/gadams/.rvm/gems/ruby-1.8.7-p371/gems/rails-2.3.14/lib/rails/rack/static.rb:31:in `call'
/home/gadams/.rvm/gems/ruby-1.8.7-p371/gems/rack-1.1.3/lib/rack/urlmap.rb:47:in `call'
/home/gadams/.rvm/gems/ruby-1.8.7-p371/gems/rack-1.1.3/lib/rack/urlmap.rb:41:in `each'
/home/gadams/.rvm/gems/ruby-1.8.7-p371/gems/rack-1.1.3/lib/rack/urlmap.rb:41:in `call'
/home/gadams/.rvm/gems/ruby-1.8.7-p371/gems/rails-2.3.14/lib/rails/rack/log_tailer.rb:17:in `call'
/home/gadams/.rvm/gems/ruby-1.8.7-p371/gems/rack-1.1.3/lib/rack/content_length.rb:13:in `call'
/home/gadams/.rvm/gems/ruby-1.8.7-p371/gems/rack-1.1.3/lib/rack/handler/webrick.rb:48:in `service'
/home/gadams/.rvm/rubies/ruby-1.8.7-p371/lib/ruby/1.8/webrick/httpserver.rb:104:in `service'
/home/gadams/.rvm/rubies/ruby-1.8.7-p371/lib/ruby/1.8/webrick/httpserver.rb:65:in `run'
/home/gadams/.rvm/rubies/ruby-1.8.7-p371/lib/ruby/1.8/webrick/server.rb:173:in `start_thread'
/home/gadams/.rvm/rubies/ruby-1.8.7-p371/lib/ruby/1.8/webrick/server.rb:162:in `start'
/home/gadams/.rvm/rubies/ruby-1.8.7-p371/lib/ruby/1.8/webrick/server.rb:162:in `start_thread'
/home/gadams/.rvm/rubies/ruby-1.8.7-p371/lib/ruby/1.8/webrick/server.rb:95:in `start'
/home/gadams/.rvm/rubies/ruby-1.8.7-p371/lib/ruby/1.8/webrick/server.rb:92:in `each'
/home/gadams/.rvm/rubies/ruby-1.8.7-p371/lib/ruby/1.8/webrick/server.rb:92:in `start'
/home/gadams/.rvm/rubies/ruby-1.8.7-p371/lib/ruby/1.8/webrick/server.rb:23:in `start'
/home/gadams/.rvm/rubies/ruby-1.8.7-p371/lib/ruby/1.8/webrick/server.rb:82:in `start'
/home/gadams/.rvm/gems/ruby-1.8.7-p371/gems/rack-1.1.3/lib/rack/handler/webrick.rb:14:in `run'
/home/gadams/.rvm/gems/ruby-1.8.7-p371/gems/rails-2.3.14/lib/commands/server.rb:111
script/server:54:in `require'
script/server:54
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment