thr3ads.net - Rails - [Rails] Action Controller: Exception caught [Apr 2006]

If this information is useful, please help other people find it:
Share via:

Fido Gesiwuj

2006-Apr-17 19:39 UTC

[Rails] Action Controller: Exception caught

Hi, I''m running the cookbook example from ONLamp.com. I have tried to 
test my site and it comes up with the the message  on the site:

 ActiveRecord::StatementInvalid in RecipeController#index

Mysql::Error: Lost connection to MySQL server during query: SHOW FIELDS 
FROM recipes

RAILS_ROOT: ./script/../config/..
Application Trace | Framework Trace | Full Trace

c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.2/lib/active_record/connection_adapters/abstract_adapter.rb:120:in
`log''
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.2/lib/active_record/connection_adapters/mysql_adapter.rb:185:in
`execute''
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.2/lib/active_record/connection_adapters/mysql_adapter.rb:293:in
`columns''
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.2/lib/active_record/base.rb:696:in
`columns''
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.2/lib/active_record/calculations.rb:213:in
`column_for''
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.2/lib/active_record/calculations.rb:135:in
`calculate''
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.2/lib/active_record/calculations.rb:64:in
`count''
c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.1/lib/action_controller/pagination.rb:172:in
`count_collection_for_pagination''
c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.1/lib/action_controller/pagination.rb:196:in
`paginator_and_collection_for''
c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.1/lib/action_controller/pagination.rb:129:in
`paginate''
c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.1/lib/action_controller/scaffolding.rb:109:in
`list''
c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.1/lib/action_controller/scaffolding.rb:97:in
`index''
c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.1/lib/action_controller/base.rb:910:in
`send''
c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.1/lib/action_controller/base.rb:910:in
`perform_action_without_filters''
c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.1/lib/action_controller/filters.rb:368:in
`perform_action_without_benchmark''
c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.1/lib/action_controller/benchmarking.rb:69:in
`perform_action_without_rescue''
c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.1/lib/action_controller/benchmarking.rb:69:in
`measure''
c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.1/lib/action_controller/benchmarking.rb:69:in
`perform_action_without_rescue''
c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.1/lib/action_controller/rescue.rb:82:in
`perform_action''
c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.1/lib/action_controller/base.rb:381:in
`send''
c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.1/lib/action_controller/base.rb:381:in
`process_without_filters''
c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.1/lib/action_controller/filters.rb:377:in
`process_without_session_management_support''
c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.1/lib/action_controller/session_management.rb:117:in
`process''
c:/ruby/lib/ruby/gems/1.8/gems/rails-1.1.2/lib/dispatcher.rb:38:in 
`dispatch''
c:/ruby/lib/ruby/gems/1.8/gems/rails-1.1.2/lib/webrick_server.rb:115:in 
`handle_dispatch''
c:/ruby/lib/ruby/gems/1.8/gems/rails-1.1.2/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.2/lib/webrick_server.rb:67:in 
`dispatch''
c:/ruby/lib/ruby/gems/1.8/gems/rails-1.1.2/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.2/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.2/lib/active_record/connection_adapters/abstract_adapter.rb:120:in
`log''
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.2/lib/active_record/connection_adapters/mysql_adapter.rb:185:in
`execute''
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.2/lib/active_record/connection_adapters/mysql_adapter.rb:293:in
`columns''
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.2/lib/active_record/base.rb:696:in
`columns''
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.2/lib/active_record/calculations.rb:213:in
`column_for''
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.2/lib/active_record/calculations.rb:135:in
`calculate''
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.2/lib/active_record/calculations.rb:64:in
`count''
c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.1/lib/action_controller/pagination.rb:172:in
`count_collection_for_pagination''
c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.1/lib/action_controller/pagination.rb:196:in
`paginator_and_collection_for''
c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.1/lib/action_controller/pagination.rb:129:in
`paginate''
c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.1/lib/action_controller/scaffolding.rb:109:in
`list''
c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.1/lib/action_controller/scaffolding.rb:97:in
`index''
c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.1/lib/action_controller/base.rb:910:in
`send''
c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.1/lib/action_controller/base.rb:910:in
`perform_action_without_filters''
c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.1/lib/action_controller/filters.rb:368:in
`perform_action_without_benchmark''
c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.1/lib/action_controller/benchmarking.rb:69:in
`perform_action_without_rescue''
c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.1/lib/action_controller/benchmarking.rb:69:in
`measure''
c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.1/lib/action_controller/benchmarking.rb:69:in
`perform_action_without_rescue''
c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.1/lib/action_controller/rescue.rb:82:in
`perform_action''
c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.1/lib/action_controller/base.rb:381:in
`send''
c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.1/lib/action_controller/base.rb:381:in
`process_without_filters''
c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.1/lib/action_controller/filters.rb:377:in
`process_without_session_management_support''
c:/ruby/lib/ruby/gems/1.8/gems/actionpack-1.12.1/lib/action_controller/session_management.rb:117:in
`process''
c:/ruby/lib/ruby/gems/1.8/gems/rails-1.1.2/lib/dispatcher.rb:38:in 
`dispatch''
c:/ruby/lib/ruby/gems/1.8/gems/rails-1.1.2/lib/webrick_server.rb:115:in 
`handle_dispatch''
c:/ruby/lib/ruby/gems/1.8/gems/rails-1.1.2/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.2/lib/webrick_server.rb:67:in 
`dispatch''
c:/ruby/lib/ruby/gems/1.8/gems/rails-1.1.2/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.2/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"}

