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?!