Beginner mysql problem

rubyonrails-talk
1

I am new to rails and have come across a problem with a sample application I was working on. When trying to use rake migrate I got the error listed below.

my db file contains the following

class ContactDb < ActiveRecord::Migration   def self.up           create_table "people" do |t|                   t.column "id", :integer                   t.column "name", :string                   t.column "address", :string                   t.column "city", :string                   t.column "state", :string                   t.column "zipcode", :string           end   end

  def self.down           drop_table :people   end end

and the error is:

== ContactDb: migrating

2

Rails adds an id field for you, unless you tell it not to. So leave yours out.

Also, you might check out the new column syntax for use with create_table. You can do less now:

t.integer :name

for example.

3

try it without id

4

It worked. Thanks!

But out of curiosity what was wrong with the original setup?

Does rails not support the addition of an id field without explicitly telling it not to add its own, or is there something else going wrong?

thanks again

5

Try leaving out the spec for the id column--rails will add that for you.

Also--I don't know if it matters (probably doesn't) but if you're using the current version of rails, there's a new syntax for migrations. Here's my create_people, FWIW:

class CreatePeople < ActiveRecord::Migration   def self.up     create_table :people do |t|       t.string :first_name, :null => false       t.string :last_name, :null => false       t.integer :organization_id       t.string :personal_url       t.string :voice_number       t.string :cell_number       t.string :email_address, :null => false       t.date :birth_date       t.text :notes     end     execute("alter table people add constraint fk_organizations foreign key (organization_id) references organizations (id)")   end

  def self.down     drop_table :people   end end

HTH,

-Roy