Rails rake db:migrate of a recently created database

Question

I have just created a database. I am trying to migrate but I am receiving a table not found error.

rake db:migrate 
/usr/local/rvm/gems/ruby-1.9.2-p290@global/gems/bundler-1.1.5/lib/bundler/runtime.rb:211: warning:     Insecure world writable dir /usr/local/rvm/gems in PATH, mode 042777
rake aborted!
Mysql2::Error: Table 'law_development.users' doesn't exist: SHOW FIELDS FROM `users`

Tasks: TOP => db:migrate => environment (See full trace by running task with --trace)

That table is created by the first migration, the database is empty (without tables).

Any help?

Did you run `rake db:create:all`? – Krista Sep 26 '12 at 17:16 — Krista, Sep 26 '12 at 17:16
Yes, the databases are all created – Tony Sep 26 '12 at 17:18 — Tony, Sep 26 '12 at 17:18

score 2 · Accepted Answer · edited Sep 26 '12 at 18:14

2

There are number of reasons for this behavior. If above stated solutions didn't worked for you, then first of all try running:

rake db:migrate --trace

Examine the logs generated, definitely there would be some code that breaks migrations.

For more info you can consult this forum.

edited Sep 26 '12 at 18:14

alf

18,372
10
61
92

answered Sep 26 '12 at 17:46

Karan Nanda

56
4

score 0 · Answer 2 · answered Sep 26 '12 at 17:21

0

Try starting with a clean database, and loading the schema directly instead of running the migrations:

rake db:drop db:create db:schema:load

answered Sep 26 '12 at 17:21

alf

18,372
10
61
92

Rails rake db:migrate of a recently created database

2 Answers2