View Question | Guruza | Fast Answers by Experts

Joe will pay $0.00 to the first person to successfully answer the question:

Hi, Rails causes WEBrick to GET 2 diff locations:
AWDWR Chpt 6 strange results:

First browser call to /Admin shows correct form; - And WEBrick reports:

"Get /admin HTTP/1.1" 200 485 - -> /admin

Subsequent browser calls to /Admin show:
NoMethodError in AdminController#index
undefined method `each' for #

- And WEBrick reports:

"Get /admin HTTP/1.1" 500 10767 - -> /admin

First browser call to /Admin/new shows correct form for editing; - And WEBrick reports:

"Get /admin/new HTTP/1.1" 200 10767 - -> /admin/new

Subsequent browswer calls to /Admin/new show:
NoMethodError in AdminController#new
undefined method `each' for #
RAILS_ROOT: ./script/../config/..

- And WEBrick reports:

"Get /admin/new HTTP/1.1" 500 9798 - -> /admin/new

So the first calls produce a "Get...200..." and the right browser results.
Subsequent calls produce a "Get...500..." and "NoMethodError"

Thanks for your help,
Joe

funded

Answer Joe's question

People succeed in answering Joe's questions 0% of the time (0 success in 2 attempts).

Counter Offer:

$5 | $6 | $7 | other:

Answers by: Rich Collins

Rich Collins's Answer:

Reply by Rich Collins 737 days ago

Can you post the admin controller?

Reply by Joe 737 days ago

Rich, Thanks for the response,

class AdminController < ApplicationController
def index
list
render :action => 'list'
end

def new
@product = Product.new
end
------
routes.rb
map.connect ':controller/service.wsdl', :action => 'wsdl'
map.connect ':controller/:action/:id'

Reply by Rich Collins 737 days ago

What does the list method look like?

Reply by Joe 736 days ago

def list
@product_pages, @products = paginate :products, :per_page => 10
end

Reply by Rich Collins 736 days ago

Perhaps the entire stack trace would help. If you indent it 4 lines when submitting the comment, it will show up as code. (or you can just put

 tags around it)



					
  
    Reply by Rich Collins 
    736 days ago
  
  sorry formatting got messed up.  You can put <pre><code> tags around it.

The preview button will show you what it looks like.


					
  
    Reply by Joe 
    736 days ago
  
  NoMethodError in AdminController#index 

undefined method `each' for #
RAILS_ROOT: ./script/../config/..

Application Trace | Framework Trace | Full Trace 

c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.3/lib/active_record/connection_adapters/mysql_adapter.rb:292:in `columns'

c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.3/lib/active_record/base.rb:696:in `columns'

c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.3/lib/active_record/calculations.rb:216:in `column_for'

c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.3/lib/active_record/calculations.rb:138:in `calculate'

c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.3/lib/active_record/calculations.rb:66:in `count'

c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.3/lib/action_controller/pagination.rb:172:in `count_collection_for_pagination'

c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.3/lib/action_controller/pagination.rb:196:in `paginator_and_collection_for'

c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.3/lib/action_controller/pagination.rb:129:in `paginate'

#{RAILS_ROOT}/app/controllers/admin_controller.rb:12:in `list'

#{RAILS_ROOT}/app/controllers/admin_controller.rb:3:in `index'

c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.3/lib/active_record/connection_adapters/mysql_adapter.rb:292:in `columns'

c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.3/lib/active_record/base.rb:696:in `columns'

c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.3/lib/active_record/calculations.rb:216:in `column_for'

c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.3/lib/active_record/calculations.rb:138:in `calculate'

c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.3/lib/active_record/calculations.rb:66:in `count'

c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.3/lib/action_controller/pagination.rb:172:in `count_collection_for_pagination'

c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.3/lib/action_controller/pagination.rb:196:in `paginator_and_collection_for'

c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.3/lib/action_controller/pagination.rb:129:in `paginate'

c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.3/lib/action_controller/base.rb:910:in `send'

c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.3/lib/action_controller/base.rb:910:in `perform_action_without_filters'

c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.3/lib/action_controller/filters.rb:368:in `perform_action_without_benchmark'

c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.3/lib/action_controller/benchmarking.rb:69:in `perform_action_without_rescue'

c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.3/lib/action_controller/benchmarking.rb:69:in `measure'

c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.3/lib/action_controller/benchmarking.rb:69:in `perform_action_without_rescue'

c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.3/lib/action_controller/rescue.rb:82:in `perform_action'

c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.3/lib/action_controller/base.rb:381:in `send'

c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.3/lib/action_controller/base.rb:381:in `process_without_filters'

c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.3/lib/action_controller/filters.rb:377:in `process_without_session_management_support'

c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.3/lib/action_controller/session_management.rb:117:in `process'

c:/ruby/lib/ruby/gems/1.8/gems/rails-1.1.4/lib/dispatcher.rb:38:in `dispatch'

c:/ruby/lib/ruby/gems/1.8/gems/rails-1.1.4/lib/webrick_server.rb:115:in `handle_dispatch'

c:/ruby/lib/ruby/gems/1.8/gems/rails-1.1.4/lib/webrick_server.rb:81:in `service'

c:/ruby/lib/ruby/1.8/webrick/httpserver.rb:104:in `service'

c:/ruby/lib/ruby/1.8/webrick/httpserver.rb:65:in `run'

c:/ruby/lib/ruby/1.8/webrick/server.rb:155:in `start_thread'

c:/ruby/lib/ruby/1.8/webrick/server.rb:144:in `start'

