Wrong URL addresses for products and categories

[serzhik]

After data migration of two different stores on Magento 1.9.2.0 and 1.9.2.1 all products and categories URLs has extra ".html".

Example:
Before migration: site.com/product.html, site.com/category.html;
After migration: site.com/product.html.html, site.com/category.html.html;

[andidhouse]

same here after migration from 1.7.0.2...

[serzhik]

The problem is in url_rewrite table.

[serzhik]

To fix it after migration run this query at MySQL:

DELETE FROM `url_rewrite` WHERE CONCAT(`request_path`,".html")=`target_path`;
UPDATE url_rewrite SET request_path = REPLACE(request_path, '.html.html', '.html') WHERE request_path LIKE '%.html.html%';
UPDATE url_rewrite SET target_path = REPLACE(target_path, '.html.html', '.html') WHERE target_path LIKE '%.html.html%';

[andidhouse]

Yes. another way is to totally truncate the url_rewrite database. Then on save of a product or category the table is regenerated (but you must save all products and categories to achieve this). Would be nice to fix this one in the tool...

[ilol]

@serzhik did you resolve the issue? can close?

[ilol]

Thank you @andidhouse ! We are discussind your suggestion internally

[ilol]

MAGETWO-52158