Failed to run migration

Rails
1

i have a migration but after running it (rake db:migrate),it created
a table “posts” but couldn’t create columns.

class CreatePosts < ActiveRecord::Migration
def self.up
create_table :posts do |t|
t.string :name
t.string :title
t.text :content
t.timestamps
end
end
def self.down
drop_table :posts
end
end

Please help!!

John

2

On 24 May 2011 07:25, John shelfer [email protected] wrote:

end
end
def self.down
drop_table :posts
end
end

What was the output when you ran the migration? Are you sure that the
table did not already exist when you ran the migration, so that it
failed because it could not create the table?

If this is a new database, so there are no other tables in it then I
suggest you delete the whole database, recreate the database (with no
tables) and run the migration again. Note carefully what it says when
you run the migration.

Colin

3

On Tue, May 24, 2011 at 2:43 AM, Colin L. [email protected]
wrote:

 t.timestamps
end

end
def self.down
drop_table :posts
end
end

What was the output when you ran the migration? Are you sure that the
table did not already exist

  I was not sure.

when you ran the migration, so that it
failed because it could not create the table?

If this is a new database, so there are no other tables in it then I
suggest you delete the whole database, recreate the database (with no
tables) and run the migration again.

  Well i did exactly ,now it works .Great Colin.Thank you very
  much.
  Can you explain why in previous case,after running migration i
   couldn't add the
  columns in table ?

 John
4

On Tue, May 24, 2011 at 3:08 AM, amritpal pathak
[email protected]wrote:

create_table :posts do |t|

tables) and run the migration again.

  It is too my account.Sorry for sending from other one.

 Well i did exactly ,now it works .Great Colin.Thank you very
  much.
  Can you explain why in previous case,after running migration i
   couldn't add the
  columns in table ?

 John
5

On Tue, May 24, 2011 at 3:35 AM, amritpal pathak

6

On Tue, May 24, 2011 at 12:08 AM, amritpal pathak
[email protected] wrote:

Can you explain why in previous case,after running migration i
couldn’t add the columns in table ?

You can’t “create” a table that already exists, you can only modify or
delete it.

As I suggested before, reading the documentation on migrations –
class ActiveRecord::Migration – would be a very good idea.

And if you’re in doubt about the state of your db/tables before or after
running a migration, I’d suggest you look. That’s part of the job.

–
Hassan S. ------------------------ [email protected]

twitter: @hassan