c:/ruby/lib/ruby/1.8/webrick/server.rb:144:in `start_thread'

c:/ruby/lib/ruby/1.8/webrick/server.rb:94:in `start'

c:/ruby/lib/ruby/1.8/webrick/server.rb:89:in `each'

c:/ruby/lib/ruby/1.8/webrick/server.rb:89:in `start'

c:/ruby/lib/ruby/1.8/webrick/server.rb:79:in `start'

c:/ruby/lib/ruby/1.8/webrick/server.rb:79:in `start'

c:/ruby/lib/ruby/gems/1.8/gems/rails-1.1.4/lib/webrick_server.rb:67:in `dispatch'

c:/ruby/lib/ruby/gems/1.8/gems/rails-1.1.4/lib/commands/servers/webrick.rb:59

c:/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:18:in `require__'

c:/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:18:in `require'

c:/ruby/lib/ruby/gems/1.8/gems/activesupport-1.3.1/lib/active_support/dependencies.rb:147:in `require'

c:/ruby/lib/ruby/gems/1.8/gems/rails-1.1.4/lib/commands/server.rb:30

c:/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:18:in `require__'

c:/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:18:in `require'

c:/ruby/lib/ruby/gems/1.8/gems/activesupport-1.3.1/lib/active_support/dependencies.rb:147:in `require'

script/server:3

c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.3/lib/active_record/connection_adapters/mysql_adapter.rb:292:in `columns'

c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.3/lib/active_record/base.rb:696:in `columns'

c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.3/lib/active_record/calculations.rb:216:in `column_for'

c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.3/lib/active_record/calculations.rb:138:in `calculate'

c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.3/lib/active_record/calculations.rb:66:in `count'

c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.3/lib/action_controller/pagination.rb:172:in `count_collection_for_pagination'

c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.3/lib/action_controller/pagination.rb:196:in `paginator_and_collection_for'

c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.3/lib/action_controller/pagination.rb:129:in `paginate'

#{RAILS_ROOT}/app/controllers/admin_controller.rb:12:in `list'

#{RAILS_ROOT}/app/controllers/admin_controller.rb:3:in `index'

c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.3/lib/action_controller/base.rb:910:in `send'

c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.3/lib/action_controller/base.rb:910:in `perform_action_without_filters'

c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.3/lib/action_controller/filters.rb:368:in `perform_action_without_benchmark'

c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.3/lib/action_controller/benchmarking.rb:69:in `perform_action_without_rescue'

c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.3/lib/action_controller/benchmarking.rb:69:in `measure'

c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.3/lib/action_controller/benchmarking.rb:69:in `perform_action_without_rescue'

c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.3/lib/action_controller/rescue.rb:82:in `perform_action'

c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.3/lib/action_controller/base.rb:381:in `send'

c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.3/lib/action_controller/base.rb:381:in `process_without_filters'

c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.3/lib/action_controller/filters.rb:377:in `process_without_session_management_support'

c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.3/lib/action_controller/session_management.rb:117:in `process'

c:/ruby/lib/ruby/gems/1.8/gems/rails-1.1.4/lib/dispatcher.rb:38:in `dispatch'

c:/ruby/lib/ruby/gems/1.8/gems/rails-1.1.4/lib/webrick_server.rb:115:in `handle_dispatch'

c:/ruby/lib/ruby/gems/1.8/gems/rails-1.1.4/lib/webrick_server.rb:81:in `service'

c:/ruby/lib/ruby/1.8/webrick/httpserver.rb:104:in `service'

c:/ruby/lib/ruby/1.8/webrick/httpserver.rb:65:in `run'

c:/ruby/lib/ruby/1.8/webrick/server.rb:155:in `start_thread'

c:/ruby/lib/ruby/1.8/webrick/server.rb:144:in `start'

c:/ruby/lib/ruby/1.8/webrick/server.rb:144:in `start_thread'

c:/ruby/lib/ruby/1.8/webrick/server.rb:94:in `start'

c:/ruby/lib/ruby/1.8/webrick/server.rb:89:in `each'

c:/ruby/lib/ruby/1.8/webrick/server.rb:89:in `start'

c:/ruby/lib/ruby/1.8/webrick/server.rb:79:in `start'

c:/ruby/lib/ruby/1.8/webrick/server.rb:79:in `start'

c:/ruby/lib/ruby/gems/1.8/gems/rails-1.1.4/lib/webrick_server.rb:67:in `dispatch'

c:/ruby/lib/ruby/gems/1.8/gems/rails-1.1.4/lib/commands/servers/webrick.rb:59

c:/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:18:in `require__'

c:/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:18:in `require'

c:/ruby/lib/ruby/gems/1.8/gems/activesupport-1.3.1/lib/active_support/dependencies.rb:147:in `require'

c:/ruby/lib/ruby/gems/1.8/gems/rails-1.1.4/lib/commands/server.rb:30

c:/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:18:in `require__'

c:/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:18:in `require'

c:/ruby/lib/ruby/gems/1.8/gems/activesupport-1.3.1/lib/active_support/dependencies.rb:147:in `require'

script/server:3

Request

Parameters: None

Show session dump

--- 

flash: !ruby/hash:ActionController::Flash::FlashHash {}

Response

Headers: {"cookie"=>[], "Cache-Control"=>"no-cache"}



					
  
    Reply by Rich Collins 
    736 days ago
  
  That is a low level MySQL adapter issue.  Can you do anything involving the database?


					
  
    Reply by Joe 
    736 days ago
  
  The database is MySQL verstion 5.0.24-com 

What do you suggest I do with it?