Created
October 21, 2012 00:33
-
-
Save arpitchauhan/3925337 to your computer and use it in GitHub Desktop.
SQLException near ","
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
| @movies = Movie.where("rating IN :ratings;" , {:ratings => params.has_key?(:ratings) ? params[:ratings].keys : @all_ratings}) | |
| The error page: | |
| ActiveRecord::StatementInvalid in Movies#index | |
| SQLite3::SQLException: near ",": syntax error: SELECT "movies".* FROM "movies" WHERE (rating IN 'G','PG','PG-13','R','NC-17') | |
| Full Trace: | |
| sqlite3 (1.3.5) lib/sqlite3/database.rb:91:in `initialize' | |
| sqlite3 (1.3.5) lib/sqlite3/database.rb:91:in `new' | |
| sqlite3 (1.3.5) lib/sqlite3/database.rb:91:in `prepare' | |
| activerecord (3.1.0) lib/active_record/connection_adapters/sqlite_adapter.rb:175:in `block in exec_query' | |
| activerecord (3.1.0) lib/active_record/connection_adapters/abstract_adapter.rb:244:in `block in log' | |
| activesupport (3.1.0) lib/active_support/notifications/instrumenter.rb:21:in `instrument' | |
| activerecord (3.1.0) lib/active_record/connection_adapters/abstract_adapter.rb:239:in `log' | |
| activerecord (3.1.0) lib/active_record/connection_adapters/sqlite_adapter.rb:171:in `exec_query' | |
| activerecord (3.1.0) lib/active_record/connection_adapters/sqlite_adapter.rb:382:in `select' | |
| activerecord (3.1.0) lib/active_record/connection_adapters/abstract/database_statements.rb:18:in `select_all' | |
| activerecord (3.1.0) lib/active_record/connection_adapters/abstract/query_cache.rb:61:in `block in select_all' | |
| activerecord (3.1.0) lib/active_record/connection_adapters/abstract/query_cache.rb:75:in `cache_sql' | |
| activerecord (3.1.0) lib/active_record/connection_adapters/abstract/query_cache.rb:61:in `select_all' | |
| activerecord (3.1.0) lib/active_record/base.rb:470:in `find_by_sql' | |
| activerecord (3.1.0) lib/active_record/relation.rb:111:in `to_a' | |
| activerecord (3.1.0) lib/active_record/relation.rb:15:in `each' | |
| app/views/movies/index.html.haml:19:in `_app_views_movies_index_html_haml__141169675__643327708' | |
| actionpack (3.1.0) lib/action_view/template.rb:144:in `block in render' | |
| activesupport (3.1.0) lib/active_support/notifications.rb:55:in `instrument' | |
| actionpack (3.1.0) lib/action_view/template.rb:142:in `render' | |
| actionpack (3.1.0) lib/action_view/renderer/template_renderer.rb:40:in `block (2 levels) in render_template' | |
| actionpack (3.1.0) lib/action_view/renderer/abstract_renderer.rb:33:in `block in instrument' | |
| activesupport (3.1.0) lib/active_support/notifications.rb:53:in `block in instrument' | |
| activesupport (3.1.0) lib/active_support/notifications/instrumenter.rb:21:in `instrument' | |
| activesupport (3.1.0) lib/active_support/notifications.rb:53:in `instrument' | |
| actionpack (3.1.0) lib/action_view/renderer/abstract_renderer.rb:33:in `instrument' | |
| actionpack (3.1.0) lib/action_view/renderer/template_renderer.rb:39:in `block in render_template' | |
| actionpack (3.1.0) lib/action_view/renderer/template_renderer.rb:47:in `render_with_layout' | |
| actionpack (3.1.0) lib/action_view/renderer/template_renderer.rb:38:in `render_template' | |
| actionpack (3.1.0) lib/action_view/renderer/template_renderer.rb:12:in `block in render' | |
| actionpack (3.1.0) lib/action_view/renderer/abstract_renderer.rb:22:in `wrap_formats' | |
| actionpack (3.1.0) lib/action_view/renderer/template_renderer.rb:9:in `render' | |
| actionpack (3.1.0) lib/action_view/renderer/renderer.rb:36:in `render_template' | |
| actionpack (3.1.0) lib/action_view/renderer/renderer.rb:17:in `render' | |
| actionpack (3.1.0) lib/abstract_controller/rendering.rb:120:in `_render_template' | |
| actionpack (3.1.0) lib/action_controller/metal/streaming.rb:250:in `_render_template' | |
| actionpack (3.1.0) lib/abstract_controller/rendering.rb:114:in `render_to_body' | |
| actionpack (3.1.0) lib/action_controller/metal/renderers.rb:30:in `render_to_body' | |
| actionpack (3.1.0) lib/action_controller/metal/compatibility.rb:43:in `render_to_body' | |
| actionpack (3.1.0) lib/abstract_controller/rendering.rb:99:in `render' | |
| actionpack (3.1.0) lib/action_controller/metal/rendering.rb:16:in `render' | |
| actionpack (3.1.0) lib/action_controller/metal/instrumentation.rb:40:in `block (2 levels) in render' | |
| activesupport (3.1.0) lib/active_support/core_ext/benchmark.rb:5:in `block in ms' | |
| /usr/local/lib/ruby/1.9.1/benchmark.rb:310:in `realtime' | |
| activesupport (3.1.0) lib/active_support/core_ext/benchmark.rb:5:in `ms' | |
| actionpack (3.1.0) lib/action_controller/metal/instrumentation.rb:40:in `block in render' | |
| actionpack (3.1.0) lib/action_controller/metal/instrumentation.rb:78:in `cleanup_view_runtime' | |
| activerecord (3.1.0) lib/active_record/railties/controller_runtime.rb:24:in `cleanup_view_runtime' | |
| actionpack (3.1.0) lib/action_controller/metal/instrumentation.rb:39:in `render' | |
| actionpack (3.1.0) lib/action_controller/metal/implicit_render.rb:10:in `default_render' | |
| actionpack (3.1.0) lib/action_controller/metal/implicit_render.rb:5:in `send_action' | |
| actionpack (3.1.0) lib/abstract_controller/base.rb:167:in `process_action' | |
| actionpack (3.1.0) lib/action_controller/metal/rendering.rb:10:in `process_action' | |
| actionpack (3.1.0) lib/abstract_controller/callbacks.rb:18:in `block in process_action' | |
| activesupport (3.1.0) lib/active_support/callbacks.rb:416:in `_run__257052315__process_action__1068859328__callbacks' | |
| activesupport (3.1.0) lib/active_support/callbacks.rb:386:in `_run_process_action_callbacks' | |
| activesupport (3.1.0) lib/active_support/callbacks.rb:81:in `run_callbacks' | |
| actionpack (3.1.0) lib/abstract_controller/callbacks.rb:17:in `process_action' | |
| actionpack (3.1.0) lib/action_controller/metal/rescue.rb:17:in `process_action' | |
| actionpack (3.1.0) lib/action_controller/metal/instrumentation.rb:30:in `block in process_action' | |
| activesupport (3.1.0) lib/active_support/notifications.rb:53:in `block in instrument' | |
| activesupport (3.1.0) lib/active_support/notifications/instrumenter.rb:21:in `instrument' | |
| activesupport (3.1.0) lib/active_support/notifications.rb:53:in `instrument' | |
| actionpack (3.1.0) lib/action_controller/metal/instrumentation.rb:29:in `process_action' | |
| actionpack (3.1.0) lib/action_controller/metal/params_wrapper.rb:201:in `process_action' | |
| activerecord (3.1.0) lib/active_record/railties/controller_runtime.rb:18:in `process_action' | |
| actionpack (3.1.0) lib/abstract_controller/base.rb:121:in `process' | |
| actionpack (3.1.0) lib/abstract_controller/rendering.rb:45:in `process' | |
| actionpack (3.1.0) lib/action_controller/metal.rb:193:in `dispatch' | |
| actionpack (3.1.0) lib/action_controller/metal/rack_delegation.rb:14:in `dispatch' | |
| actionpack (3.1.0) lib/action_controller/metal.rb:236:in `block in action' | |
| actionpack (3.1.0) lib/action_dispatch/routing/route_set.rb:65:in `call' | |
| actionpack (3.1.0) lib/action_dispatch/routing/route_set.rb:65:in `dispatch' | |
| actionpack (3.1.0) lib/action_dispatch/routing/route_set.rb:29:in `call' | |
| rack-mount (0.8.3) lib/rack/mount/route_set.rb:152:in `block in call' | |
| rack-mount (0.8.3) lib/rack/mount/code_generation.rb:96:in `block in recognize' | |
| rack-mount (0.8.3) lib/rack/mount/code_generation.rb:75:in `optimized_each' | |
| rack-mount (0.8.3) lib/rack/mount/code_generation.rb:95:in `recognize' | |
| rack-mount (0.8.3) lib/rack/mount/route_set.rb:141:in `call' | |
| actionpack (3.1.0) lib/action_dispatch/routing/route_set.rb:531:in `call' | |
| actionpack (3.1.0) lib/action_dispatch/middleware/best_standards_support.rb:17:in `call' | |
| rack (1.3.5) lib/rack/etag.rb:23:in `call' | |
| rack (1.3.5) lib/rack/conditionalget.rb:25:in `call' | |
| actionpack (3.1.0) lib/action_dispatch/middleware/head.rb:14:in `call' | |
| actionpack (3.1.0) lib/action_dispatch/middleware/params_parser.rb:21:in `call' | |
| actionpack (3.1.0) lib/action_dispatch/middleware/flash.rb:243:in `call' | |
| rack (1.3.5) lib/rack/session/abstract/id.rb:195:in `context' | |
| rack (1.3.5) lib/rack/session/abstract/id.rb:190:in `call' | |
| actionpack (3.1.0) lib/action_dispatch/middleware/cookies.rb:326:in `call' | |
| activerecord (3.1.0) lib/active_record/query_cache.rb:62:in `call' | |
| activerecord (3.1.0) lib/active_record/connection_adapters/abstract/connection_pool.rb:477:in `call' | |
| actionpack (3.1.0) lib/action_dispatch/middleware/callbacks.rb:29:in `block in call' | |
| activesupport (3.1.0) lib/active_support/callbacks.rb:392:in `_run_call_callbacks' | |
| activesupport (3.1.0) lib/active_support/callbacks.rb:81:in `run_callbacks' | |
| actionpack (3.1.0) lib/action_dispatch/middleware/callbacks.rb:28:in `call' | |
| actionpack (3.1.0) lib/action_dispatch/middleware/reloader.rb:68:in `call' | |
| rack (1.3.5) lib/rack/sendfile.rb:101:in `call' | |
| actionpack (3.1.0) lib/action_dispatch/middleware/remote_ip.rb:48:in `call' | |
| actionpack (3.1.0) lib/action_dispatch/middleware/show_exceptions.rb:47:in `call' | |
| railties (3.1.0) lib/rails/rack/logger.rb:13:in `call' | |
| rack (1.3.5) lib/rack/methodoverride.rb:24:in `call' | |
| rack (1.3.5) lib/rack/runtime.rb:17:in `call' | |
| activesupport (3.1.0) lib/active_support/cache/strategy/local_cache.rb:72:in `call' | |
| rack (1.3.5) lib/rack/lock.rb:15:in `call' | |
| actionpack (3.1.0) lib/action_dispatch/middleware/static.rb:53:in `call' | |
| railties (3.1.0) lib/rails/engine.rb:455:in `call' | |
| railties (3.1.0) lib/rails/rack/content_length.rb:16:in `call' | |
| railties (3.1.0) lib/rails/rack/debugger.rb:21:in `call' | |
| railties (3.1.0) lib/rails/rack/log_tailer.rb:14:in `call' | |
| rack (1.3.5) lib/rack/handler/webrick.rb:59:in `service' | |
| /usr/local/lib/ruby/1.9.1/webrick/httpserver.rb:111:in `service' | |
| /usr/local/lib/ruby/1.9.1/webrick/httpserver.rb:70:in `run' | |
| /usr/local/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