1

In my Rails application, I use Devise gem for authenticating users. I need to skip email validation if I create a user from the admin panel. So far I have this code:

# User model
class User < ApplicationRecord
  attr_accessor :skip_email_validation

  devise :database_authenticatable, :registerable,
         :recoverable, :rememberable, :trackable

  validates :email, presence: true, uniqueness: true, unless: :skip_email_validation
end

#User's controller create action
class Admin::UsersController < Admin::AdminController
  def create
    @user = User.new(user_params)
    @user.skip_email_validation = true
    if @user.save
      redirect_to admin_user_path(@user), success: 'User created.'
    else
      render :new
    end
  end
end

So, when I created the first user without email, it was saved into the database, but when I create another user without email, I have an error: 

Mysql2::Error: Duplicate entry '' for key 'index_users_on_email': INSERT INTO `users`

I don't understand what is causing this error, because I skip the validation of presence and uniqueness in the model. Thanks ahead for an answer.

Alex Zakruzhetskyi
  • 1,383
  • 2
  • 22
  • 43

1 Answers1

2

You might need to make changes on the database level.

Devise uses unique index on Users table.

Devise has following in its migration:

add_index :users, :email, unique: true

which results in the following in your db/schema.rb

t.index ["email"], name: "index_users_on_email", unique: true

You need to change that in the migrations/schema and reset your database. `

Kartikey Tanna
  • 1,423
  • 10
  • 24