# Has many through not working in ruby-enterprise

**URL:** <https://www.ruby-forum.com/t/has-many-through-not-working-in-ruby-enterprise/163697>\
**Category:** Rails\
**Created:** [March 24, 2009, 2:31am UTC](https://www.ruby-forum.com/t/has-many-through-not-working-in-ruby-enterprise/163697 "2009-03-24T02:31:14Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![mirec](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/919ad9/32.png) [@mirec](https://www.ruby-forum.com/u/mirec)\
**Post date:** [March 24, 2009, 2:31am UTC](https://www.ruby-forum.com/t/has-many-through-not-working-in-ruby-enterprise/163697/1 "2009-03-24T02:31:14Z")

</div>

hi,  
I have simple has many through association which is working without  
problem on ruby 1.8.6 and rails 2.0.2, but on ruby-enterprise with  
ruby 2.0.2 or 2.3.2 it just does not see “through” part of  
association.

class User \< ActiveRecord::Base  
has\_many :userships  
has\_many :user\_groups, :through =\> :userships  
end  
class UserGroup \< ActiveRecord::Base  
has\_many :userships  
has\_many :users, :through =\> :userships  
end  
class Usership \< ActiveRecord::Base  
belongs\_to :user  
belongs\_to :user\_group  
end

as i am moving app to new server, i am getting these errors:

ActiveRecord::StatementInvalid: Mysql::Error: Unknown column  
‘user\_groups.user\_id’ in ‘where clause’: SELECT \* FROM `user_groups`  
WHERE (`user_groups`.user\_id = 8)  
from /usr/local/ruby-enterprise/lib/ruby/gems/1.8/gems/  
activerecord-2.3.2/lib/active\_record/connection\_adapters/  
abstract\_adapter.rb:212:in `log' from /usr/local/ruby-enterprise/lib/ruby/gems/1.8/gems/ activerecord-2.3.2/lib/active_record/connection_adapters/ mysql_adapter.rb:320:in`execute’  
from /usr/local/ruby-enterprise/lib/ruby/gems/1.8/gems/  
activerecord-2.3.2/lib/active\_record/connection\_adapters/  
mysql\_adapter.rb:595:in `select' from /usr/local/ruby-enterprise/lib/ruby/gems/1.8/gems/ activerecord-2.3.2/lib/active_record/connection_adapters/abstract/ database_statements.rb:7:in`select\_all\_without\_query\_cache’  
from /usr/local/ruby-enterprise/lib/ruby/gems/1.8/gems/  
activerecord-2.3.2/lib/active\_record/connection\_adapters/abstract/  
query\_cache.rb:62:in `select_all' from /usr/local/ruby-enterprise/lib/ruby/gems/1.8/gems/ activerecord-2.3.2/lib/active_record/base.rb:661:in`find\_by\_sql’  
from /usr/local/ruby-enterprise/lib/ruby/gems/1.8/gems/  
activerecord-2.3.2/lib/active\_record/base.rb:1553:in `find_every' from /usr/local/ruby-enterprise/lib/ruby/gems/1.8/gems/ activerecord-2.3.2/lib/active_record/base.rb:615:in`find’  
from /usr/local/ruby-enterprise/lib/ruby/gems/1.8/gems/  
activerecord-2.3.2/lib/active\_record/associations/  
association\_collection.rb:60:in `find' from /usr/local/ruby-enterprise/lib/ruby/gems/1.8/gems/ activerecord-2.3.2/lib/active_record/associations/ association_collection.rb:395:in`find\_target’  
from /usr/local/ruby-enterprise/lib/ruby/gems/1.8/gems/  
activerecord-2.3.2/lib/active\_record/associations/  
association\_collection.rb:349:in `load_target' from /usr/local/ruby-enterprise/lib/ruby/gems/1.8/gems/ activerecord-2.3.2/lib/active_record/associations/association_proxy.rb: 139:in`inspect’

obviously, association is not correctly understood by ruby and  
“through” part of it is not taken

anybody having similar problem? any ideas?

---

<div class="post-metadata">

**Author:** ![mirec](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/919ad9/32.png) [@mirec](https://www.ruby-forum.com/u/mirec)\
**Post date:** [March 24, 2009, 5:04pm UTC](https://www.ruby-forum.com/t/has-many-through-not-working-in-ruby-enterprise/163697/2 "2009-03-24T17:04:55Z")

</div>

forgot to mention

as i am moving app to new server where i am testing it with REE, i am  
getting these errors:

happens on this line on User model:  
self.user\_groups.include?(UserGroup.find(gr))

---

<div class="post-metadata">

**Author:** ![mirec](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/919ad9/32.png) [@mirec](https://www.ruby-forum.com/u/mirec)\
**Post date:** [March 24, 2009, 5:16pm UTC](https://www.ruby-forum.com/t/has-many-through-not-working-in-ruby-enterprise/163697/3 "2009-03-24T17:16:40Z")

</div>

now i found in console, that it works in development mode, also  
running from mongrel is fine

> > u=User.find(8)  
> > =\> #\<User id: 8, …

> > u.user\_groups  
> > =\> [#\<UserGroup id: 1, name: …

---

<div class="post-metadata">

**Author:** ![mirec](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/919ad9/32.png) [@mirec](https://www.ruby-forum.com/u/mirec)\
**Post date:** [March 24, 2009, 6:25pm UTC](https://www.ruby-forum.com/t/has-many-through-not-working-in-ruby-enterprise/163697/4 "2009-03-24T18:25:04Z")

</div>

now this is one of the weirdest

action which has:

logger.info curent\_user.user\_groups.inspect

in itself runs properly