# Database setup fails

**URL:** <https://www.ruby-forum.com/t/database-setup-fails/75865>\
**Category:** Radiant CMS\
**Created:** [November 13, 2006, 10:30pm UTC](https://www.ruby-forum.com/t/database-setup-fails/75865 "2006-11-13T22:30:44Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![johnf](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/848f3c/32.png) [@johnf](https://www.ruby-forum.com/u/johnf)\
**Post date:** [November 13, 2006, 10:30pm UTC](https://www.ruby-forum.com/t/database-setup-fails/75865/1 "2006-11-13T22:30:44Z")

</div>

I saw this problem in the archives and was wondering if anyone ever  
resolved it.

I get this error after the /script/setup\_database production /command.

Server is running Ubuntu.

Thanks.

Creating tables…  
– drop\_table(“config”)  
– create\_table(“config”, {:force=\>true})  
FAILED  
/usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active\_record/connection\_adapters/abstract\_adapter.rb:120:in  
`log': Mysql::Error: Lost connection to MySQL server during query: CREATE TABLE config (`id`int(11) DEFAULT NULL auto_increment PRIMARY KEY,`key`varchar(40) DEFAULT '' NOT NULL,`value`varchar(255) DEFAULT '') ENGINE=InnoDB (ActiveRecord::StatementInvalid) from /usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/connection_adapters/mysql_adapter.rb:184:in`execute’  
from  
/usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active\_record/connection\_adapters/abstract/schema\_statements.rb:104:in  
`create_table' from /usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/connection_adapters/mysql_adapter.rb:297:in `create\_table’  
from  
/usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active\_record/migration.rb:273:in  
`method_missing' from /usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/migration.rb:257:in `say\_with\_time’  
from /usr/lib/ruby/1.8/benchmark.rb:293:in `measure' from /usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/migration.rb:257:in `say\_with\_time’  
from  
/usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active\_record/migration.rb:271:in  
`method_missing' from script/setup_database:104:in `create\_tables’  
from  
/usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active\_record/schema.rb:43:in  
`define' from script/setup_database:101:in `create\_tables’  
from script/setup\_database:258:in `announce' from script/setup_database:99:in `create\_tables’  
from script/setup\_database:19:in `run' from script/setup_database:9:in `run’  
from script/setup\_database:297

–

John F.  
Digital Systems and Services Coordinator  
MBLWHOI Library  
Woods Hole MA 02543 USA  
PHONE: 508-289-7435  
EMAIL: removed\_email\_address@domain.invalid  
[http://www.mblwhoilibrary.org](http://www.mblwhoilibrary.org)

---

<div class="post-metadata">

**Author:** ![johnf](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/848f3c/32.png) [@johnf](https://www.ruby-forum.com/u/johnf)\
**Post date:** [November 13, 2006, 11:10pm UTC](https://www.ruby-forum.com/t/database-setup-fails/75865/2 "2006-11-13T23:10:54Z")

</div>

I had the same problem and it was due to a bad install of the mysql gem.

Check out the thread at

[http://lists.radiantcms.org/pipermail/radiant/2006-October/002141.html](http://lists.radiantcms.org/pipermail/radiant/2006-October/002141.html)

jose.