Magento 2 URL issues

Question

I use Magento 2.2.4 version, if I open a subcategories my URL have .html suffix in both: category and subcategory.

The url is look like this:

https://www.example.com/en/clothes.html/pants.html

and the product

https://www.example.com/en/clothes/pants.html/hot-pants.html

How I can made the url for categories to be like this:

https://www.example.com/en/clothes/pants.html

and the same for product, to remove the html suffix from url too:

https://www.example.com/en/clothes/pants/hot-pants.html

My Catalog SEO configuration is:

If I try to remove the Catalog URL Suffix I have the following error:

Unique constraint violation found

Answer 1

To re-generate all Url rewrites of the categories/products in all stores (it support a multi stores) run:

php bin/magento ok:urlrewrites:regenerate

To regenerate Url rewrites in the specific store view (e.g.: store view id is "2"):

php bin/magento ok:urlrewrites:regenerate 2

Don't forget to reindexing and flush the cache.