Rails - Jun 2006 - rake migrate working but not working

Hi All

I got this migration to work the first time I tried it, dropped the
table and not the migration won''t create the table but does not show
any
errors. Here is the trace on the execution of the rake migrate:

my-computer:~/forms lars$ rake migrate --trace
(in /Users/lars/forms)
** Invoke migrate (first_time)
** Invoke db:migrate (first_time)
** Invoke environment (first_time)
** Execute environment
** Execute db:migrate
** Invoke db:schema:dump (first_time)
** Invoke environment
** Execute db:schema:dump
** Execute migrate

I''m at a loss. I''ve checked that the database access
configuration was
done properly. Where should I go from here tracking this one down?

Thanks

-- 
Posted via http://www.ruby-forum.com/.

I forgot to mention that I''m using OS 10.4.6 (Intel) with mysql 5.0.20 
and rails 1.1.2.

-- 
Posted via http://www.ruby-forum.com/.

I solved my problem. I needed to drop the schema_info table from the 
database as well, not just the table I wanted to drop. When both tables 
are cleared from the database, rake migrate wil create the new tables in 
the database.

-- 
Posted via http://www.ruby-forum.com/.

Hi,

The migrations use the version number stored in a table named schema_info
to know which migrations to execute. Did you reset this version number
before trying your migration once again ?

A better way to reset your schema would be to use "rake migrate
VERSION=0".

HTH,
St?phane.
> Hi All
>
> I got this migration to work the first time I tried it, dropped the
> table and not the migration won''t create the table but does not
show any
> errors. Here is the trace on the execution of the rake migrate:
>
> my-computer:~/forms lars$ rake migrate --trace
> (in /Users/lars/forms)
> ** Invoke migrate (first_time)
> ** Invoke db:migrate (first_time)
> ** Invoke environment (first_time)
> ** Execute environment
> ** Execute db:migrate
> ** Invoke db:schema:dump (first_time)
> ** Invoke environment
> ** Execute db:schema:dump
> ** Execute migrate
>
> I''m at a loss. I''ve checked that the database access
configuration was
> done properly. Where should I go from here tracking this one down?
>
> Thanks
>
> --
> Posted via http://www.ruby-forum.com/.
> _______________________________________________
> Rails mailing list
> Rails@lists.rubyonrails.org
> http://lists.rubyonrails.org/mailman/listinfo/rails
>
>
>
>