mysql - 简单 Rails SQL 错误

Question

尝试在表单中构建“兴趣”复选框列表时出现以下错误(下面也列出了模型)...有什么想法吗？谢谢!

ActiveRecord::StatementInvalid in User_steps#show

Showing /Users/nelsonkeating/Desktop/ReminDeal/app/views/user_steps/show.html.erb where line #19 raised:

SQLite3::SQLException: no such column: person_interests.interest_id: SELECT "interests".* FROM "interests" INNER JOIN "person_interests" ON "interests"."id" = "person_interests"."interest_id" WHERE "person_interests"."person_id" = 11 AND "person_interests"."person_type" = 'User'
Extracted source (around line #19):

16:   <legend>Interests & Holidays</legend>
17:   <h4>Select your top 3 interests..</h4>
18: 
19: <%= f.simple_fields_for :interests do |interest_f| %>
20:   <%= interest_f.input :interest, :as => :check_boxes, :label => false %>
21:    <% end %>
22:   <br></br>



class User < ActiveRecord::Base

  attr_accessible :name, :email, :password, :password_confirmation, :remember_me,     :interests_attributes, :city, :zipcode, :date_of_birth, :gender, :address, :interest_ids, :holiday_ids, :friends_attributes, :person_interest_ids, :friends
  has_many :friends
  has_many :person_interests, :as => :person
  has_many :interests, :through => :person_interests

  accepts_nested_attributes_for :friends,  allow_destroy: true
  accepts_nested_attributes_for :interests, allow_destroy: true

end

class PersonInterest < ActiveRecord::Base
  attr_accessible :person_id, :person_type
  belongs_to :interest
  belongs_to :person, :polymorphic => true
end


class Interest < ActiveRecord::Base
  attr_accessible :name
  has_many :person_interests
  has_many :people, :through => :person_interests
end

Answer 1

基于此错误消息:

SQLite3::SQLException: no such column: person_interests.interest_id

您的 person_interests 表似乎没有名为 interest_id 的列。