Laravel unique validation rule with except not working

Question

Laravel unique validation rule with except column not working on update, what's wrong in my code ?

public function update(Request $request, Article $article)
{
    abort_if($article->user_id !== $request->user()->id, 403);

    $article = $request->user()->articles()->update($request->validate([
        'title' => [
            'required',
            Rule::unique('articles', 'title')->ignore($article->id)
        ],
        'content'=>'required|min:90',
    ]));

    return redirect('articles/'.$article->id)->withSuccess('Article saved.');
}

Error : The title has already been taken.

Laravel version : 6.4.0

Thanks for help

Pedro Costa · Accepted Answer · 2019-10-28 16:30:25Z

2

You can pass the entire instance of article to validate like:

Rule::unique('articles')->ignore($article);

Because you are already saying what column to check.

https://laravel.com/docs/6.x/validation

answered Oct 28, 2019 at 16:30

Pedro Costa

1948 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

erbelion Over a year ago

tysm. ignore by id didnt work, this works perfectly.

Benyou1324 · Accepted Answer · 2019-10-28 16:32:51Z

1

Remove title from

Rule::unique('articles', 'title')->ignore($article->id)

to

...
$article = $request->user()->articles()->update($request->validate([
        'title' => [
            'required',
            Rule::unique('articles')->ignore($article->id)
        ],
        'content'=>'required|min:90',
    ]));
...

Hope this helps

more info, check rule-unique

edited Oct 28, 2019 at 16:32

answered Oct 28, 2019 at 16:30

Benyou1324

5211 gold badge5 silver badges18 bronze badges

1 Comment

Simpledev Over a year ago

It seems like I had duplicate titles in the database. I don't know why but I deleted all the duplicates in the database and now it works. Rule::unique('articles')->ignore($article->id) and Rule::unique('articles')->ignore($article) and Rule::unique('articles', 'title')->ignore($article->id) are all working now.

apokryfos · Accepted Answer · 2019-10-28 16:47:32Z

1

If you run the update on $request->user()->articles() you will update all of the user's articles. If the user only has 1 article then it should work just fine, however if there are more then this will result in data being overwritten.

Instead do:

$article->update($request->validate([
    'title' => [
        'required',
        Rule::unique('articles', 'title')->ignore($article->id)
     ],
    'content'=>'required|min:90',
]));

answered Oct 28, 2019 at 16:47

apokryfos

40.9k11 gold badges85 silver badges128 bronze badges

Comments

LHC · Accepted Answer · 2023-07-12 07:04:31Z

0

If you use softDelete and you deleted an object that has the same title, don't forget to check if the deleted_at column is null.

    $request->validate([
        'title' => [
            'required',
            Rule::unique('articles', 'title')
                ->ignore($article->id)
                ->whereNull('deleted_at')
        ],
        'content'=>'required|min:90',
    ])

answered Jul 12, 2023 at 7:04

LHC

1

Collectives™ on Stack Overflow

Laravel unique validation rule with except not working

4 Answers 4

1 Comment

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related