Magento 1.9 URL Rewrites Not Working After Update

indexingmagento-1.9url-rewrite

Our redirects aren't working anymore – properply after updating to Magento 1.9.3.1.

The rewrites are still present in the URL Rewrites. If I click on one of them and save it (without editing anything), then it works again.

Any ideas how to "re-apply" them, without manually saving each and everyone?
(Reindexing does not fix the issue.

Example:

https://www.fyr-selv.dk/Briketter/SEDI-Toervebriketter/SEDI-Toervebriketter-k111-i46.html

URL rewrite

UPDATE:

Seem's to be 1.9.3.1 bug caused by changes to rewrites and case sensitivity.
When i save a rewrite, then requestpath changes all uppercase characters to lowercase. This matches the fix description in Magento changelog regarding rewrites:

Case-sensitive variations of URL rewrites work as expected.

But seems like the update lacks to change this for all current rewrites.

Rewrites changes casing

Best Answer

SQL: UPDATE core_url_rewrite SET request_path = LOWER(request_path) fixes the issue.

This is caused by Magento 1.9.3.1 changes, making request_path entries that are not all lowercase invalid.

Related Topic