rake test fails on MySQL error

rubyonrails-talk
1

What version of MySQL are you using? Does it support the ENGINE=InnoDB syntax (I think the syntax prior to 5.x was TYPE=InnoDB)?

-Rob

Rob Biedenharn http://agileconsultingllc.com Rob@AgileConsultingLLC.com

2

Hey, I found an old migration in an old project:

class CreateUsersTable < ActiveRecord::Migration

def self.up

create_table(:users,

             **:options => 'TYPE=InnoDB'**) do |t| #  DEFAULT CHARSET=utf8

t.column :first_name, :string, :limit => 30, :null => false

t.column :last_name, :string, :limit => 30, :null => false

t.column :department, :string

t.column :phone, :string, :limit => 24

end

end

def self.down

drop_table(:users)

end

end

This was when the default was MyIsam and might have also been with 4.x (like I said, it was old), but the server was running 3.23 so I think that’s how I landed on this syntax.

-Rob

Rob Biedenharn http://agileconsultingllc.com

Rob@AgileConsultingLLC.com