ActiveRecord::StatementInvalid in Devise::RegistrationsContr

Question

我正在尝试为我的设计用户模型添加一些额外信息

当我填写注册表格并单击提交时，我会收到此错误：

sqlite3 :: drabtaintexception：不是null约束失败：users.first_name：插入"用户"（"电子邮件"，" encrypted_passed_password"，" created_at"，" updated_at"）valution（？，？，？，？，？）

def each
  loop do
    val = step
    break self if done?
    yield val
  end

，如果有任何用途，这些是参数：

参数：

{" utf8" =>"✓"， " Authenticity_token" =>" 2E5OUWMW84HTWSUI09X1O5KJPLYK7SW4VKGGOOXCB93W7SSSQYJPGQ3N/BGO0 OAEIFHEC4LQ4LQ3PUT99VUB17GS7G =="， "用户" => {" first_name" =>" test"，" last_name" =>" test"，" age" =>" 69"，" city" =>"纽约"，"性别" =>" trans"，" email"=>" [e-mail]"，" password" =>" [过滤]"，" password_confirnation" =>" [efftered]"}， " commit" =>"注册"}

这是我的schema.rb，以防万一：

create_table "users", force: :cascade do |t|
    t.string   "email",                  default: "", null: false
    t.string   "encrypted_password",     default: "", null: false
    t.string   "reset_password_token"
    t.datetime "reset_password_sent_at"
    t.datetime "remember_created_at"
    t.integer  "sign_in_count",          default: 0,  null: false
    t.datetime "current_sign_in_at"
    t.datetime "last_sign_in_at"
    t.string   "current_sign_in_ip"
    t.string   "last_sign_in_ip"
    t.string   "confirmation_token"
    t.datetime "confirmed_at"
    t.datetime "confirmation_sent_at"
    t.string   "unconfirmed_email"
    t.string   "first_name",                          null: false
    t.string   "last_name",                           null: false
    t.integer  "age",                                 null: false
    t.string   "city",                                null: false
    t.string   "gender",                              null: false
    t.datetime "created_at",                          null: false
    t.datetime "updated_at",                          null: false
    t.index ["confirmation_token"], name: "index_users_on_confirmation_token", unique: true
    t.index ["email"], name: "index_users_on_email", unique: true
    t.index ["reset_password_token"], name: "index_users_on_reset_password_token", unique: true
  end

这也是我的用户。RB模型：

class User < ApplicationRecord
  # Include default devise modules. Others available are:
  # :confirmable, :lockable, :timeoutable and :omniauthable
  devise :database_authenticatable, :registerable,
         :recoverable, :rememberable, :trackable, :validatable
end

Answer 1

要在devise中设置其他列上的其他列，我允许以这种方式访问我的applicationContoller。rails4

before_filter :configure_permitted_parameters, if: :devise_controller?
protected
def configure_permitted_parameters
  # Only add some parameters
  devise_parameter_sanitizer.for(:accept_invitation).concat [:first_name, :last_name]
end

或

before_action :configure_permitted_parameters, if: :devise_controller?
protected
def configure_permitted_parameters
  devise_parameter_sanitizer.for(:sign_up) << :full_name
end

这将允许您使用first_name last_name和您已设置的其他内容。

rails5

def configure_permitted_parameters
  additional_params = [:name, :company, :email_confirmation,   {addresses_attributes: [:address1, :address2, :city, :state, :zip, :country, :name]}]
  devise_parameter_sanitizer.permit(:sign_up, keys: additional_params)
  devise_parameter_sanitizer.permit(:account_update, keys: additional_params)
end

Answer 2

您在电子邮件中具有唯一的索引。错误的说法是，您要保存的电子邮件在数据库中并非零。用户已经有此电子邮件。更改电子邮件，它应该起作用。

  # to check for the user in the database 
  rails c 
  user = User.find_by_email("[e-mail]") should bring back a user.