I have two models bank and country. User should only associate a Bank
with
a country id present in the country table and I put validates presence
of
country to enforce it but i get error mysql2::Error: Unknown column
‘countries.bank_id’ in ‘where clause’: SELECT countries.* FROM
countries WHERE countries.bank_id = 17 LIMIT 1 when updating the
bank
table
Can you tell me how to fix the issue? If I remove the
validates_presence_of :country I get a database error as expected when
i
update bank table with a country id not in country table.
class Bank < ActiveRecord::Base
attr_accessible :name,:country_id
has_one :country
validates :name, :presence => true
validates_presence_of :country
end
class Country < ActiveRecord::Base
attr_accessible :name
end