Urls with .html.html error magento 2.1.6

[jpcs]

Hi,

    have problem in mag 2.1.6 with .html.html urls displaying instead of .html

any help appreciated

[jpcs · Accepted solution]

i have solved my issue

Empty the product url rewrites from url_rewrite table, saving all products via Magento 2's mass update feature and finally updating the URL's with the mysql command mentioned below

mysql> UPDATE url_rewrite SET request_path = REPLACE(request_path, '.html.html', '.html');

solved the dilemma for us and we managed to get the extra .html away from product URL's.