Database setup fails

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 (idint(11) DEFAULT NULL auto_increment PRIMARY KEY,keyvarchar(40) DEFAULT '' NOT NULL,valuevarchar(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:inexecute’
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: [email protected]
http://www.mblwhoilibrary.org

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

jose.