# Migration Error

**URL:** <https://www.ruby-forum.com/t/migration-error/146940>\
**Category:** Rails\
**Created:** [August 26, 2008, 11:50pm UTC](https://www.ruby-forum.com/t/migration-error/146940 "2008-08-26T23:50:26Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![mpls](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/9de053/32.png) [@mpls](https://www.ruby-forum.com/u/mpls)\
**Post date:** [August 26, 2008, 11:50pm UTC](https://www.ruby-forum.com/t/migration-error/146940/1 "2008-08-26T23:50:26Z")

</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:** ![mpls](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/9de053/32.png) [@mpls](https://www.ruby-forum.com/u/mpls)\
**Post date:** [August 27, 2008, 4:28am UTC](https://www.ruby-forum.com/t/migration-error/146940/2 "2008-08-27T04:28:56Z")

</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://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/9de053/32.png) [@mpls](https://www.ruby-forum.com/u/mpls)\
**Post date:** [August 27, 2008, 5:29am UTC](https://www.ruby-forum.com/t/migration-error/146940/3 "2008-08-27T05:29:07Z")

</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:** ![mpls](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/9de053/32.png) [@mpls](https://www.ruby-forum.com/u/mpls)\
**Post date:** [August 27, 2008, 6:35am UTC](https://www.ruby-forum.com/t/migration-error/146940/4 "2008-08-27T06: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://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/9de053/32.png) [@mpls](https://www.ruby-forum.com/u/mpls)\
**Post date:** [August 27, 2008, 8:23pm UTC](https://www.ruby-forum.com/t/migration-error/146940/5 "2008-08-27T20:23:04Z")

</div>

Why does rake db:migrate fail

On Aug 26, 9:35 pm, Dharmdip R. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)

---

<div class="post-metadata">

**Author:** ![mpls](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/9de053/32.png) [@mpls](https://www.ruby-forum.com/u/mpls)\
**Post date:** [August 27, 2008, 8:47pm UTC](https://www.ruby-forum.com/t/migration-error/146940/6 "2008-08-27T20:47:08Z")

</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:** ![mpls](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/9de053/32.png) [@mpls](https://www.ruby-forum.com/u/mpls)\
**Post date:** [August 27, 2008, 10:03pm UTC](https://www.ruby-forum.com/t/migration-error/146940/7 "2008-08-27T22:03:59Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![mpls](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/9de053/32.png) [@mpls](https://www.ruby-forum.com/u/mpls)\
**Post date:** [August 28, 2008, 2:27am UTC](https://www.ruby-forum.com/t/migration-error/146940/8 "2008-08-28T02:27:57Z")

</div>

Here is the log related to rake db:migrate:

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

---

<div class="post-metadata">

**Author:** ![mpls](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/9de053/32.png) [@mpls](https://www.ruby-forum.com/u/mpls)\
**Post date:** [August 28, 2008, 6:53am UTC](https://www.ruby-forum.com/t/migration-error/146940/9 "2008-08-28T06:53:53Z")

</div>

mpls wrote:

> Why does rake db:migrate fail
> 
> On Aug 26, 9:35ï¿½pm, Dharmdip R. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)

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

and last r u able to connect db ?
