#1833 Rails 2.2.2 looking for column that does not exist - Ruby on Rails

Type	To find
responsible:me	tickets assigned to you
tagged:"@high"	tickets tagged @high
milestone:next	tickets in the upcoming milestone
state:invalid	tickets with the state invalid
created:"last week"	tickets created last week
sort:number, importance, updated	tickets sorted by #, importance or updated
Combine keywords for powerful searching.
Use advanced searching »

This project is archived and is in readonly mode.

#1833 ✓invalid

Rails 2.2.2 looking for column that does not exist

Reported by Patrick | February 1st, 2009 @ 02:24 AM | in 2.x

Hi, I recently upgraded from Rails 2.0.2 to 2.1.2 with no problems, then I moved from 2.1.2 to 2.2.2 and have been noticing this strange error.

Mysql::Error: Unknown column 'domain_listings.id' in 'field list': SELECT domain_listings.id FROM domain_listings WHERE (domain_listings.domain_id = 2 AND domain_listings.listing_id = 12) LIMIT 1

domain_listings is a join table and id does not exist, the columns are domain_id and listing_id. As I mentioned, no problem with this in 2.1.2. Any guidance would be appreciated.

Comments and changes to this ticket

You flagged this item as spam.
Scott Taylor February 1st, 2009 @ 05:13 AM
Can you provide more information? What is the schema of those two tables? What AR call is triggering this query?
You flagged this item as spam.
Patrick February 1st, 2009 @ 05:56 AM
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...
- unknown_col_error.txt 23 KB
You flagged this item as spam.
Patrick February 1st, 2009 @ 06:39 PM
I attached some more schema information.
- schemainfo.txt 604 Bytes
You flagged this item as spam.
Patrick February 14th, 2009 @ 07:14 PM
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.
You flagged this item as spam.
siong1987 February 15th, 2009 @ 02:35 AM
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
Pratik March 8th, 2009 @ 01:26 PM
- Assigned user changed from “Frederick Cheung” to “Pratik”
- State changed from “new” to “invalid”
You should try to submit a failing test case. http://guides.rails.info/contrib... might come handy!

Thanks.