# SQL Error

**URL:** <https://www.ruby-forum.com/t/sql-error/90079>\
**Category:** Ruby\
**Created:** [March 25, 2007, 9:31pm UTC](https://www.ruby-forum.com/t/sql-error/90079 "2007-03-25T21:31:07Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![donny24](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/b5ac83/32.png) [@donny24](https://www.ruby-forum.com/u/donny24)\
**Post date:** [March 25, 2007, 9:31pm UTC](https://www.ruby-forum.com/t/sql-error/90079/1 "2007-03-25T21:31:07Z")

</div>

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:in`execute’  
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:in`columns’  
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:in`initialize\_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:in`new’  
#{RAILS\_ROOT}/app/controllers/admin/author\_controller.rb:4:in `new’

---

<div class="post-metadata">

**Author:** ![donny24](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/b5ac83/32.png) [@donny24](https://www.ruby-forum.com/u/donny24)\
**Post date:** [March 27, 2007, 5:36pm UTC](https://www.ruby-forum.com/t/sql-error/90079/2 "2007-03-27T17:36:05Z")

</div>

On 3/25/07, donny24 [removed\_email\_address@domain.invalid](mailto: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](http://groups.google.com/group/rubyonrails-talk)

–  
Rick DeNatale

My blog on Ruby  
[http://talklikeaduck.denhaven2.com/](http://talklikeaduck.denhaven2.com/)

---

<div class="post-metadata">

**Author:** ![donny24](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/b5ac83/32.png) [@donny24](https://www.ruby-forum.com/u/donny24)\
**Post date:** [March 27, 2007, 5:46pm UTC](https://www.ruby-forum.com/t/sql-error/90079/3 "2007-03-27T17:46:06Z")

</div>

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