Question

伙计们，当我按照http://guides.rubyonrails.org/testing.html，上面写着：

test_the_truth(ClassroomTypeTest): ActiveRecord::StatementInvalid: Mysql2::Error: Unknown column type in field list : INSERT INTO classroom_types (type, memo, created_at, updated_at, id) VALUES ( MyString , MyString , 2011-05-31 08:40:54 , 2011-05-31 08:40:54 , 980190962)

I am confused, I do not have a column in my classroom_types table,why will it appear such an error? Can anyone help me? Many Thanks!

以下是我的模型和关系：

ClassroomType型号：

class ClassroomType < ActiveRecord::Base
  has_many :classrooms
end

课堂模式：

class Classroom < ActiveRecord::Base
   belongs_to :classroom_type
   belongs_to :teaching_building
end

教学楼模型：

class TeachingBuilding < ActiveRecord::Base
  has_many :classrooms
end

以下是相应的表格：

教室：

id
classroom_no
classroom_name
classroom_type_id
teaching_building_id

教室类型（_T）：

id
name
memo

教学_建筑：

id
t_no
name

Answer 1

我想问题出在您的列命名上。当rails进行多态关联时，它会使用id联接表，并从xxx_type列中选择联接的表。我可以想象，如果您在数据库名称和列名中将“type”替换为（例如）“kind”，您的问题就会消失。

Answer 2

Samuel

I had encountered a similar problem but solved here s how

go to mysql localserver
then change the mysql column name correspoding to model having belongs_to
Use "ALTER TABLE tablename CHANGE oldname newname VARCHAR (10) ;"
This is because rails creates default as user_id

Answer 3

我认为问题是列命名，请检查数据库表的列名及其类型，并根据错误消息进行设置

友情链接