I am seeing this error when trying to perform a search/replace on the url_rewrites table:

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

SQL Error (1062): Duplicate entry 'myurl' for key 'URL_REWRITE_REQUEST_PATH_STORE_ID'

(I need to do this because my URLs are messed up and being formatted like this: category1/category2.html/category3/product-url)

I understand that there are unique constraints on this table but when I search for the offending rewrite that is given in the error message it is not found.

SELECT * FROM url_rewrite WHERE request_path LIKE '%myurl etc etc%';

So there is my confusion! How can it be a duplicate if there is not one there already?!

(Magento 2.2.5)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.