Add to migration not working (Rails 2.0.2)

Rails
1

Hi there,

I just generated a migration to add a column to a table, and the change
didn’t seem to take. I did:

script/generate migration add_starts_at_to_gameweek starts_at:datetime

which generated the file, no problem. I then ran:

rake db:migrate

and the migration didn’t happen. The table is still without a
“starts_at” column. Where should I start looking for mistakes?

Dave

2

I just tried the exact same and it worked for me, i wonder if ur
schema/db is in a bad state. Try:-

rake db:migrate:reset

Then try running the migrations again.

3

Yes, that worked, though it wiped the contents of my db, as well. No
biggie, though. Thanks!

Jabbslad wrote:

I just tried the exact same and it worked for me, i wonder if ur
schema/db is in a bad state. Try:-

rake db:migrate:reset

Then try running the migrations again.

4

Ah sorry should have mentioned that :wink:

“rake db:migrate:redo” might have done the trick and still kept the
data in ur db.

Have a glance at some of the rake tasks for your project (rake -T).
theres loads of them that should help if u ever have the prob again :slight_smile:

Glad prob is solved now though.

Jabbslad

On Feb 28, 7:47 pm, Dave A. [email protected]

5

I’m experiencing the same issue. script/generate migration is stubbing
the migration, minus the column info that i’m specifying. Here’s what
I did in the Terminal:

$ ruby script/generate migration AddPrimaryPlatformInfo os:string
hardware:string
exists db/migrate
create db/migrate/005_add_primary_platform_info.rb

My 005_add_primary_platform_info.rb file then has:

class AddPrimaryPlatformInfo < ActiveRecord::Migration
def self.up
end

def self.down
end
end

I can add it manually, but shouldn’t we have some add_column and
remove_column goodness added here already?

Tried rake:db:redo and rake:db:reset - neither helped. Any suggestions
from this point on would be greatly appreciated.

Cheers,
Joe

6

On Fri, 2008-04-11 at 22:09 -0700, Joe L. wrote:

class AddPrimaryPlatformInfo < ActiveRecord::Migration
def self.up
end

def self.down
end
end

if you did…

script/generate model SomeNewModel

you would get the base ‘add table/column’ stuff inserted

Craig

7

You have to name it “Add(x)To(y)”, so AddPrimaryPlatformInfoToMachines
or some such.

Otherwise Rails doesn’t know which table to add the columns to. :slight_smile:

–Jeremy

On Sat, Apr 12, 2008 at 1:09 AM, Joe L. [email protected] wrote:

My 005_add_primary_platform_info.rb file then has:
I can add it manually, but shouldn’t we have some add_column and
On Feb 28, 1:11 pm, Jabbslad [email protected] wrote:

Jabbslad

rake db:migrate:reset

Then try running the migrations again.

–
Posted viahttp://www.ruby-forum.com/.

–
http://jeremymcanally.com/
http://entp.com

Read my books:
Ruby in Practice (Ruby in Practice)
My free Ruby e-book (http://humblelittlerubybook.com/)

Or, my blogs:

http://rubyinpractice.com

8

I thought calling db:migrate was supposed to automatically update the
model.

9

LOL - got it! Thanks!!

I woke up this morning and realized I was omitting the obvious “To”
part… :wink:

Dang- this thing works perfectly.

-Joe

On Apr 11, 10:32 pm, “Jeremy McAnally” [email protected]