Rails 4 - unit test failing to create model object

Question

I want to unit test an application using shoulda.

In the test i'm doing

User.create!(name: "James")

When i run the test i'm getting the following error:

ActiveRecord::StatementInvalid: Mysql2::Error: Field 'name' doesn't have a default value: INSERT INTO `users` (`created_at`, `updated_at`, `id`) VALUES ('2014-04-07 12:03:07', '2014-04-07 12:03:07', 980190962)

Has this something to do with rails 4 strong parameters?

How can i solve this?

reto · Accepted Answer · 2014-04-09T12:22:04.673

3

Check if you have invalid fixtures laying around. Try deleting/fixing test/fixtures/users.yml

Note: You should get full stacktraces in the unit tests by disabling the backtrace silencers in config/initializers/backtrace_silencers.rb.

edited Apr 09 '14 at 12:22

answered Apr 08 '14 at 20:16

reto

16,189
7
53
67

This was my problem because of the generated .yml fixtures that were created earlier by rails. Make sure that all of your other fixtures are commented out or fixed to be correct. Thanks! – DustinA Dec 07 '14 at 05:06

score 0 · Answer 2 · answered Apr 07 '14 at 15:44

Has this something to do with rails 4 strong parameters?

No, Strong Parameters have nothing to do with this because you are creating your object directly from a hash and not from any ActionController::Parameters.

The issue comes from somewhere else (probably your database).

As I can see from this article, a solution to your problem could be to migrate your field like that:

change_column :users, :name, :string, :limit => 255, :null => false, :default => ''

score 0 · Answer 3 · answered Mar 10 '17 at 10:52

I got similar issue while running unit tests. This may happen if your mysql DB connection is in strict mode. Disable strict mode by adding setting in database.yml as below and try.

test:
  database:
    host: localhost
    name: test_db
    username: username
    password: password    
    strict: false

Rails 4 - unit test failing to create model object

3 Answers3