similar to: migration issue

All, I have two migration files, file 1 and file 2. For reasons that I don''t want to go into unless I must, I want to only run file 2 on my production database (file 1 contains a bunch of table creation stuff for already existing tables). I figured if I created a schema_info table and set the version in it to 1, then I could just run rake db:migrate RAILS_ENV=production and just

Is anyone using migrations with a SQL Server database who might be able to lend me a hand? I''ve used migrations with MySql in the past and haven''t run into any issues so forgive When I run rake migrate nothing is actually getting updated in my database. I created a migration using ./script/generate migration AddFooTable and updated the migration to look as follows: class

My migrations were working fine until today. I dropped and re-created the database.But, when I go to apply my migrations, rake migrate aborts with this error. You have a nil object when you didn''t expect it! You might have expected an instance of Array. The error occured while evaluating nil.first Any idea what might be wrong? The migrations look right. It''s talking to the

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Ok, so rake migrate --trace gets you this: Khavi:~/Documents/WebCode/rails/clickcaster sgoodwin$ rake migrate -- trace (in /Users/sgoodwin/Documents/WebCode/rails/clickcaster) ** Invoke migrate (first_time) ** Invoke db:migrate (first_time) ** Invoke environment (first_time) ** Execute environment ** Execute db:migrate ** Execute migrate then it

Do I now define database changes directly in db/migration/0001_add_a_new_table file ? Obviously the point is not to make the changes directly in postgresql db anymore right? Thanks Craig

Running rails 1.1 and MySQL 5 on Kubuntu. I moved the same rails project from one machine to another. To set up the database I try to run `rake migrate` but I am greeted with the error/stack trace below. Any idea why this could be? It doesn''t seem to be a permissions problem--I can login to the database as my application just fine. I tried downgrading MySQL to v4.1 because that is

Just got an odd error running migrations off of a new trunk today. Is this my fault is there a bug right now? > rake db:migrate --trace (in /home/magneticworld) ** Invoke db:migrate (first_time) ** Invoke environment (first_time) ** Execute environment rake aborted! undefined method `instantiate_observers'' for ActiveRecord::Base:Class

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) **

All, I''ve decided to jump into Migrations before I get too far along on the DB side of things. I already have some tables built, and I went ahead and built the migration that would have created them from scratch, and I made sure that there was a self.down section to drop them. I wanted to verify that I could roll back so I figured I would use rake to drop these pre-existing tables

On a rails app that I''m developing I converted a regular old .sql file into a rails migration. Since I generated the migration in my development environment, it created the schema_info table for me. However, when I updated my production environment and tried running rake migrate it complained that schema_info doesn''t exist. Is there a rake task for getting around this yet, or

I have the rails recipes book and i was going through the migrations recipe. Everything seemed to work except for the last part in trying to do a rake migrate with a migration file version 1 and the schema_info version set to 0. Without the force attribute, the rake migration fails, as expected. So the recipe says to run this: ruby script/runner

I installed at least one gem since I thought I actually once was able to run ''rake appdoc'' command since there is an api for my models and the ez_where plugin that I installed earlier. I wanted to see the api for pdf-writer which is the gem that I installed most recently. (no, I haven''t given up the issue of ''looping'' that Kevin and some others replied

am in a bit of a quandry... I have asked postgresql-users list and haven''t gotten anything to work with... > > How do I change the owner of a schema? > > > > ALTER SCHEMA "public" OWNER to "some_user"; #? > > http://www.postgresql.org/docs/current/interactive/sql-alterschema.html > > The docs explain this very situation. HTML

Has anyone encountered this error or know how to correct it? I couldn''t find any Rails-specific info about this on google. Here are the circumstances: /usr/local/bin/ruby --version ruby 1.8.4 (2005-12-24) [i686-linux] /usr/local/bin/rails --version Rails 1.1.6 ## Create mcd app rails mcd -d oracle cd mcd ## Create oracle tablespace & user sqlplus ''/ as

Hello everyone, I''m trying to migrate a working app from Postgres to MySQL, and I''m trying to use a migration to get it done rather than alter all my database table creation scripts to MySQL syntax. I''ve done loads of work with Postgres, but am a real newbie with MySQL... I did a ''rake db_schema_dump'' from my Postgres app, and got a nice looking

I''m on OS X Tiger, and just upgraded my gems. I also ran ''rake rails:update''. After that, I ran "rake freeze_gems", I recieve the following: ===================== Freezing to the gems for Rails 1.1.0 rm -rf vendor/rails mkdir -p vendor/rails cd vendor/rails Unpacked gem: ''activesupport-1.3.0'' mv activesupport-1.3.0 activesupport Unpacked

no matter what I try I keep getting this error: rake RAILS_ENV=production db:migrate --trace ** Invoke db:migrate (first_time) ** Invoke environment (first_time) ** Execute environment ** Execute db:migrate rake aborted! Access denied for user ''dashboard''@''localhost'' to database ''production'' I have setup the dashboard user in mysql DB, tested

Hi all, I used the generate script to make a bunch of table migrations, resulting in files like 002_bookmarks.rb, 003_tags.rb, etc. When I did the ''rake migrate'', the db was set up but more migration files appeared, now called 009_create_bookmarks.rb, 010_create_tags.rb, etc. Now when I want to change the database (add a table or column, alter the schema) I do

Hello, I''m trying to use command rake db:migrate, but in MySQL I continuous get an empty set and I do know why. #/db/seeds.rb User.create(username: "lorenz", password: "mypass", admin: true) When I run: rake db:seed RAILS_ENV=development --trace I received: ** Invoke db:seed (first_time) ** Execute db:seed ** Invoke db:abort_if_pending_migrations (first_time) **

I''m getting ready to go to the Rails Studio in Pasadena next week. As part of the prep for that event, I was instructed by the Pragmatic guys to download and install a new Rails 1.0/Ruby 1.8.4 configuration to my OS X 10.4.4 box. I did that three or four days ago. Ever since then, I cannot run a rake migrate command successfully anywhere in my Rails world. (Mind you,