Validation rule unique requires at least 1 parameters

Question

I've got problem with my laravel I can't post the data

One error says

InvalidArgumentException in Validator.php line 2593:
Validation rule unique requires at least 1 parameters.

And here it's my code

public function postUbah(Request $request, $id)

    $validator  = Validator::make($request->all(), [
            'username'  => 'required|unique:user|min:5',
            'name'      => 'required',
            'group'     => 'required'
        ]);
}

Thanks for the help.

Here it's my model

class User extends Model implements AuthenticatableContract, CanResetPasswordContract {

    use Authenticatable, CanResetPassword;


    protected $table = 'user';


    protected $fillable = ['username', 'password'];


    protected $hidden = ['password', 'remember_token'];

@CandraHerk 'required|min:5|unique:user,username', or 'required|string|username||min:5|unique:user', — bipin, Jan 31 '18 at 04:16
@CandraHerk change you table name users then try and let me know — bipin, Jan 31 '18 at 04:28
If I change the table name into users has result "SQLSTATE[42S02]: Base table or view not found: 1146 Table 'evalearn.user' doesn't exist (SQL: select * from `user` where `user`.`id` = 1 limit 1)" — Candra Herk, Jan 31 '18 at 04:30
@CandraHerk change or add your user modal with this $protect table="user", — bipin, Jan 31 '18 at 04:43
@CandraHerk open your App/User modal and add this line $protect table="user" and then try and let me know — bipin, Jan 31 '18 at 05:10
@CandraHerk are you sure this is the code that you are using?? please provide the actual code that you are using and your user schema — Sohel0415, Jan 31 '18 at 05:16
@bipin i've already adding the code but still error in the same way. — Candra Herk, Jan 31 '18 at 06:28
@CandraHerk delete your validation and try this $validator = Validator::make($request->all(), [ 'username' => 'required|unique:user,username', 'name' => 'required', 'group' => 'required', ]); clear your cache — bipin, Jan 31 '18 at 06:54
@CandraHerk delete your validation and try this $validator = Validator::make($request->all(), [ 'username' => 'required|unique:user', 'name' => 'required', 'group' => 'required', ]); clear your cache,is your input name is username,check if it start with capital letter — bipin, Jan 31 '18 at 07:02
Clear, but it raised the new error said : "TokenMismatchException in VerifyCsrfToken.php line 46:" — Candra Herk, Jan 31 '18 at 07:10
@bipin Clear, but it raised the new error said : "TokenMismatchException in VerifyCsrfToken.php line 46:" — Candra Herk, Jan 31 '18 at 07:15
@CandraHerk refresh your browser it will reslove press crtl + f5 — bipin, Jan 31 '18 at 07:21
@bipin CTRL+F5 and the result back to "Validation rule unique requires at least 1 parameters" — Candra Herk, Jan 31 '18 at 07:26
@bipin you can download it on https://www.dropbox.com/s/bn253ggbzvjqt3d/Php%20Error.rar?dl=0 — Candra Herk, Jan 31 '18 at 07:35
@CandraHerk it working in my system i just change this thing Evalearn to app what is this Evalearn — bipin, Jan 31 '18 at 08:20

score 13 · Answer 1 · answered Jan 31 '18 at 03:24

You've forgot to add the parameter in validation rule to specify the database table column which should be unique in validation rule. You can do it like,

 $validator  = Validator::make($request->all(), [
        'username'  => 'required|unique:user,name|min:5',
        'name'      => 'required',
        'group'     => 'required'
    ]);

ZeroOne · Accepted Answer · 2018-01-31T05:22:19.697

Why dont you just use like this

L5.5

public function postUbah(Request $request, $id)

    $validator  = $request->validate([
            'username'  => 'required|unique:user|min:5',
            'name'      => 'required',
            'group'     => 'required'
        ]);
}

L5.4

public function postUbah(Request $request, $id)
    $validator  = $this->validate($request, [
            'username'  => 'required|unique:user|min:5',
            'name'      => 'required',
            'group'     => 'required'
        ]);
}

Im aware that your table name is user.. make sure your User Model have

class User {
    protected $table = "user";
}

Mostafa Rafid · Answer 3 · 2021-10-02T19:58:44.693

1

Use "unique:users" instead of "unique:user". This can work for some cases.

edited Oct 02 '21 at 19:58

answered Oct 02 '21 at 19:40

Mostafa Rafid

71
6

Validation rule unique requires at least 1 parameters

3 Answers3

Linked

Related