SQL Error


#1

All,

I am getting an error when viewing localhost development of my Ruby
app. Has anyone seen anything similar to that below?

ActiveRecord::StatementInvalid in Admin/authorController#new
Mysql::Error: Lost connection to MySQL server during query: SHOW
FIELDS FROM authors
RAILS_ROOT: ./script/…/config/…

Application Trace | Framework Trace | Full Trace

C:/InstantRails/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/
active_record/connection_adapters/abstract_adapter.rb:120:in log' C:/InstantRails/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/ active_record/connection_adapters/mysql_adapter.rb:184:inexecute’
C:/InstantRails/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/
active_record/connection_adapters/mysql_adapter.rb:292:in columns' C:/InstantRails/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/ active_record/base.rb:696:incolumns’
C:/InstantRails/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/
active_record/base.rb:1969:in attributes_from_column_definition' C:/InstantRails/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/ active_record/base.rb:1351:ininitialize_without_callbacks’
C:/InstantRails/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/
active_record/callbacks.rb:236:in initialize' #{RAILS_ROOT}/app/controllers/admin/author_controller.rb:4:innew’
#{RAILS_ROOT}/app/controllers/admin/author_controller.rb:4:in `new’


#2

On 3/25/07, donny24 removed_email_address@domain.invalid wrote:

Mysql::Error: Lost connection to MySQL server during query: SHOW
FIELDS FROM authors
RAILS_ROOT: ./script/…/config/…

This is a rails question rather than a pure ruby one.

You’re probably more likely to get an answer in a rails related group:

http://groups.google.com/group/rubyonrails-talk


Rick DeNatale

My blog on Ruby
http://talklikeaduck.denhaven2.com/


#3

On 27.03.2007 17:35, Rick DeNatale wrote:

ActiveRecord::StatementInvalid in Admin/authorController#new
Mysql::Error: Lost connection to MySQL server during query: SHOW
FIELDS FROM authors
RAILS_ROOT: ./script/…/config/…

This is a rails question rather than a pure ruby one.

You’re probably more likely to get an answer in a rails related group:

I’m not sure. Maybe also a MySQL related group. It appears that the DB
connection was cut off for unknown reasons (timeout? network issues?).
I’d execute the query “SHOW FIELDS FROM authors” via MySQL’s client and
see what happens.

Kind regards

robert