Rails 2.2.2 looking for column that does not exist

Can you provide more information? What is the schema of those two tables? What AR call is triggering this query?

This is the code from the form that is creating the sql

<%= select_tag('domain_listings[domain_id][]', options_from_collection_for_select(Domain.find(:all), 'id', 'name', @listing.domains.collect {|d| d.id}), :multiple => true, :size => 5

I've also attached part of my dev log file that shows the error. As I mentioned, the query worked up to 2.1.2 and then broke when I upgraded to 2.2.2. Thanks for the quick response...

I attached some more schema information.

Just wondered if anyone had a chance to look at this yet? right now I'm sticking to rails 2.1.2 until I at least have a work around. Maybe I need to find a way for it to write a different sql.

Since the information that you provided is not really enough, you can try this:

class DomainListing < ActiveRecord::Base belongs_to :listing belongs_to :domain, :foreign_key => 'domain_id' end