# Association error using find since upgrading to Rails 2.1.1

**URL:** <https://www.ruby-forum.com/t/association-error-using-find-since-upgrading-to-rails-2-1-1/149325>\
**Category:** Rails\
**Created:** [September 23, 2008, 6:18pm UTC](https://www.ruby-forum.com/t/association-error-using-find-since-upgrading-to-rails-2-1-1/149325 "2008-09-23T18:18:42Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![danielb](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/c57346/32.png) [@danielb](https://www.ruby-forum.com/u/danielb)\
**Post date:** [September 23, 2008, 6:18pm UTC](https://www.ruby-forum.com/t/association-error-using-find-since-upgrading-to-rails-2-1-1/149325/1 "2008-09-23T18:18:42Z")

</div>

Hi all,

Ruby 1.8.6  
Rails 2.1.1

I have a simple association that works fine under 1.2.6 but is failing  
under 2.1.1.

require ‘active\_record’

ActiveRecord::Base.establish\_connection(  
:adapter =\> ‘postgresql’,  
:database =\> 'my\_database,  
:username =\> ‘postgres’  
)

class Schedule \< ActiveRecord::Base  
belongs\_to :user  
end

class User \< ActiveRecord::Base  
has\_many :schedules  
end

# This works with AR 2.1.1

s = Schedule.find(:first)  
p s.user\_id  
p s.user.cuid

# This does not with AR 2.1.1 =\> PGError: ERROR: column “cuid” does

not exist  
s = Schedule.find(  
:first,  
:include =\> [:user],  
:conditions =\> [“cuid = ?”, “foo”] # Also tried user.cuid  
)

What obvious bit am I missing?

Thanks,

Dan

---

<div class="post-metadata">

**Author:** ![danielb](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/c57346/32.png) [@danielb](https://www.ruby-forum.com/u/danielb)\
**Post date:** [September 23, 2008, 6:30pm UTC](https://www.ruby-forum.com/t/association-error-using-find-since-upgrading-to-rails-2-1-1/149325/2 "2008-09-23T18:30:28Z")

</div>

On 23 Sep 2008, at 17:10, Daniel B. wrote:

> 

You need to qualify that column name (ie users.cuid)

Fred

---

<div class="post-metadata">

**Author:** ![danielb](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/c57346/32.png) [@danielb](https://www.ruby-forum.com/u/danielb)\
**Post date:** [September 23, 2008, 6:38pm UTC](https://www.ruby-forum.com/t/association-error-using-find-since-upgrading-to-rails-2-1-1/149325/3 "2008-09-23T18:38:42Z")

</div>

When you make a find with ‘include’ you are using two tables in a SQL  
query,  
so you need to explicitly write the table\_name.row\_name when using  
conditions.

user is not the table, that’s why user.cuid didn’t work. users is the  
table  
name.

Remember:

Model == Singular  
table == plural

On Tue, Sep 23, 2008 at 11:29 AM, Frederick C. \<  
removed\_email\_address@domain.invalid\> wrote:

> > )
> 
> >

–  
ANDRES RODRIGUEZ E  
Electronic Engineer  
Software Developer  
IT Consultant

US Phone: (305) 853-8356  
Primary Mobile: +57-300-2006186  
Secondary Mobile: +57-314-7939859

---

<div class="post-metadata">

**Author:** ![danielb](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/c57346/32.png) [@danielb](https://www.ruby-forum.com/u/danielb)\
**Post date:** [September 23, 2008, 9:19pm UTC](https://www.ruby-forum.com/t/association-error-using-find-since-upgrading-to-rails-2-1-1/149325/4 "2008-09-23T21:19:31Z")

</div>

On Sep 23, 10:33 am, “Andres R.” [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:

> table == plural  
> Got it, thanks.

Dan