hallo everybody,
i already googled the following problem, but there are so many
questions regarding "has_many :through", that i just couldn''t
find
what i was looking for. so, i''m really sorry if this has been asked
before. if so, just drop me the link.
i have a has_many :through relationship similar to the following
example:
class Group < ActiveRecord::Base
has_many :group_memberships,
:dependent => :destroy
has_many :admins,
:through => :group_memberships,
:source => :user,
:conditions => ''is_admin = true AND pending = false''
end
class GroupMembership < ActiveRecord::Base
belongs_to :group
belongs_to :user
end
class User < ActiveRecord::Base
has_many :group_memberships
has_many :administrations,
:through => :group_memberships,
:source => :group,
:conditions => "is_admin = true AND pending = false "
end
this is working fine. i even started a new rails-project and tried it
there. no problem.
now in an existing project of mine i sometimes get the following:
g = Group.first
=> #<Group id: 1, created_at: "2009-10-28 11:42:36", updated_at:
"2009-10-28 11:42:36">>> g.admins.include? User.first
ArgumentError: wrong number of arguments (1 for 0)
from /usr/lib64/ruby/gems/1.8/gems/activerecord-2.3.4/lib/
active_record/connection_adapters/mysql_adapter.rb:226:in `kind_of?''
from /usr/lib64/ruby/gems/1.8/gems/activerecord-2.3.4/lib/
active_record/connection_adapters/mysql_adapter.rb:226:in `quote''
from /usr/lib64/ruby/gems/1.8/gems/activerecord-2.3.4/lib/
active_record/base.rb:2392:in `quote_bound_value''
from /usr/lib64/ruby/gems/1.8/gems/activerecord-2.3.4/lib/
active_record/base.rb:2352:in `replace_bind_variables''
from /usr/lib64/ruby/gems/1.8/gems/activerecord-2.3.4/lib/
active_record/base.rb:2352:in `gsub''
from /usr/lib64/ruby/gems/1.8/gems/activerecord-2.3.4/lib/
active_record/base.rb:2352:in `replace_bind_variables''
from /usr/lib64/ruby/gems/1.8/gems/activerecord-2.3.4/lib/
active_record/base.rb:2320:in `sanitize_sql_hash_for_conditions''
from /usr/lib64/ruby/gems/1.8/gems/activerecord-2.3.4/lib/
active_record/base.rb:2231:in `sanitize_sql''
from /usr/lib64/ruby/gems/1.8/gems/activerecord-2.3.4/lib/
active_record/base.rb:2006:in `expand_id_conditions''
from /usr/lib64/ruby/gems/1.8/gems/activerecord-2.3.4/lib/
active_record/base.rb:692:in `exists?''
from /usr/lib64/ruby/gems/1.8/gems/activerecord-2.3.4/lib/
active_record/associations/association_collection.rb:380:in `send''
from /usr/lib64/ruby/gems/1.8/gems/activerecord-2.3.4/lib/
active_record/associations/association_collection.rb:380:in
`method_missing_without_paginate''
from /usr/lib64/ruby/gems/1.8/gems/activerecord-2.3.4/lib/
active_record/base.rb:2143:in `with_scope''
from /usr/lib64/ruby/gems/1.8/gems/activerecord-2.3.4/lib/
active_record/associations/association_proxy.rb:206:in `send''
from /usr/lib64/ruby/gems/1.8/gems/activerecord-2.3.4/lib/
active_record/associations/association_proxy.rb:206:in `with_scope''
from /usr/lib64/ruby/gems/1.8/gems/activerecord-2.3.4/lib/
active_record/associations/association_collection.rb:376:in
`method_missing_without_paginate''
from /home/n0ne/_files/work/beagile/code/comuungo/vendor/
plugins/will_paginate/lib/will_paginate/finder.rb:170:in
`method_missing''
from /usr/lib64/ruby/gems/1.8/gems/activerecord-2.3.4/lib/
active_record/associations/association_collection.rb:336:in `include?''
from (irb):3>>
however, when i reload that association before asking for admins it is
working:>> g.admins
=> []>> g.admins.include? User.last
=> false
same thing:
Group.first.admins.include? User.last
=> Exception (see above)
Group.first.admin_ids.include? User.last
=> false
I already checked will_paginate as it is mentioned in the trace. But
in my test-project i set up it is working perfectly with the above
code and will_paginate installed.
Has anyone ever seen a behaviuor like this? Any clues, hints or tipps?
On Nov 17, 12:11 pm, MaD <mayer.domi...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> hallo everybody, > > has_many :admins, > :through => :group_memberships, > :source => :user, > :conditions => ''is_admin = true AND pending = false''Try changing that to :conditions => [''is_admin = true AND pending false''] Fred> end > > class GroupMembership < ActiveRecord::Base > belongs_to :group > belongs_to :user > end > > class User < ActiveRecord::Base > has_many :group_memberships > > has_many :administrations, > :through => :group_memberships, > :source => :group, > :conditions => "is_admin = true AND pending = false " > end > > this is working fine. i even started a new rails-project and tried it > there. no problem. > > now in an existing project of mine i sometimes get the following: > g = Group.first > => #<Group id: 1, created_at: "2009-10-28 11:42:36", updated_at: > "2009-10-28 11:42:36">>> g.admins.include? User.first > > ArgumentError: wrong number of arguments (1 for 0) > from /usr/lib64/ruby/gems/1.8/gems/activerecord-2.3.4/lib/ > active_record/connection_adapters/mysql_adapter.rb:226:in `kind_of?'' > from /usr/lib64/ruby/gems/1.8/gems/activerecord-2.3.4/lib/ > active_record/connection_adapters/mysql_adapter.rb:226:in `quote'' > from /usr/lib64/ruby/gems/1.8/gems/activerecord-2.3.4/lib/ > active_record/base.rb:2392:in `quote_bound_value'' > from /usr/lib64/ruby/gems/1.8/gems/activerecord-2.3.4/lib/ > active_record/base.rb:2352:in `replace_bind_variables'' > from /usr/lib64/ruby/gems/1.8/gems/activerecord-2.3.4/lib/ > active_record/base.rb:2352:in `gsub'' > from /usr/lib64/ruby/gems/1.8/gems/activerecord-2.3.4/lib/ > active_record/base.rb:2352:in `replace_bind_variables'' > from /usr/lib64/ruby/gems/1.8/gems/activerecord-2.3.4/lib/ > active_record/base.rb:2320:in `sanitize_sql_hash_for_conditions'' > from /usr/lib64/ruby/gems/1.8/gems/activerecord-2.3.4/lib/ > active_record/base.rb:2231:in `sanitize_sql'' > from /usr/lib64/ruby/gems/1.8/gems/activerecord-2.3.4/lib/ > active_record/base.rb:2006:in `expand_id_conditions'' > from /usr/lib64/ruby/gems/1.8/gems/activerecord-2.3.4/lib/ > active_record/base.rb:692:in `exists?'' > from /usr/lib64/ruby/gems/1.8/gems/activerecord-2.3.4/lib/ > active_record/associations/association_collection.rb:380:in `send'' > from /usr/lib64/ruby/gems/1.8/gems/activerecord-2.3.4/lib/ > active_record/associations/association_collection.rb:380:in > `method_missing_without_paginate'' > from /usr/lib64/ruby/gems/1.8/gems/activerecord-2.3.4/lib/ > active_record/base.rb:2143:in `with_scope'' > from /usr/lib64/ruby/gems/1.8/gems/activerecord-2.3.4/lib/ > active_record/associations/association_proxy.rb:206:in `send'' > from /usr/lib64/ruby/gems/1.8/gems/activerecord-2.3.4/lib/ > active_record/associations/association_proxy.rb:206:in `with_scope'' > from /usr/lib64/ruby/gems/1.8/gems/activerecord-2.3.4/lib/ > active_record/associations/association_collection.rb:376:in > `method_missing_without_paginate'' > from /home/n0ne/_files/work/beagile/code/comuungo/vendor/ > plugins/will_paginate/lib/will_paginate/finder.rb:170:in > `method_missing'' > from /usr/lib64/ruby/gems/1.8/gems/activerecord-2.3.4/lib/ > active_record/associations/association_collection.rb:336:in `include?'' > from (irb):3>> > > however, when i reload that association before asking for admins it is > working:>> g.admins > => [] > >> g.admins.include? User.last > > => false > > same thing: > Group.first.admins.include? User.last > => Exception (see above) > Group.first.admin_ids.include? User.last > => false > > I already checked will_paginate as it is mentioned in the trace. But > in my test-project i set up it is working perfectly with the above > code and will_paginate installed. > > Has anyone ever seen a behaviuor like this? Any clues, hints or tipps?
On Nov 17, 7:11 am, MaD <mayer.domi...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> ArgumentError: wrong number of arguments (1 for 0) > from /usr/lib64/ruby/gems/1.8/gems/activerecord-2.3.4/lib/ > active_record/connection_adapters/mysql_adapter.rb:226:in `kind_of?''There''s clearly some sort of collision going on between an attribute method and the built-in definition of kind_of? - every Ruby object defines the one-argument form, so the fact that it''s finding a 0- argument version is a sign. Somewhat unrelated, but you may want to declare these kind of flag associations using bind variables; it''s not strictly necessary, but it''s good practice to ensure cross-DB compatibility. In other words, use this: :conditions => ["is_admin = ? AND pending = ?", true, false] Otherwise, you may get weird errors when you switch your DB (to, for example, an in-memory SQLite3 for test speed) and the new DB doesn''t escape booleans the same way. --Matt Jones -- 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-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=.
thanks a lot for your replies! i already changed my :conditions. but i have an additional question about that: should i change :order-statements accordingly (to also include the brackets)? as for my original problem: thanks matt! your post put me into a new direction. i really found an old (obsolete) ''type_of''-attribute inside my user-model. your explanation seems to have a point. i did not try it yet, but i''m pretty sure that it would solve my problem. thanks again. -- 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-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
On Nov 24, 11:05 am, MaD <mayer.domi...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> thanks a lot for your replies! > > i already changed my :conditions. but i have an additional question > about that: should i change :order-statements accordingly (to also > include the brackets)? >No. (and changing conditions isn''t necessary - I just had a (probably wrong) hunch about what might be wrong)). A dangerously named attribute/method is far more likely Fred> as for my original problem: > thanks matt! your post put me into a new direction. i really found an > old (obsolete) ''type_of''-attribute inside my user-model. your > explanation seems to have a point. i did not try it yet, but i''m > pretty sure that it would solve my problem. > > thanks again.-- 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-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
just tried it. removing the kind_of-attribute did the trick! THANKS! that bug was really getting annoying. -- 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-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.