# Migration Error

**URL:** <https://discuss.rubyonrails.org/t/migration-error/33667>\
**Category:** rubyonrails-talk\
**Created:** [August 26, 2008, 9:48pm UTC](https://discuss.rubyonrails.org/t/migration-error/33667 "2008-08-26T21:48:00Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![mpls](https://avatars.discourse-cdn.com/v4/letter/m/9de053/32.png) [@mpls](https://discuss.rubyonrails.org/u/mpls)\
**Post date:** [August 26, 2008, 9:48pm UTC](https://discuss.rubyonrails.org/t/migration-error/33667/1 "2008-08-26T21:48:00Z")

</div>

When trying to migrate my db using rake I get the following error message:

rake aborted! No migration with version number 3

I am using sqlite3 as my database server. Any help is much appreciated.

---

<div class="post-metadata">

**Author:** ![Scott\_Meade](https://avatars.discourse-cdn.com/v4/letter/s/f6c823/32.png) [@Scott\_Meade](https://discuss.rubyonrails.org/u/Scott_Meade)\
**Post date:** [August 27, 2008, 2:28am UTC](https://discuss.rubyonrails.org/t/migration-error/33667/2 "2008-08-27T02:28:01Z")

</div>

mpls, If you are running rails prior to Rails version 2.0, it means that you do not have a file like: db/migrate/003\_....

---

<div class="post-metadata">

**Author:** ![mpls](https://avatars.discourse-cdn.com/v4/letter/m/9de053/32.png) [@mpls](https://discuss.rubyonrails.org/u/mpls)\
**Post date:** [August 27, 2008, 3:26am UTC](https://discuss.rubyonrails.org/t/migration-error/33667/3 "2008-08-27T03:26:36Z")

</div>

Thanks for the reply. I am using rails 2.0 and the migration file is prefixed with 20080827011222\_ When I run the following command: rake db:migrate I get the rake aborted! No migration with version number 3. but when I run: rake db: migrate version 0 the table is created. How do I make rake db:migrate work so I can have version beyond 0. Thanks

---

<div class="post-metadata">

**Author:** ![11175](https://avatars.discourse-cdn.com/v4/letter/1/8edcca/32.png) [@11175](https://discuss.rubyonrails.org/u/11175)\
**Post date:** [August 27, 2008, 4:35am UTC](https://discuss.rubyonrails.org/t/migration-error/33667/4 "2008-08-27T04:35:53Z")

</div>

mpls wrote:

> Thanks for the reply. I am using rails 2.0 and the migration file is prefixed with 20080827011222\_ When I run the following command: rake db:migrate I get the rake aborted! No migration with version number 3. but when I run: rake db: migrate version 0 the table is created. How do I make rake db:migrate work so I can have version beyond 0. Thanks
> 
> >

when u create db through migration there is table name schema\_info when u go threw different migration it track migration ! for further reading [http://wiki.rubyonrails.com](http://wiki.rubyonrails.com)

---

<div class="post-metadata">

**Author:** ![mpls](https://avatars.discourse-cdn.com/v4/letter/m/9de053/32.png) [@mpls](https://discuss.rubyonrails.org/u/mpls)\
**Post date:** [August 27, 2008, 6:22pm UTC](https://discuss.rubyonrails.org/t/migration-error/33667/5 "2008-08-27T18:22:17Z")

</div>

Why does rake db:migrate fail

---

<div class="post-metadata">

**Author:** ![mpls](https://avatars.discourse-cdn.com/v4/letter/m/9de053/32.png) [@mpls](https://discuss.rubyonrails.org/u/mpls)\
**Post date:** [August 27, 2008, 6:46pm UTC](https://discuss.rubyonrails.org/t/migration-error/33667/6 "2008-08-27T18:46:44Z")

</div>

Here is my full trace of the rake db:migrate:

\*\* Invoke db:migrate (first\_time) \*\* Invoke environment (first\_time) \*\* Execute environment \*\* Execute db:migrate rake aborted! No migration with version number 3 c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active\_record/ migration.rb :410:in `migrate' c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active_record/ migration.rb :361:in `down' c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.1.0/lib/active\_record/ migration.rb :341:in `migrate' c:/ruby/lib/ruby/gems/1.8/gems/rails-2.1.0/lib/tasks/databases.rake:99 c:/ruby/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:546:in `call' c:/ruby/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:546:in `execute' c:/ruby/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:541:in `each' c:/ruby/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:541:in `execute' c:/ruby/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:508:in `invoke\_with\_call\_c hain' c:/ruby/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:501:in `synchronize' c:/ruby/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:501:in `invoke\_with\_call\_c hain' c:/ruby/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:494:in `invoke' c:/ruby/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1931:in `invoke\_task' c:/ruby/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1909:in `top_level' c:/ruby/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1909:in `each' c:/ruby/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1909:in `top_level' c:/ruby/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1948:in `standard\_exceptio n\_handling' c:/ruby/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1903:in `top_level' c:/ruby/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1881:in `run' c:/ruby/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1948:in `standard_exceptio n_handling' c:/ruby/lib/ruby/gems/1.8/gems/rake-0.8.1/lib/rake.rb:1878:in `run' c:/ruby/lib/ruby/gems/1.8/gems/rake-0.8.1/bin/rake:31 c:/ruby/bin/rake:19:in `load' c:/ruby/bin/rake:19

Also why is the version number 3 when this is the first time I ran rake db:migrate.

---

<div class="post-metadata">

**Author:** ![Scott\_Meade](https://avatars.discourse-cdn.com/v4/letter/s/f6c823/32.png) [@Scott\_Meade](https://discuss.rubyonrails.org/u/Scott_Meade)\
**Post date:** [August 27, 2008, 8:02pm UTC](https://discuss.rubyonrails.org/t/migration-error/33667/7 "2008-08-27T20:02:57Z")

</div>

mpls: any rake db:migrate related output in development.log ?

---

<div class="post-metadata">

**Author:** ![mpls](https://avatars.discourse-cdn.com/v4/letter/m/9de053/32.png) [@mpls](https://discuss.rubyonrails.org/u/mpls)\
**Post date:** [August 28, 2008, 12:27am UTC](https://discuss.rubyonrails.org/t/migration-error/33667/8 "2008-08-28T00:27:00Z")

</div>

Here is the log related to rake db:migrate:

&nbsp;&nbsp;[4;36;1mSQL (0.000000)[0m [0;1mSET NAMES 'utf8'[0m &nbsp;&nbsp;[4;35;1mSQL (0.000000)[0m [0mSET SQL\_AUTO\_IS\_NULL=0[0m &nbsp;&nbsp;[4;36;1mSQL (0.000000)[0m [0;1mSELECT version FROM schema\_migrations[0m &nbsp;&nbsp;[4;35;1mSQL (0.000000)[0m [0mSHOW TABLES[0m &nbsp;&nbsp;[4;36;1mSQL (0.000000)[0m [0;1mSELECT version FROM schema\_migrations[0m

---

<div class="post-metadata">

**Author:** ![11175](https://avatars.discourse-cdn.com/v4/letter/1/8edcca/32.png) [@11175](https://discuss.rubyonrails.org/u/11175)\
**Post date:** [August 28, 2008, 4:53am UTC](https://discuss.rubyonrails.org/t/migration-error/33667/9 "2008-08-28T04:53:53Z")

</div>

mpls wrote:

> Why does rake db:migrate fail
> 
> On Aug 26, 9:35�pm, Dharmdip Rathod \<rails-mailing-l...@andreas-s.net\>

check syntax , check database is exists or not ? or check syntax in migration file !

and last r u able to connect db ?
