similar to: Simple Migration Question: Specifying a key length

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

I have a test environment running rails 1.2.3. I am just starting to introduce testing into this project. When I run a rake db:prepare. I see this message "Mysql::Error: #42000BLOB/TEXT column ''short_description'' used in key specification without a key length: CREATE INDEX ''short_description'' on cached_cars (''short_description'') The

Im using restful authentication, and i changed the username model from login to username. The error is Mysql::Error: Key column ''login'' doesn''t exist in table: CREATE UNIQUE INDEX `index_users_on_login` Heres the trace: DEPRECATION WARNING: Rake tasks in vendor/plugins/restful-authentication/tasks are deprecated. Use lib/tasks instead. (called from

I''m having a bit of trouble getting a rails project to build properly within cruisecontrolrb. My cruise task is in lib/tasks/my_project.rake, and looks like this: task :cruise => [''db:test:purge'', ''db:migrate'', ''db:test:prepare'', ''test:coverage:clean'', ''test:coverage:prepare'',

My envrionment is Rails 1.1.2, Ruby 1.8.4, MySQL 5.0.21 on WinXP. When I run ''rake migrate'' after pulling the lastest 1.1 branch of Globalize plugin, I get the following error message: (in C:/Rails/Application/medicalmind) == GlobalizeMigration: migrating ============================================== -- create_table(:globalize_countries, {:force=>true}) -> 0.2110s

I keep getting this exception "SQLite3::SQLException: no such column: books.user_id: SELECT "books".* FROM "books" WHERE ("books".user_id = 4)" ,which sounds like there is no user_id in books table.So i just installed foreigner plugin and added " t.integer :user_id, :null => false" and "add_foreign_key(:books, :users)" in book

I''ve written a simple Rails migration that adds an index to an existing Postgres table: class AddIndexToEvents < ActiveRecord::Migration > def change > add_index :sf_events, :account_id > end > end However, when I run the migration, it fails due to a syntax error on the CREATE INDEX line. I''m expecting some SQL like this to be generated: CREATE INDEX

The upgrade to Rails 1.1 hurt my ability to run tests because it generated the following MySQL error: Mysql::Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''key ON config (key)'' at line 1: CREATE UNIQUE INDEX key ON config (key) I have a table called `config` with a column

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)

Hello, We''re using Rails on an Oracle database. If we define an index like the following, we end up with problems during the "db:schema:dump" rake target. add_index "emcolumn", ["upper(name)"], :name => "ind_emcolumn_uname" The created schema.rb file contains: add_index "emcolumn", ["sys_nc00013$"], :name =>

I''m using rake migration for mySql database changes. I''ve so far been unable to uncover a way to specify that an integer field is unsigned. You can do it in mySql, but I can''t find the correct argument for the change_column method. Is there one? -- Posted via http://www.ruby-forum.com/.

Hi I''m new to Rails. This is my first application and I''m trying to set up a schema I''ve hand-crafted as a migration. Does anybody know why this... # deposit_types create_table :deposit_types do |table| table.column :type_code, :string, :limit => 20, :null => false table.column :description, :string, :limit => 50, :null => false

Hi all, Any help with this would be appreciated. I''m using instant rails, updated to 2.2.2, on Windows XP. I''ve created my DB and scaffolded a few things and put some fixtures into place, and when I run the tests I get many errors that look like this: --------------------------------- 1) Error: test_the_truth(EntityTest): NoMethodError: undefined method `key?'' for

I put this config in environment.rb # Use table_id instead of id for primary key. config.active_record.primary_key_prefix_type = :table_name_with_underscore I have this migration: class CreateEntities < ActiveRecord::Migration def self.up create_table :entities do |t| t.string :entity_name, :null => false, :limit => 40 t.string

Hello all, I''m kinda going through a rocky upgrade to rails 1.1 and I can''t find much on google about this. When I run my tests I get this: $ rake (in /home/www/art2) /usr/bin/ruby -Ilib:test "/usr/lib/ruby/gems/1.8/gems/rake-0.7.1/lib/rake/rake_test_loader.rb" "test/functional/panoramas_controller_test.rb"

I''ve got a spec that loads a fixture in the "before" block. This works fine running scripts/spec, but when I run rake spec instead, I get: ActiveRecord::StatementInvalid in ''User in fixture :quentin with an IM service but no IM name should be invalid'' Mysql::Error: Cannot delete or update a parent row: a foreign key constraint fails

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 =>

My model consists of users and tasks (m:n), the relation is stored in a seperate table sharedtabs (that contains some extra fields). Between tabs and tasks there is a 1:n relation. I have trouble writing my seed.rb: works: (1) tab = Tab.create(:name => ''Admin'', :category => 0) tab.tasks.create(:name => ''Admin_Tab1_Private Task 1'') works: (2)

Hello, I''m playing around with Rails3 and trying to upgrade one of my applications to Rails 3.0.0.rc and I get an error which should be still working. Migration: t.index :name When I execute rake: rake aborted! An error has occurred, all later migrations canceled: undefined method `index'' for #<ActiveRecord::ConnectionAdapters::TableDefinition:0x4b2b6b0> Does some one

I have an application that has models for beer styles. Every beer style will have a name and description. It will also contain a list of beer models. Every beer model will contain a name. I want my application to fill in the list of styles with some default data. #Beer migration file: class CreateBeers < ActiveRecord::Migration def change create_table :beers do |t| t.string