similar to: specifying unsigned type in rake migration

All, I have a migration with statements like this: change_column :quote_input_class_codes, :employee_payroll, :integer, :default => 0, :null => false When I migrate, I get: (in C:/eclipse/workspace/OnlineRating) == DefaultQiccPayrollsToZero: migrating ======================================= -- change_column(:quote_input_class_codes, :employee_payroll, :integer, {:null=>false,

Hi I''ve created a migration called make_customer_type_id_not_null_for_customers. The migration .rb file looks like this: class MakeCustomerTypeIdNotNullForCustomers < ActiveRecord::Migration def self.up change_column(:customers, :customer_type_id, :integer, { :null => false }) end def self.down change_column(:customers, :customer_type_id, :integer, { :null =>

Hi everyone, For one of our projects we have a need to deploy and maintain a demo. As a result I''ve attempted to setup a set of rake tasks for the job. My goal is have one rake task called "deploy_demo" which purges the database, migrates to the current schema, and loads the db from a set of fixture files in a specified location. I''ve written two new tasks the perform

Hmm, one of my migrations have stopped working on #down. It still works on #up. (It''s also possible that I never tested it for #down before, and it never worked, heh.) I can''t figure out why not. Pretty simple. class WidenRequestParams < ActiveRecord::Migration def self.up change_column :requests, :params, :string, :limit => 2048 end def self.down

I''m use Ruby 1.9 via rvm and Rails 2.3.3. I''m on OS X 10.5 and I have the mysql 2.8.1 gem installed. When I run rake on my rails app, I get the error "wrong argument type Mysql (expected Struct)". I can run the app fine with script/server and script/console fine. Is anyone else having this problem or know what might cause this problem? Here''s the stack

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

Hi, It appears to me that the command: ruby script/generate scaffold whatever money_field:decimal(10,2) will not generate a valid migration. Therefore it appears to me only two ways to achieve the desired result is: 1.1 Omit the the precision/scale on the scaffold command 1.2 Edit the migration file by following the "do |t| ... end" with the command: change_column :whatever

Hai All, i have installed Ruby and Rails in my localhost, and i have to download Rubricks CMS and installed in my localhost in the installing process i got below Error Please Say how can i rectify this. ** Invoke db:migrate (first_time) ** Invoke environment (first_time) ** Execute environment rake aborted! wrong number of arguments (1 for 0)

I''ve been trying to build an app with migrations: When I attempt: $rake migrate I get the following errors: rake migrate --trace (in /Users/intention/work/atlrugpoll_working) ** Invoke migrate (first_time) ** Invoke environment (first_time) ** Execute environment ** Execute migrate ^Crake aborted!

with a simple table def. class Objects < ActiveRecord::Migration def self.up create_table :objects do |table| table.column :name, string end def self.down drop_table :objects end end when I run rake migrate, I get: ** Invoke migrate (first_time) ** Invoke db:migrate (first_time) ** Invoke environment (first_time) ** Execute environment ** Execute db:migrate rake

I am trying to get a customized rcov rake task working. What I have so far looks like this: desc "Rcov code coverage reports" require ''rcov/rcovtask'' require ''spec/rake/spectask'' require ''cucumber/rake/task'' task :rcov => "rcov:all" namespace :rcov do Rcov::RcovTask.new(:all) do task :rcov =>

I have been attempting to use migrations as a build a poll app. I have created the initial file: ----------------- class CreateTablePollsAndPollOptions < ActiveRecord::Migration def self.up create_table polls do |table| table.column ''question'', :string table.column ''user_id'', :integer table.column ''start_time'',

Hello, I am trying do a migrate of my database but I have problems, I write this in the console: [console] rake db:migrate [/console] And say me: [console] (in /home/distriker/Documentos/public_html/crf) !!! The bundled mysql.rb driver has been removed from Rails 2.2. Please install the mysql gem and try again: gem install mysql. rake aborted! no such file to load -- mysql (See full trace by

Hi, i am new to rails and trying to understand the migrate feature of rake whenever I call "rake migrate", i understand it call all the latest version of a given of given migrate files. Now when these files are executed, id the #down method called and then the #up ? or must i explicitly call the #down method from rake. If yes how do i do that from rake ? I experimented with rake

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

Is there any way to create a key length for a text index using add_index? Whenever I tree and create a text-based, rather than integer based index, it aborts the rake because I did not specify a key length. I looked at the add_index documentation, and can''t find a way to specify this. How do I rectify this error: Mysql::Error: BLOB/TEXT column ''url'' used in key

Hi everybody, May be somebody has a clue, why I get these errors below, while trying to migrate. Any help is very appreciated! Greetinx Rafael I was trying to experiment a litte bit with redMine (www.redmine.org). But I can only install it locally. On a system with already a mongrel_cluster running, I get strange errors, already while trying to start the migration rake db:migrate

So this has left me completely confused. I''m trying to get the test suite going on an existing app, but things going a little crazy. In the application directory if I do ''rake'' or ''rake test'' I get: rake aborted! Lost connection to MySQL server during query However if I do ''rake test:units'' or ''rake

Hi, I am constantly getting an error when I use the rake command to do a migration or even use drop, this happened after I installed some plugins such as paperclip and seed-fu. The error is: rake aborted! uninitialized constant PKG_NAME /var/www/html/quote/Rakefile:10 The Rakefile looks like this: # Add your own tasks in files placed in lib/tasks ending in .rake, # for example

I''m trying to follow the tutorial in the "agile web development with rails" book which I bought. After creating the database migration file for mysql, When I try to run rake on my database migration to create table in mysql, I get depot>rake db:migrate (in C:/xxx/RoR/depot) rake aborted! undefined method `each'' for #<Mysql:0x38da498> any idea what i might