Rails: Invalid single-table inheritance type error

ruby-on-rails-4 rails-models
Blaine Kasten picture Blaine Kasten · Aug 15, 2013 · Viewed 7.3k times · Source

So, I am working on migrating this php site with an existing database which I cannot change over to Rails. There is a table: Quotes with a column named type. Whenever I try and create a model of this and set the type, it tells me the following error:

ActiveRecord::SubclassNotFound (Invalid single-table inheritance type: HOME is not a subclass of Quotes)

I don't understand why it thinks its inheriting because it's not supposed to. My create method looks like this:

quote = Quotes.create(
  agent_id: agent.id,
  client_id: client.id,
  type: 'HOME',
  status: 0,
  date_created: DateTime.now 
)

If I comment out the type, everything works fine. But with the Type it errors.

Answer

Blaine Kasten picture Blaine Kasten · Aug 15, 2013

I resolved this by setting the models inheritance_column to nil. Active Record Models can inherit from a table through the attribute :type, setting the inheritance_column to nil removes that attribute allowing you to have a database column named type

class Quote < ActiveRecord::Base
    self.inheritance_column = nil
end

Related questions

Specify an optional reference in your Rails model

I have a Sponsors model and a Promo Codes model. A sponsor can have zero or more promo codes A promo code can have zero or one sponsors Thus a promo code should have an optional reference to a sponsor, …

Read More
How to get a random number in Ruby

How do I generate a random number between 0 and n?

Read More
Rails 4: List of available datatypes

Where can I find a list of data types that can be used in Ruby on Rails 4? Such as text string integer float date I keep learning about new ones and I'd love to have a list I could easily …

Read More