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