Migration Error

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.

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

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

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

Why does rake db:migrate fail

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.

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

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

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 ?