Anyone got any ideas how to fix this? I have tried restarting the server 
but that doesnt work.

-- 
Posted via http://www.ruby-forum.com/.

Bryan Duxbury

2006-Apr-17 20:57 UTC

head link

[Rails] Re: Action Controller: Exception caught

Fido Gesiwuj wrote:
>  ActiveRecord::StatementInvalid in RecipeController#index
> 
> Mysql::Error: Lost connection to MySQL server during query: SHOW FIELDS 
> FROM recipes
> 
Get the native mysql drivers for your Windows machine at:
http://www.vandomburg.net/pages/mysql-ruby-windows

That fixed it for me on my XP boxes. If you''re using 2k, by any chance,
I still haven''t been able to fix that.

-- 
Posted via http://www.ruby-forum.com/.

Fido Gesiwuj

2006-Apr-18 11:02 UTC

head link

[Rails] Re: Action Controller: Exception caught

Does it matter that I''m connecting to a computer from my paid host? I 
have changed the config.yml thing.

-- 
Posted via http://www.ruby-forum.com/.

Fido Gesiwuj

2006-Apr-18 11:18 UTC

head link

[Rails] Re: Action Controller: Exception caught

Oh, now it has another message:

 Mysql::Error in RecipeController#index

Access denied for user
''gesnet''@''82.163.144.137'' to database
''cookbook''

-- 
Posted via http://www.ruby-forum.com/.

Bryan Duxbury

2006-Apr-18 12:38 UTC

head link

[Rails] Re: Action Controller: Exception caught

Fido Gesiwuj wrote:> Oh, now it has another message:
> 
>  Mysql::Error in RecipeController#index
> 
> Access denied for user
''gesnet''@''82.163.144.137'' to database
''cookbook''
Looks like now you need to set up permissions or lower your firewall on 
your db server.

-- 
Posted via http://www.ruby-forum.com/.

Fido Gesiwuj

2006-Apr-18 20:24 UTC

head link

[Rails] Re: Action Controller: Exception caught

> Looks like now you need to set up permissions or lower your firewall on 
> your db server.
I''ve set the database up to accept connections from my IP (although I 
guess that my router''s firewall will be something to do with this).


-- 
Posted via http://www.ruby-forum.com/.

Bryan Duxbury

2006-Apr-18 21:32 UTC

head link

[Rails] Re: Action Controller: Exception caught

Fido Gesiwuj wrote:>> Looks like now you need to set up permissions or lower your firewall on
>> your db server.
> 
> I''ve set the database up to accept connections from my IP
(although I
> guess that my router''s firewall will be something to do with
this).
You have to grant privileges to the user you want to access the server 
at that ip, or at least at ''%''. If you don''t do that,
mysql will tell
you that you''re not authorized.

-- 
Posted via http://www.ruby-forum.com/.

Roderick van Domburg

2006-Apr-22 11:08 UTC

head link

[Rails] Re: Action Controller: Exception caught

Bryan Duxbury wrote:> Get the native mysql drivers for your Windows machine at:
> http://www.vandomburg.net/pages/mysql-ruby-windows
> 
> That fixed it for me on my XP boxes. If you''re using 2k, by any
chance,
> I still haven''t been able to fix that.
I''m the maintainer of that distribution and am currently investigating 
the segfaults on Windows 2000. If you''re interested in testing out a 
release that should fix that, drop me a note.

- Roderick van Domburg
http://www.vandomburg.net

-- 
Posted via http://www.ruby-forum.com/.

Possibly Parallel Threads

Search for more maybe matching threads

Rails - Apr 2006 - Action Controller: Exception caught

[Rails] Action Controller: Exception caught

[Rails] Re: Action Controller: Exception caught

[Rails] Re: Action Controller: Exception caught

[Rails] Re: Action Controller: Exception caught

[Rails] Re: Action Controller: Exception caught

[Rails] Re: Action Controller: Exception caught

[Rails] Re: Action Controller: Exception caught

[Rails] Re: Action Controller: Exception caught

Possibly Parallel Threads