Beginner mysql problem involving Rake

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 (idint(11) DEFAULT NULL auto_increment PRIMARY KEY(11),namevarchar(255) DEFAULT NULL,addressvarchar(255) DEFAULT NULL,cityvarchar(255) DEFAULT NULL,statevarchar(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

Hi,

2008/4/30 Donald [email protected]:

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


Do you want a Google Mail invitation? Just write me an email!