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 -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk@googlegroups.com. To unsubscribe from this group, send email to rubyonrails-talk+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msg/rubyonrails-talk/-/R8mT37V5SYUJ. For more options, visit https://groups.google.com/groups/opt_out.
