Ticket #54 (closed defect: fixed)

Opened 1 year ago

Last modified 1 year ago

Exception on books/list

Reported by: cstrom Assigned to:
Priority: critical Milestone: 0.11
Keywords: Cc:

Description

Ick. Need to backport to 0.10.

 ActiveRecord::StatementInvalid in Books#index

Showing books/list.rhtml where line #35 raised:

SQLite3::SQLException: no such table: recipe_books: SELECT recipes.* FROM recipes  INNER JOIN recipe_books ON recipes.id = recipe_books.recipe_id    WHERE ((recipe_books.book_id = 1)) 

Extracted source (around line #35):

32: </div>
33: </div>
34: 
35: <% if !book.recipes.empty? %>
36: <p style="margin-top: 0px; margin-bottom: 0px;"><i>Inspired by this book:</i></p>
37: <ul style="margin-top: 0px;">
38:   <% book.recipes.each do |recipe| -%>

RAILS_ROOT: /home/cstrom/rr/eee
Application Trace | Framework Trace | Full Trace

vendor/rails/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:150:in `log'
vendor/rails/activerecord/lib/active_record/connection_adapters/sqlite_adapter.rb:132:in `execute'
vendor/rails/activerecord/lib/active_record/connection_adapters/sqlite_adapter.rb:345:in `catch_schema_changes'
vendor/rails/activerecord/lib/active_record/connection_adapters/sqlite_adapter.rb:132:in `execute'
vendor/rails/activerecord/lib/active_record/connection_adapters/sqlite_adapter.rb:256:in `select'
vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:7:in `select_all_without_query_cache'
vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/query_cache.rb:53:in `select_all'
vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/query_cache.rb:74:in `cache_sql'
vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/query_cache.rb:53:in `select_all'
vendor/rails/activerecord/lib/active_record/base.rb:447:in `find_by_sql'
vendor/rails/activerecord/lib/active_record/base.rb:1035:in `find_every'
vendor/rails/activerecord/lib/active_record/base.rb:438:in `find'
vendor/rails/activerecord/lib/active_record/associations/has_many_through_association.rb:140:in `find_target'
vendor/rails/activerecord/lib/active_record/associations/association_proxy.rb:132:in `load_target'
vendor/rails/activerecord/lib/active_record/associations/association_proxy.rb:123:in `method_missing'
vendor/rails/activerecord/lib/active_record/associations/has_many_through_association.rb:133:in `method_missing_without_paginate'
vendor/plugins/will_paginate/lib/will_paginate/finder.rb:85:in `method_missing'
app/views/books/list.rhtml:35:in `_run_rhtml_47app47views47books47list46rhtml'
app/views/books/list.rhtml:21:in `each'
app/views/books/list.rhtml:21:in `_run_rhtml_47app47views47books47list46rhtml'
app/views/books/list.rhtml:19:in `each'
app/views/books/list.rhtml:19:in `each_slice'
app/views/books/list.rhtml:19:in `_run_rhtml_47app47views47books47list46rhtml'
app/controllers/books_controller.rb:32:in `index'
/var/lib/gems/1.8/gems/mongrel-1.0.1/lib/mongrel/rails.rb:78:in `process'
/var/lib/gems/1.8/gems/mongrel-1.0.1/lib/mongrel/rails.rb:76:in `synchronize'
/var/lib/gems/1.8/gems/mongrel-1.0.1/lib/mongrel/rails.rb:76:in `process'
/var/lib/gems/1.8/gems/mongrel-1.0.1/lib/mongrel.rb:618:in `process_client'
/var/lib/gems/1.8/gems/mongrel-1.0.1/lib/mongrel.rb:617:in `each'
/var/lib/gems/1.8/gems/mongrel-1.0.1/lib/mongrel.rb:617:in `process_client'
/var/lib/gems/1.8/gems/mongrel-1.0.1/lib/mongrel.rb:736:in `run'
/var/lib/gems/1.8/gems/mongrel-1.0.1/lib/mongrel.rb:736:in `initialize'
/var/lib/gems/1.8/gems/mongrel-1.0.1/lib/mongrel.rb:736:in `new'
/var/lib/gems/1.8/gems/mongrel-1.0.1/lib/mongrel.rb:736:in `run'
/var/lib/gems/1.8/gems/mongrel-1.0.1/lib/mongrel.rb:720:in `initialize'
/var/lib/gems/1.8/gems/mongrel-1.0.1/lib/mongrel.rb:720:in `new'
/var/lib/gems/1.8/gems/mongrel-1.0.1/lib/mongrel.rb:720:in `run'
/var/lib/gems/1.8/gems/mongrel-1.0.1/lib/mongrel/configurator.rb:271:in `run'
/var/lib/gems/1.8/gems/mongrel-1.0.1/lib/mongrel/configurator.rb:270:in `each'
/var/lib/gems/1.8/gems/mongrel-1.0.1/lib/mongrel/configurator.rb:270:in `run'
/var/lib/gems/1.8/gems/mongrel-1.0.1/bin/mongrel_rails:127:in `run'
/var/lib/gems/1.8/gems/mongrel-1.0.1/lib/mongrel/command.rb:211:in `run'
/var/lib/gems/1.8/gems/mongrel-1.0.1/bin/mongrel_rails:243

vendor/rails/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:150:in `log'
vendor/rails/activerecord/lib/active_record/connection_adapters/sqlite_adapter.rb:132:in `execute'
vendor/rails/activerecord/lib/active_record/connection_adapters/sqlite_adapter.rb:345:in `catch_schema_changes'
vendor/rails/activerecord/lib/active_record/connection_adapters/sqlite_adapter.rb:132:in `execute'
vendor/rails/activerecord/lib/active_record/connection_adapters/sqlite_adapter.rb:256:in `select'
vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:7:in `select_all_without_query_cache'
vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/query_cache.rb:53:in `select_all'
vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/query_cache.rb:74:in `cache_sql'
vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/query_cache.rb:53:in `select_all'
vendor/rails/activerecord/lib/active_record/base.rb:447:in `find_by_sql'
vendor/rails/activerecord/lib/active_record/base.rb:1035:in `find_every'
vendor/rails/activerecord/lib/active_record/base.rb:438:in `find'
vendor/rails/activerecord/lib/active_record/associations/has_many_through_association.rb:140:in `find_target'
vendor/rails/activerecord/lib/active_record/associations/association_proxy.rb:132:in `load_target'
vendor/rails/activerecord/lib/active_record/associations/association_proxy.rb:123:in `method_missing'
vendor/rails/activerecord/lib/active_record/associations/has_many_through_association.rb:133:in `method_missing_without_paginate'
vendor/plugins/will_paginate/lib/will_paginate/finder.rb:85:in `method_missing'
vendor/rails/actionpack/lib/action_view/base.rb:679:in `each_slice'
vendor/rails/actionpack/lib/action_view/base.rb:390:in `send'
vendor/rails/actionpack/lib/action_view/base.rb:390:in `compile_and_render_template'
vendor/rails/actionpack/lib/action_view/base.rb:366:in `render_template'
vendor/rails/actionpack/lib/action_view/base.rb:316:in `render_file'
vendor/rails/actionpack/lib/action_controller/base.rb:1109:in `render_for_file'
vendor/rails/actionpack/lib/action_controller/base.rb:858:in `render_with_no_layout'
vendor/rails/actionpack/lib/action_controller/base.rb:872:in `render_with_no_layout'
vendor/rails/actionpack/lib/action_controller/layout.rb:261:in `render_without_benchmark'
vendor/rails/actionpack/lib/action_controller/benchmarking.rb:51:in `footnotes_original_render'
/usr/lib/ruby/1.8/benchmark.rb:293:in `measure'
vendor/rails/actionpack/lib/action_controller/benchmarking.rb:51:in `footnotes_original_render'
vendor/plugins/footnotes-edge/lib/textmate_initialize.rb:12:in `render'
vendor/rails/actionpack/lib/action_controller/base.rb:1167:in `send'
vendor/rails/actionpack/lib/action_controller/base.rb:1167:in `perform_action_without_filters'
vendor/rails/actionpack/lib/action_controller/filters.rb:697:in `call_filters'
vendor/rails/actionpack/lib/action_controller/filters.rb:689:in `perform_action_without_benchmark'
vendor/rails/actionpack/lib/action_controller/benchmarking.rb:68:in `perform_action_without_rescue'
/usr/lib/ruby/1.8/benchmark.rb:293:in `measure'
vendor/rails/actionpack/lib/action_controller/benchmarking.rb:68:in `perform_action_without_rescue'
vendor/rails/actionpack/lib/action_controller/rescue.rb:199:in `perform_action_without_caching'
vendor/rails/actionpack/lib/action_controller/caching.rb:669:in `perform_action'
vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/query_cache.rb:33:in `cache'
vendor/rails/activerecord/lib/active_record/query_cache.rb:8:in `cache'
vendor/rails/actionpack/lib/action_controller/caching.rb:668:in `perform_action'
vendor/rails/actionpack/lib/action_controller/base.rb:524:in `send'
vendor/rails/actionpack/lib/action_controller/base.rb:524:in `process_without_filters'
vendor/rails/actionpack/lib/action_controller/filters.rb:685:in `process_without_session_management_support'
vendor/rails/actionpack/lib/action_controller/session_management.rb:123:in `process'
vendor/rails/actionpack/lib/action_controller/base.rb:388:in `process'
vendor/rails/actionpack/lib/action_controller/dispatcher.rb:171:in `handle_request'
vendor/rails/actionpack/lib/action_controller/dispatcher.rb:115:in `dispatch'
vendor/rails/actionpack/lib/action_controller/dispatcher.rb:126:in `dispatch_cgi'
vendor/rails/actionpack/lib/action_controller/dispatcher.rb:9:in `dispatch'
vendor/rails/activesupport/lib/active_support/dependencies.rb:489:in `load'
vendor/rails/activesupport/lib/active_support/dependencies.rb:489:in `load'
vendor/rails/activesupport/lib/active_support/dependencies.rb:342:in `new_constants_in'
vendor/rails/activesupport/lib/active_support/dependencies.rb:489:in `load'
vendor/rails/railties/lib/commands/servers/mongrel.rb:64
/usr/lib/ruby/1.8/rubygems/custom_require.rb:27:in `gem_original_require'
/usr/lib/ruby/1.8/rubygems/custom_require.rb:27:in `require'
vendor/rails/activesupport/lib/active_support/dependencies.rb:496:in `require'
vendor/rails/activesupport/lib/active_support/dependencies.rb:342:in `new_constants_in'
vendor/rails/activesupport/lib/active_support/dependencies.rb:496:in `require'
vendor/rails/railties/lib/commands/server.rb:39
script/server:3:in `require'
script/server:3

vendor/rails/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:150:in `log'
vendor/rails/activerecord/lib/active_record/connection_adapters/sqlite_adapter.rb:132:in `execute'
vendor/rails/activerecord/lib/active_record/connection_adapters/sqlite_adapter.rb:345:in `catch_schema_changes'
vendor/rails/activerecord/lib/active_record/connection_adapters/sqlite_adapter.rb:132:in `execute'
vendor/rails/activerecord/lib/active_record/connection_adapters/sqlite_adapter.rb:256:in `select'
vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:7:in `select_all_without_query_cache'
vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/query_cache.rb:53:in `select_all'
vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/query_cache.rb:74:in `cache_sql'
vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/query_cache.rb:53:in `select_all'
vendor/rails/activerecord/lib/active_record/base.rb:447:in `find_by_sql'
vendor/rails/activerecord/lib/active_record/base.rb:1035:in `find_every'
vendor/rails/activerecord/lib/active_record/base.rb:438:in `find'
vendor/rails/activerecord/lib/active_record/associations/has_many_through_association.rb:140:in `find_target'
vendor/rails/activerecord/lib/active_record/associations/association_proxy.rb:132:in `load_target'
vendor/rails/activerecord/lib/active_record/associations/association_proxy.rb:123:in `method_missing'
vendor/rails/activerecord/lib/active_record/associations/has_many_through_association.rb:133:in `method_missing_without_paginate'
vendor/plugins/will_paginate/lib/will_paginate/finder.rb:85:in `method_missing'
app/views/books/list.rhtml:35:in `_run_rhtml_47app47views47books47list46rhtml'
app/views/books/list.rhtml:21:in `each'
app/views/books/list.rhtml:21:in `_run_rhtml_47app47views47books47list46rhtml'
vendor/rails/actionpack/lib/action_view/base.rb:679:in `each_slice'
app/views/books/list.rhtml:19:in `each'
app/views/books/list.rhtml:19:in `each_slice'
app/views/books/list.rhtml:19:in `_run_rhtml_47app47views47books47list46rhtml'
vendor/rails/actionpack/lib/action_view/base.rb:390:in `send'
vendor/rails/actionpack/lib/action_view/base.rb:390:in `compile_and_render_template'
vendor/rails/actionpack/lib/action_view/base.rb:366:in `render_template'
vendor/rails/actionpack/lib/action_view/base.rb:316:in `render_file'
vendor/rails/actionpack/lib/action_controller/base.rb:1109:in `render_for_file'
vendor/rails/actionpack/lib/action_controller/base.rb:858:in `render_with_no_layout'
vendor/rails/actionpack/lib/action_controller/base.rb:872:in `render_with_no_layout'
vendor/rails/actionpack/lib/action_controller/layout.rb:261:in `render_without_benchmark'
vendor/rails/actionpack/lib/action_controller/benchmarking.rb:51:in `footnotes_original_render'
/usr/lib/ruby/1.8/benchmark.rb:293:in `measure'
vendor/rails/actionpack/lib/action_controller/benchmarking.rb:51:in `footnotes_original_render'
vendor/plugins/footnotes-edge/lib/textmate_initialize.rb:12:in `render'
app/controllers/books_controller.rb:32:in `index'
vendor/rails/actionpack/lib/action_controller/base.rb:1167:in `send'
vendor/rails/actionpack/lib/action_controller/base.rb:1167:in `perform_action_without_filters'
vendor/rails/actionpack/lib/action_controller/filters.rb:697:in `call_filters'
vendor/rails/actionpack/lib/action_controller/filters.rb:689:in `perform_action_without_benchmark'
vendor/rails/actionpack/lib/action_controller/benchmarking.rb:68:in `perform_action_without_rescue'
/usr/lib/ruby/1.8/benchmark.rb:293:in `measure'
vendor/rails/actionpack/lib/action_controller/benchmarking.rb:68:in `perform_action_without_rescue'
vendor/rails/actionpack/lib/action_controller/rescue.rb:199:in `perform_action_without_caching'
vendor/rails/actionpack/lib/action_controller/caching.rb:669:in `perform_action'
vendor/rails/activerecord/lib/active_record/connection_adapters/abstract/query_cache.rb:33:in `cache'
vendor/rails/activerecord/lib/active_record/query_cache.rb:8:in `cache'
vendor/rails/actionpack/lib/action_controller/caching.rb:668:in `perform_action'
vendor/rails/actionpack/lib/action_controller/base.rb:524:in `send'
vendor/rails/actionpack/lib/action_controller/base.rb:524:in `process_without_filters'
vendor/rails/actionpack/lib/action_controller/filters.rb:685:in `process_without_session_management_support'
vendor/rails/actionpack/lib/action_controller/session_management.rb:123:in `process'
vendor/rails/actionpack/lib/action_controller/base.rb:388:in `process'
vendor/rails/actionpack/lib/action_controller/dispatcher.rb:171:in `handle_request'
vendor/rails/actionpack/lib/action_controller/dispatcher.rb:115:in `dispatch'
vendor/rails/actionpack/lib/action_controller/dispatcher.rb:126:in `dispatch_cgi'
vendor/rails/actionpack/lib/action_controller/dispatcher.rb:9:in `dispatch'
/var/lib/gems/1.8/gems/mongrel-1.0.1/lib/mongrel/rails.rb:78:in `process'
/var/lib/gems/1.8/gems/mongrel-1.0.1/lib/mongrel/rails.rb:76:in `synchronize'
/var/lib/gems/1.8/gems/mongrel-1.0.1/lib/mongrel/rails.rb:76:in `process'
/var/lib/gems/1.8/gems/mongrel-1.0.1/lib/mongrel.rb:618:in `process_client'
/var/lib/gems/1.8/gems/mongrel-1.0.1/lib/mongrel.rb:617:in `each'
/var/lib/gems/1.8/gems/mongrel-1.0.1/lib/mongrel.rb:617:in `process_client'
/var/lib/gems/1.8/gems/mongrel-1.0.1/lib/mongrel.rb:736:in `run'
/var/lib/gems/1.8/gems/mongrel-1.0.1/lib/mongrel.rb:736:in `initialize'
/var/lib/gems/1.8/gems/mongrel-1.0.1/lib/mongrel.rb:736:in `new'
/var/lib/gems/1.8/gems/mongrel-1.0.1/lib/mongrel.rb:736:in `run'
/var/lib/gems/1.8/gems/mongrel-1.0.1/lib/mongrel.rb:720:in `initialize'
/var/lib/gems/1.8/gems/mongrel-1.0.1/lib/mongrel.rb:720:in `new'
/var/lib/gems/1.8/gems/mongrel-1.0.1/lib/mongrel.rb:720:in `run'
/var/lib/gems/1.8/gems/mongrel-1.0.1/lib/mongrel/configurator.rb:271:in `run'
/var/lib/gems/1.8/gems/mongrel-1.0.1/lib/mongrel/configurator.rb:270:in `each'
/var/lib/gems/1.8/gems/mongrel-1.0.1/lib/mongrel/configurator.rb:270:in `run'
/var/lib/gems/1.8/gems/mongrel-1.0.1/bin/mongrel_rails:127:in `run'
/var/lib/gems/1.8/gems/mongrel-1.0.1/lib/mongrel/command.rb:211:in `run'
/var/lib/gems/1.8/gems/mongrel-1.0.1/bin/mongrel_rails:243
vendor/rails/activesupport/lib/active_support/dependencies.rb:489:in `load'
vendor/rails/activesupport/lib/active_support/dependencies.rb:489:in `load'
vendor/rails/activesupport/lib/active_support/dependencies.rb:342:in `new_constants_in'
vendor/rails/activesupport/lib/active_support/dependencies.rb:489:in `load'
vendor/rails/railties/lib/commands/servers/mongrel.rb:64
/usr/lib/ruby/1.8/rubygems/custom_require.rb:27:in `gem_original_require'
/usr/lib/ruby/1.8/rubygems/custom_require.rb:27:in `require'
vendor/rails/activesupport/lib/active_support/dependencies.rb:496:in `require'
vendor/rails/activesupport/lib/active_support/dependencies.rb:342:in `new_constants_in'
vendor/rails/activesupport/lib/active_support/dependencies.rb:496:in `require'
vendor/rails/railties/lib/commands/server.rb:39
script/server:3:in `require'
script/server:3

Request

Parameters:

None

Change History

12/04/07 19:39:42 changed by cstrom

  • status changed from new to closed.
  • resolution set to fixed.

(In [234]) Forgot to update recipe association in Book to go through RecipeInspiration?.

Fixes #54

12/04/07 19:42:52 changed by cstrom

(In [235]) Backport association fix (r234) from trunk to 0.10. References #54