# Add to migration not working (Rails 2.0.2)

**URL:** <https://www.ruby-forum.com/t/add-to-migration-not-working-rails-2-0-2/130498>\
**Category:** Rails\
**Created:** [February 28, 2008, 7:48pm UTC](https://www.ruby-forum.com/t/add-to-migration-not-working-rails-2-0-2/130498 "2008-02-28T19:48:43Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![daveamos](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/a698b9/32.png) [@daveamos](https://www.ruby-forum.com/u/daveamos)\
**Post date:** [February 28, 2008, 7:48pm UTC](https://www.ruby-forum.com/t/add-to-migration-not-working-rails-2-0-2/130498/1 "2008-02-28T19:48:43Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![daveamos](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/a698b9/32.png) [@daveamos](https://www.ruby-forum.com/u/daveamos)\
**Post date:** [February 28, 2008, 8:42pm UTC](https://www.ruby-forum.com/t/add-to-migration-not-working-rails-2-0-2/130498/2 "2008-02-28T20:42:40Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![daveamos](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/a698b9/32.png) [@daveamos](https://www.ruby-forum.com/u/daveamos)\
**Post date:** [February 28, 2008, 8:47pm UTC](https://www.ruby-forum.com/t/add-to-migration-not-working-rails-2-0-2/130498/3 "2008-02-28T20:47:15Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![daveamos](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/a698b9/32.png) [@daveamos](https://www.ruby-forum.com/u/daveamos)\
**Post date:** [February 28, 2008, 9:12pm UTC](https://www.ruby-forum.com/t/add-to-migration-not-working-rails-2-0-2/130498/4 "2008-02-28T21:12:16Z")

</div>

Ah sorry should have mentioned that 😉

“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 🙂

Glad prob is solved now though.

Jabbslad

On Feb 28, 7:47 pm, Dave A. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)

---

<div class="post-metadata">

**Author:** ![daveamos](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/a698b9/32.png) [@daveamos](https://www.ruby-forum.com/u/daveamos)\
**Post date:** [April 12, 2008, 7:10am UTC](https://www.ruby-forum.com/t/add-to-migration-not-working-rails-2-0-2/130498/5 "2008-04-12T07:10:26Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![daveamos](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/a698b9/32.png) [@daveamos](https://www.ruby-forum.com/u/daveamos)\
**Post date:** [April 12, 2008, 7:41am UTC](https://www.ruby-forum.com/t/add-to-migration-not-working-rails-2-0-2/130498/6 "2008-04-12T07:41:23Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![daveamos](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/a698b9/32.png) [@daveamos](https://www.ruby-forum.com/u/daveamos)\
**Post date:** [April 12, 2008, 7:33am UTC](https://www.ruby-forum.com/t/add-to-migration-not-working-rails-2-0-2/130498/7 "2008-04-12T07:33:12Z")

</div>

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. 🙂

–Jeremy

On Sat, Apr 12, 2008 at 1:09 AM, Joe L. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) 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 [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:
> 
> > Jabbslad
> > 
> > > > rake db:migrate:reset
> > 
> > > > Then try running the migrations again.
> > 
> > > –  
> > > Posted viahttp://www.ruby-forum.com/.

–  
[http://jeremymcanally.com/](http://jeremymcanally.com/)  
[http://entp.com](http://entp.com)

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

Or, my blogs:

> **[Site not found · DreamHost](http://mrneighborly.com)**
>
> The owner of this domain has not yet uploaded their website.

[http://rubyinpractice.com](http://rubyinpractice.com)

---

<div class="post-metadata">

**Author:** ![daveamos](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/a698b9/32.png) [@daveamos](https://www.ruby-forum.com/u/daveamos)\
**Post date:** [April 16, 2008, 7:23pm UTC](https://www.ruby-forum.com/t/add-to-migration-not-working-rails-2-0-2/130498/8 "2008-04-16T19:23:07Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![daveamos](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/a698b9/32.png) [@daveamos](https://www.ruby-forum.com/u/daveamos)\
**Post date:** [April 12, 2008, 4:42pm UTC](https://www.ruby-forum.com/t/add-to-migration-not-working-rails-2-0-2/130498/9 "2008-04-12T16:42:44Z")

</div>

LOL - got it! Thanks!!

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

Dang- this thing works perfectly.

-Joe

On Apr 11, 10:32 pm, “Jeremy McAnally” [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)