English 中文(简体)
失踪方法
原标题:Missing Method MySQL2

Why would this method (list_id) be undefined when I have the adapter installed?

   ==  XXXXX: migrating ========================================
    -- create_table(:XXXX)
    -- list_id()
    rake aborted!
    An error has occurred, all later migrations canceled:

    undefined method `list_id  for #<ActiveRecord::ConnectionAdapters::Mysql2Adapter:0x007f8345fc0f10>
    /Users/dcarpenter/Dropbox/workspace/gems/activerecord-3.0.9/lib/active_record/migration.rb:385:in `block in method_missing 

HERE S THE FULL LOAD:

     undefined method `list_id  for #<ActiveRecord::ConnectionAdapters::Mysql2Adapter:0x007f9a3d416340>
/Users/dcarpenter/Dropbox/workspace/gems/activerecord-3.0.9/lib/active_record/migration.rb:385:in `block in method_missing 
/Users/dcarpenter/Dropbox/workspace/gems/activerecord-3.0.9/lib/active_record/migration.rb:361:in `block in say_with_time 
/Users/dcarpenter/.rvm/rubies/ruby-1.9.2-p290/lib/ruby/1.9.1/benchmark.rb:295:in `measure 
/Users/dcarpenter/Dropbox/workspace/gems/activerecord-3.0.9/lib/active_record/migration.rb:361:in `say_with_time 
/Users/dcarpenter/Dropbox/workspace/gems/activerecord-3.0.9/lib/active_record/migration.rb:381:in `method_missing 
/Users/dcarpenter/Dropbox/workspace/BlueFusion/db/migrate/20110812030512_create_outreach_campaigns.rb:4:in `block in up 
/Users/dcarpenter/Dropbox/workspace/gems/activerecord-3.0.9/lib/active_record/connection_adapters/abstract/schema_statements.rb:157:in `create_table 
/Users/dcarpenter/Dropbox/workspace/gems/mysql2-0.2.11/lib/active_record/connection_adapters/mysql2_adapter.rb:421:in `create_table 
/Users/dcarpenter/Dropbox/workspace/gems/activerecord-3.0.9/lib/active_record/migration.rb:385:in `block in method_missing 
/Users/dcarpenter/Dropbox/workspace/gems/activerecord-3.0.9/lib/active_record/migration.rb:361:in `block in say_with_time 
/Users/dcarpenter/.rvm/rubies/ruby-1.9.2-p290/lib/ruby/1.9.1/benchmark.rb:295:in `measure 
/Users/dcarpenter/Dropbox/workspace/gems/activerecord-3.0.9/lib/active_record/migration.rb:361:in `say_with_time 
/Users/dcarpenter/Dropbox/workspace/gems/activerecord-3.0.9/lib/active_record/migration.rb:381:in `method_missing 
/Users/dcarpenter/Dropbox/workspace/BlueFusion/db/migrate/20110812030512_create_outreach_campaigns.rb:3:in `up 
/Users/dcarpenter/Dropbox/workspace/gems/activerecord-3.0.9/lib/active_record/migration.rb:314:in `block in migrate 
/Users/dcarpenter/.rvm/rubies/ruby-1.9.2-p290/lib/ruby/1.9.1/benchmark.rb:295:in `measure 
/Users/dcarpenter/Dropbox/workspace/gems/activerecord-3.0.9/lib/active_record/migration.rb:314:in `migrate 
/Users/dcarpenter/Dropbox/workspace/gems/activerecord-3.0.9/lib/active_record/migration.rb:397:in `migrate 
/Users/dcarpenter/Dropbox/workspace/gems/activerecord-3.0.9/lib/active_record/migration.rb:539:in `block (2 levels) in migrate 
/Users/dcarpenter/Dropbox/workspace/gems/activerecord-3.0.9/lib/active_record/migration.rb:615:in `call 
/Users/dcarpenter/Dropbox/workspace/gems/activerecord-3.0.9/lib/active_record/migration.rb:615:in `ddl_transaction 
/Users/dcarpenter/Dropbox/workspace/gems/activerecord-3.0.9/lib/active_record/migration.rb:538:in `block in migrate 
/Users/dcarpenter/Dropbox/workspace/gems/activerecord-3.0.9/lib/active_record/migration.rb:525:in `each 
/Users/dcarpenter/Dropbox/workspace/gems/activerecord-3.0.9/lib/active_record/migration.rb:525:in `migrate 
/Users/dcarpenter/Dropbox/workspace/gems/activerecord-3.0.9/lib/active_record/migration.rb:435:in `up 
/Users/dcarpenter/Dropbox/workspace/gems/activerecord-3.0.9/lib/active_record/migration.rb:417:in `migrate 
/Users/dcarpenter/Dropbox/workspace/gems/activerecord-3.0.9/lib/active_record/railties/databases.rake:142:in `block (2 levels) in <top (required)> 
/Users/dcarpenter/Dropbox/workspace/gems/rake-0.9.2/lib/rake/task.rb:205:in `call 
/Users/dcarpenter/Dropbox/workspace/gems/rake-0.9.2/lib/rake/task.rb:205:in `block in execute 
/Users/dcarpenter/Dropbox/workspace/gems/rake-0.9.2/lib/rake/task.rb:200:in `each 
/Users/dcarpenter/Dropbox/workspace/gems/rake-0.9.2/lib/rake/task.rb:200:in `execute 
/Users/dcarpenter/Dropbox/workspace/gems/rake-0.9.2/lib/rake/task.rb:158:in `block in invoke_with_call_chain 
/Users/dcarpenter/.rvm/rubies/ruby-1.9.2-p290/lib/ruby/1.9.1/monitor.rb:201:in `mon_synchronize 
/Users/dcarpenter/Dropbox/workspace/gems/rake-0.9.2/lib/rake/task.rb:151:in `invoke_with_call_chain 
/Users/dcarpenter/Dropbox/workspace/gems/rake-0.9.2/lib/rake/task.rb:144:in `invoke 
/Users/dcarpenter/Dropbox/workspace/gems/rake-0.9.2/lib/rake/application.rb:112:in `invoke_task 
/Users/dcarpenter/Dropbox/workspace/gems/rake-0.9.2/lib/rake/application.rb:90:in `block (2 levels) in top_level 
/Users/dcarpenter/Dropbox/workspace/gems/rake-0.9.2/lib/rake/application.rb:90:in `each 
/Users/dcarpenter/Dropbox/workspace/gems/rake-0.9.2/lib/rake/application.rb:90:in `block in top_level 
/Users/dcarpenter/Dropbox/workspace/gems/rake-0.9.2/lib/rake/application.rb:129:in `standard_exception_handling 
/Users/dcarpenter/Dropbox/workspace/gems/rake-0.9.2/lib/rake/application.rb:84:in `top_level 
/Users/dcarpenter/Dropbox/workspace/gems/rake-0.9.2/lib/rake/application.rb:62:in `block in run 
/Users/dcarpenter/Dropbox/workspace/gems/rake-0.9.2/lib/rake/application.rb:129:in `standard_exception_handling 
/Users/dcarpenter/Dropbox/workspace/gems/rake-0.9.2/lib/rake/application.rb:59:in `run 
/Users/dcarpenter/Dropbox/workspace/gems/rake-0.9.2/bin/rake:32:in `<top (required)> 
/Users/dcarpenter/.rvm/rubies/ruby-1.9.2-p290/bin/rake:19:in `load 
/Users/dcarpenter/.rvm/rubies/ruby-1.9.2-p290/bin/rake:19:in `<main> 



