Forum: Ruby on Rails Help needed for error in foreign key validation

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

On Nov 17, 10:19am, rubyrookie <asajn...@gmail.com> wrote:
>  has_one :country
Your association is wrong - if bank has a country_id column then the
association should be a belongs_to

Fred

Thanks worked.