Rails 7.0.3.1中has_many through关联报property_id未知属性错误

问题背景 #

使用Rails 7.0.3.1开发，修改数据库Schema补充部分ID后，创建完整Property记录时触发错误：

ActiveModel::MissingAttributeError (can't write unknown attribute `property_id`)

已配置Property与amenities、services的has_many through关联（中间表为included_amenities和included_services），无法定位问题根源。

表结构 #

properties表 #

create_table :properties do |t|
  t.string :code
  t.timestamp :create_date
  t.string :province
  t.string :county
  t.string :district
  t.string :area
  t.integer :rooms
  t.integer :bathrooms
  t.integer :parking
  t.boolean :pets
  t.text :address
  t.text :comments
  t.decimal :payment1
  t.decimal :payment2
  t.string :currency1
  t.string :currency2
  t.string :en_translation_key

  t.timestamps
end

included_services表 #

create_table :included_services do |t|
  t.references :property
  t.references :service

  t.timestamps
end

included_amenities表 #

create_table :included_amenities do |t|
  t.references :property
  t.references :amenity

  t.timestamps
end

模型代码 #

Property模型 #

class Property < ApplicationRecord
  belongs_to :property_type
  belongs_to :landlord
  has_one :property_transaction
  has_many_attached :photos
  has_many :included_amenities, dependent: :destroy
  has_many :included_services, dependent: :destroy
  has_many :amenities, through: :included_amenities
  has_many :services, through: :included_services
  validates_presence_of :code, :create_date, :province, :county, :district, :area, :pets, :address, :payment1, :currency1, :property_transaction
end

IncludedAmenity模型 #

class IncludedAmenity < ApplicationRecord
  belongs_to :amenity
  belongs_to :property
end

IncludedService模型 #

class IncludedService < ApplicationRecord
  belongs_to :service
  belongs_to :property
end

控制器代码 #

create方法及参数处理 #

def create
  tmp_params = property_params
  @property = Property.new
  tmp_params[:landlord] = Landlord.find(tmp_params[:landlord])
  tmp_params[:property_type] = PropertyType.find(tmp_params[:property_type])
  tmp_params[:property_transaction] = PropertyTransaction.find(tmp_params[:property_transaction])
  tmp_params[:services] = tmp_params[:services].reject { |service| service == '' }.map { |service| Service.find(service) }
  tmp_params[:amenities] = tmp_params[:amenities].reject { |amenity| amenity == '' }.map { |amenity| Amenity.find(amenity) }
  province_name = search_province_name(tmp_params[:province])[tmp_params[:province]]
  county_name = search_county_name(tmp_params[:province], tmp_params[:county])[tmp_params[:county]]
  tmp_params[:district] = search_district_name(tmp_params[:province], tmp_params[:county], tmp_params[:district])[tmp_params[:district]]
  tmp_params[:province] = province_name
  tmp_params[:county] = county_name
  @property.attributes = tmp_params

  respond_to do |format|
    if @property.save
      format.html { redirect_to @property, notice: "Property was created successfully." }
      format.json { render :show, status: :created, location: @property }
    else
      format.html { render :new, status: :unprocessable_entity }
      format.json { render json: @property.errors, status: :unprocessable_entity }
    end
  end
end

def property_params
  params.require(:property).permit(:code, :create_date, :property_transaction, :province, :county, :district, :area, :rooms,
    :bathrooms, :parking, :payment1, :payment2, :currency1, :currency2,
    :pets, :landlord, :address, :comments, :property_type, services: [], amenities: [], photos: [])
end

排查与解决方案 #

1. 检查关联表的外键字段 #

• 确认included_amenities、included_services表是否实际存在property_id字段：虽然用了t.references :property，但如果迁移未正确执行，字段可能缺失。可通过rails db:migrate:status验证迁移状态，或直接查询数据库表结构。
• 重点检查property_transactions表：Property模型定义了has_one :property_transaction，Rails会默认期望该表存在property_id外键字段。如果该表没有这个字段，需要添加迁移：

  add_reference :property_transactions, :property, foreign_key: true
  

2. 调整关联赋值时机 #

当前代码在Property未保存（无ID）时，直接给services、amenities关联集合赋值对象，导致Rails尝试给中间表写入property_id但无值可用。修正逻辑：先保存Property，再处理关联：

def create
  tmp_params = property_params.except(:services, :amenities)
  tmp_params[:landlord] = Landlord.find(tmp_params[:landlord])
  tmp_params[:property_type] = PropertyType.find(tmp_params[:property_type])
  tmp_params[:property_transaction] = PropertyTransaction.find(tmp_params[:property_transaction])
  
  # 处理地区名称转换
  province_name = search_province_name(tmp_params[:province])[tmp_params[:province]]
  county_name = search_county_name(tmp_params[:province], tmp_params[:county])[tmp_params[:county]]
  tmp_params[:district] = search_district_name(tmp_params[:province], tmp_params[:county], tmp_params[:district])[tmp_params[:district]]
  tmp_params[:province] = province_name
  tmp_params[:county] = county_name
  
  @property = Property.new(tmp_params)

  respond_to do |format|
    if @property.save
      # 保存后再关联服务和设施
      service_ids = property_params[:services].reject(&:empty?)
      amenity_ids = property_params[:amenities].reject(&:empty?)
      
      @property.services = Service.find(service_ids) unless service_ids.empty?
      @property.amenities = Amenity.find(amenity_ids) unless amenity_ids.empty?
      
      format.html { redirect_to @property, notice: "Property was created successfully." }
      format.json { render :show, status: :created, location: @property }
    else
      format.html { render :new, status: :unprocessable_entity }
      format.json { render json: @property.errors, status: :unprocessable_entity }
    end
  end
end

内容的提问来源于stack exchange，提问作者Manuel Santiago Yépez