class CreateOutreachCampaigns < ActiveRecord::Migration
  def self.up
    create_table :outreach_campaigns do |t|
      t.integer list_id
      t.integer parent_list_id
      t.integer survey_id
      t.integer user_id
      t.string short_desc
      t.string long_desc
      t.enum type, :limit => [:call,:walk]
      t.timestamps
    end
    add_index "outreach_campaigns", ["list_id"]
    add_index "outreach_campaigns", ["survey_id"]
    add_index "outreach_campaigns", ["parent_list_id"]
    add_index "outreach_campaigns", ["user_id"]
  end

  def self.down
    drop_table :outreach_campaigns
  end
end
最佳回答

It should be t.integer :list_id on line 4. Rest of the lines have the same mistake.

Also note that the enum-column requires a plugin and column called "type" is a bad idea because type is a reserved word, you can get around it, but you re better off renaming the column to something else.

问题回答

暂无回答




相关问题
rails collection_select vs. select

collection_select and select Rails helpers: Which one should I use? I can t see a difference in both ways. Both helpers take a collection and generates options tags inside a select tag. Is there a ...

SSL slowness in EC2

We ve deployed our rails app to EC2. In our setup, we have two proxies on small instances behind round-robin DNS. These run nginx load balancers for a dynamically growing and shrinking farm of web ...

Auth-code with A-Za-z0-9 to use in an URL parameter

As part of a web application I need an auth-code to pass as a URL parameter. I am currently using (in Rails) : Digest::SHA1.hexdigest((object_id + rand(255)).to_s) Which provides long strings like : ...

RubyCAS-Client question: Rails

I ve installed RubyCAS-Client version 2.1.0 as a plugin within a rails app. It s working, but I d like to remove the ?ticket= in the url. Is this possible?

activerecord has_many :through find with one sql call

I have a these 3 models: class User < ActiveRecord::Base has_many :permissions, :dependent => :destroy has_many :roles, :through => :permissions end class Permission < ActiveRecord::...

Ordering a hash to xml: Rails

I m building an xml document from a hash. The xml attributes need to be in order. How can this be accomplished? hash.to_xml

Text Editor for Ruby-on-Rails

guys which text editor is good for Rubyonrails? i m using Windows and i was using E-Texteditor but its not free n its expired now can anyone plese tell me any free texteditor? n which one is best an ...

How to get SQL queries for each user where env is production

I’m developing an application dedicated to generate statistical reports, I would like that user after saving their stat report they save sql queries too. To do that I wrote the following module: ...

热门标签