Level 3
You have set the slug unique that's why you are getting the error remove the unique it will work
May 21, 2020
5
Level 1
Updating existing product
Hi,
I'm working on a project where you can edit your product. Nothing special. I would accomplish the following:
- if user does not change the product url (slug) it should pass (check on id) - got that already working
- if user changes the value of the product url (slug) it should check in the table if that value is unique
I use this request validation for that. Which works for option 1.
$this->validate($request, [
'name' => 'required',
'description' => 'required',
'slug' => 'required|unique:products,id,'.$id.'',
]);
But when I update the slug too a new value which is the same as an other product in the table. I receive the following error.
Integrity constraint violation: 1062 Duplicate entry 'seo-url2' for key 'products_slug_unique
Does anyone have a solution for this? Thank you in advance
Level 1
Thank you for your reply.
Unfortunate it it's not working. When I remove the ->unique() from the slug in the migration and update the field to a same value as another product. It will store the same value.
In production this will means that 2 products have the same slug. Which determine the url of the product. For example: https://website.com/product/name-of-the-product/ where name-of-the-product is the slug.
Level 3
of course, if you remove the unique it will insert duplicate values so the only way is to set the custom validation if the slug is matched.
Level 2
this works for me !!
'slug' => 'required|unique:content|max:255',
and I belive this should work for you
'slug' => 'required|unique:products',
Here is the link to documentation: https://laravel.com/docs/7.x/validation#introduction
Level 18
try updating your rule
'slug' => 'required|unique:products,slug,'.$id,
make sure that the value of the $id is not null
Please or to participate in this conversation.