Michael, My bad toLocaleFormat work for JS , Can you try this ? to convert into a database friendly format. source <http://stackoverflow.com/questions/1255983/ruby-datetime-suitable-for-mysql-comparison>
activated_at: <%= Time.zone.now.to_s(:db) %> On Sat, Dec 20, 2014 at 3:15 AM, Michael Sutyak <msut...@gmail.com> wrote: > HI Vivek, > > I got these new errors: > > 1) Error: > UserMailerTest#test_account_activation: > NoMethodError: undefined method `toLocaleFormat' for Fri, 19 Dec 2014 > 21:44:44 UTC +00:00:Time > > > > 2) Error: > UserMailerTest#test_password_reset: > NoMethodError: undefined method `toLocaleFormat' for Fri, 19 Dec 2014 > 21:44:44 UTC +00:00:Time > > > On Thu, Dec 18, 2014 at 9:27 PM, Vivek Sampara <ravensnowb...@gmail.com> > wrote: >> >> Try toLocaleFormat() >> >> On Fri, Dec 19, 2014 at 6:24 AM, Michael Sutyak <msut...@gmail.com> >> wrote: >> >>> am running a test with mailers within Ruby on Rails, and I am getting >>> the following errors: >>> >>> *********-C02MGBVJFD57:myapp ************$ bundle exec rake test:mailers >>> # Running: >>> >>> EE >>> Finished in 0.110500s, 18.0995 runs/s, 0.0000 assertions/s. >>> >>> 1) >>> Error:UserMailerTest#test_account_activation:ActiveRecord::StatementInvalid: >>> Mysql2::Error: Incorrect datetime value: '2014-12-18 01:07:49 UTC' for >>> column 'activated_at' at row 1: INSERT INTO `users` (`name`, `email`, >>> `password_digest`, `admin`, `activated`, `activated_at`, `created_at`, >>> `updated_at`, `id`) VALUES ('Michael Example', 'mich...@example.com', >>> '$2a$04$hz6pvZctid6gZEuv0.qAe.0mEfbEjxso9GrXwC3yHRhIThIJ7Vx5m', 1, 1, >>> '2014-12-18 01:07:49 UTC', '2014-12-18 01:07:49', '2014-12-18 01:07:49', >>> 762146111) >>> >>> >>> >>> 2) >>> Error:UserMailerTest#test_password_reset:ActiveRecord::StatementInvalid: >>> Mysql2::Error: Incorrect datetime value: '2014-12-18 01:07:49 UTC' for >>> column 'activated_at' at row 1: INSERT INTO `users` (`name`, `email`, >>> `password_digest`, `admin`, `activated`, `activated_at`, `created_at`, >>> `updated_at`, `id`) VALUES ('Michael Example', 'mich...@example.com', >>> '$2a$04$XTAWn5P9kikgOXqxQgiJqOjP027p4HnucHZ6pth2aaLwolaFcehsm', 1, 1, >>> '2014-12-18 01:07:49 UTC', '2014-12-18 01:07:49', '2014-12-18 01:07:49', >>> 762146111) >>> >>> 2 runs, 0 assertions, 0 failures, 2 errors, 0 skips >>> >>> When I check my fixtures users.yml file, I see that I am using the time >>> zone ruby stamp: >>> >>> michael: >>> name: Michael Example >>> email: mich...@example.com >>> password_digest: <%= User.digest('password') %> >>> admin: true >>> activated: true >>> activated_at: <%= Time.zone.now %> >>> >>> archer: >>> name: Sterling Archer >>> email: duch...@example.gov >>> password_digest: <%= User.digest('password') %> >>> activated: true >>> activated_at: <%= Time.zone.now %> >>> >>> lana: >>> name: Lana Kane >>> email: ha...@example.gov >>> password_digest: <%= User.digest('password') %> >>> activated: true >>> activated_at: <%= Time.zone.now %> >>> >>> mallory: >>> name: Mallory Archer >>> email: b...@example.gov >>> password_digest: <%= User.digest('password') %> >>> activated: true >>> activated_at: <%= Time.zone.now %> >>> <% 30.times do |n| %> >>> user_<%= n %>: >>> name: <%= "User #{n}" %> >>> email: <%= "user-#{n}@example.com" %> >>> password_digest: <%= User.digest('password') %> >>> activated: true >>> activated_at: <%= Time.zone.now %><% end %> >>> >>> and my db/seeds.rb file looks like so: >>> >>> User.create!(name: "Example User", >>> email: "exam...@railstutorial.org", >>> password: "foobar", >>> password_confirmation: "foobar", >>> admin: true, >>> activated: true, >>> activated_at: Time.zone.now) >>> 99.times do |n| >>> name = Faker::Name.name >>> email = "example-#{n+1}@railstutorial.org" >>> password = "password" >>> User.create!(name: name, >>> email: email, >>> password: password, >>> password_confirmation: password, >>> activated: true, >>> activated_at: Time.zone.now)end >>> >>> So I should be using the right time form. >>> >>> Here is the test itself: >>> >>> user_mailer_test.rb: >>> >>> require 'test_helper' >>> >>> class UserMailerTest < ActionMailer::TestCase >>> >>> test "account_activation" do >>> mail = UserMailer.account_activation >>> assert_equal "Account activation", mail.subject >>> assert_equal ["t...@example.org"], mail.to >>> assert_equal ["f...@example.com"], mail.from >>> assert_match "Hi", mail.body.encoded >>> end >>> >>> test "password_reset" do >>> mail = UserMailer.password_reset >>> assert_equal "Password reset", mail.subject >>> assert_equal ["t...@example.org"], mail.to >>> assert_equal ["f...@example.com"], mail.from >>> assert_match "Hi", mail.body.encoded >>> end >>> end >>> >>> Is there something I am doing wrong? Thank you for your help. >>> >>> -- >>> You received this message because you are subscribed to the Google >>> Groups "Ruby on Rails: Talk" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to rubyonrails-talk+unsubscr...@googlegroups.com. >>> To post to this group, send email to rubyonrails-talk@googlegroups.com. >>> To view this discussion on the web visit >>> https://groups.google.com/d/msgid/rubyonrails-talk/7c779d06-608c-46ac-ad27-15bda1365bf1%40googlegroups.com >>> <https://groups.google.com/d/msgid/rubyonrails-talk/7c779d06-608c-46ac-ad27-15bda1365bf1%40googlegroups.com?utm_medium=email&utm_source=footer> >>> . >>> For more options, visit https://groups.google.com/d/optout. >>> >> -- >> You received this message because you are subscribed to a topic in the >> Google Groups "Ruby on Rails: Talk" group. >> To unsubscribe from this topic, visit >> https://groups.google.com/d/topic/rubyonrails-talk/UDImbwXMpso/unsubscribe >> . >> To unsubscribe from this group and all its topics, send an email to >> rubyonrails-talk+unsubscr...@googlegroups.com. >> To post to this group, send email to rubyonrails-talk@googlegroups.com. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/rubyonrails-talk/CAFKVRj8h69dp7uoW1cdiMDwJ-Nqa__bCu7RMYcU35LjgXzzb0w%40mail.gmail.com >> <https://groups.google.com/d/msgid/rubyonrails-talk/CAFKVRj8h69dp7uoW1cdiMDwJ-Nqa__bCu7RMYcU35LjgXzzb0w%40mail.gmail.com?utm_medium=email&utm_source=footer> >> . >> >> For more options, visit https://groups.google.com/d/optout. >> > -- > You received this message because you are subscribed to the Google Groups > "Ruby on Rails: Talk" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to rubyonrails-talk+unsubscr...@googlegroups.com. > To post to this group, send email to rubyonrails-talk@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/rubyonrails-talk/CAMbJeJhZbg4NMrpLMcJAAfCYkhAGH4X0%2BOHDrmLYV8kdtFG6bg%40mail.gmail.com > <https://groups.google.com/d/msgid/rubyonrails-talk/CAMbJeJhZbg4NMrpLMcJAAfCYkhAGH4X0%2BOHDrmLYV8kdtFG6bg%40mail.gmail.com?utm_medium=email&utm_source=footer> > . > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To unsubscribe from this group and stop receiving emails from it, send an email to rubyonrails-talk+unsubscr...@googlegroups.com. To post to this group, send email to rubyonrails-talk@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/CAFKVRj_rKVkxcUhNQFUmq2GYw9cnugyfR5972fpSTwRiKvyhqA%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.