Beginner mysql problem involving Rake

rubyonrails-talk
#1

Hello, I'm new to rails and I'm trying to get a tutorial application
off the ground

when running rake migrate it errors with a mysql syntax error
response:

Mysql::Error: You have an error in your SQL syntax; check the manual
that corresponds to your MySQL server version for the right syntax to
use near '(11), `name` varchar(255) DEFAULT NULL, `address`
varchar(255) DEFAULT NULL, `ci' at line 1: CREATE TABLE people (`id`
int(11) DEFAULT NULL auto_increment PRIMARY KEY(11), `name`
varchar(255) DEFAULT NULL, `address` varchar(255) DEFAULT NULL, `city`
varchar(255) DEFAULT NULL, `state` varchar(255) DEFAULT NULL,
`zipcode` varchar(255) DEFAULT NULL) ENGINE=InnoDB

My db file is as follows:

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

I'm using a default mysql, apache, ruby, rails etc. install.

I noticed that It set the value of PRIMAY KEY to 11 and thought that
was kind of strange.
Anybody got any suggestions to get rake working right?

Thanks,
Donald

#2

Hi,

Mysql::Error: You have an error in your SQL syntax; check the manual
that corresponds to your MySQL server version for the right syntax to
use near '(11), `name` varchar(255) DEFAULT NULL, `address`

...

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

You must not create the id column in the migration. This is done
automatically. I guess that the SQL syntax error consists in two
columns named id.

Lutz