Hello core, When using conditions from a variable, it can sometimes be an empty hash (at least in my projects). When using it with count on a ActiveRecord::Base: User.count :conditions => {} # => 3 But when working on a has_many association, this happens: >> User.first.certificates.count :conditions => {} ActiveRecord::StatementInvalid: Mysql::Error: #42000You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''))'' at line 1: SELECT count(*) AS count_all FROM `certificates` WHERE (`certificates`.user_id = 442758120 AND ()) a patch to this bug can be found on http://rails.lighthouseapp.com/projects/8994/tickets/271-make-count-conditions-work-on-has_many-associations#ticket-271-1 Regards, Jan De Poorter --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Core" group. To post to this group, send email to rubyonrails-core@googlegroups.com To unsubscribe from this group, send email to rubyonrails-core-unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-core?hl=en -~----------~----~----~----~------~----~------~--~---