How to customize "email" field in Laravel auth?

Question

I'm trying to customize Laravel's authentication fields. I succeeded for the "name" and "password" fields, but not for the "email" field. I still have the error:

SQLSTATE[42S22]: Column not found: 1054 "email" field unknown in where clause.

I tried to rely on this this, but it didn't work. In RegisterController, I changed the create function to the following.

protected function create(array $data)
{
    return User::create([
        'user_pseudo' => $data['name'],
        'user_email' => $data['email'],
        'usr_mdp' => bcrypt($data['password']),
    ]);
}

Can you show user model? – Web Artisan May 08 '19 at 12:52 — Web Artisan, May 08 '19 at 12:52

score 0 · Accepted Answer · answered May 08 '19 at 09:54

This error could come from the unique validation of the email field in the validation method. If there's no column name specified it will use the name of the field as the column name.

Add the correct column name to the rule in which it's supposed to search for the email and this error should be gone:

RegisterController.php

protected function validator(array $data)
{
    return Validator::make($data, [
        'name' => ['required', 'string', 'max:255'],
        'email' => ['required', 'string', 'email', 'max:255', 'unique:users,user_email'],
        'password' => ['required', 'string', 'min:8', 'confirmed'],
    ]);
}

How to customize "email" field in Laravel auth?

1 Answers1