I actually have exactly the same problem as posted here An error occurred while saving the URL rewrite after upgrading from CE 184.108.40.206. to 220.127.116.11. I get the error:
An error occurred while saving the URL rewrite
the log file shows me this beautiful piece of work
exception 'PDOException' with message 'SQLSTATE: Integrity constraint violation: 1062 Duplicate entry 'category/subcategory1/subcategory2.html-3' for key 'UNQ_CORE_URL_REWRITE_REQUEST_PATH_STORE_ID'' in C:\directory
As in the link provided the problem does not lie in a product but rather in the categories. I have tried truncating the index, but this results in a php deadlock which I'm unable to resolve. As the above linked question does not have an adequate answer could someone please enlighten me how to fix this without truncating the core_url_rewrites table. Thank you so much in advance.