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
-~----------~----~----~----~------~----~------~--~---