foldermembers.rb

"(users.invalid_email is null\n  and users.email_updates = 1\n  and users.email_weekly_updates != 1\n  and users.email_hourly_updates != 1\n  and users.email  not in (select email from email_blacklist))"

# this works but gives a ReadOnlyRecord error
FolderMember.chunky_find(:conditions => where, :joins => "JOIN users ON users.id = user_id") do |member|
  puts member.id
  member.frequency = "daily"
  member.save
end

# this give an unknown column 'users.invalid_email' error
FolderMember.each(:conditions => where, :joins => "JOIN users ON users.id = user_id") do |member|
  puts member.id
  member.frequency = "daily"
  member.save
end