ActiveRecord::StatementInvalid: Mysql2::Error: Incorrect datetime value:

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', 'michael@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', 'michael@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: michael@example.  com
password_digest: <%= User.digest('password') %>
  admin: true
  activated: true
  activated_at: <%= Time.zone.now %>

archer:
  name: Sterling Archer
  email: duchess@example.  gov
password_digest: <%= User.digest('password') %>
  activated: true
  activated_at: <%= Time.zone.now %>

lana:
  name: Lana Kane
  email: hands@example.  gov
password_digest: <%= User.digest('password') %>
  activated: true
  activated_at: <%= Time.zone.now %>

mallory:
  name: Mallory Archer
  email: boss@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: "example@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 [“to@example.org”], mail.to
assert_equal [“from@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 [“to@example.org”], mail.to
assert_equal [“from@example.com”], mail.from
assert_match “Hi”, mail.body.encoded
end
end

Is there something I am doing wrong? Thank you for your help.

Try toLocaleFormat()

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

Michael,

My bad toLocaleFormat work for JS , Can you try this ? to convert into a database friendly format. source

activated_at: <%= Time.zone.now.to_s(:db) %>

Google found this which, whilst it is old, may be relevant.

http://jitu-blog.blogspot.co.uk/2009/04/datetime-with-zone-support-in-rails.html

However I also suggest that using time.now in a fixture is not a good
idea as it means the data are different each time the test is run,
which could give inconsistent results. I suggest instead using fixed
times, something like

activated_at: 2014-07-14 20:53:32

Colin