Magento 2.4.2-p1
Smartwave Porto theme
We migrated from Magento 1.9.4 to Magento 2.4.2-p1. We keep getting the following Error when working with products:
The value specified in the URL Key field would generate a URL that already exists.
To resolve the conflict, you can either change the value of the URL key field 9located in the Search Engine Optimization section to a unique value, or change the Request Path fields in all locations listed below:
and a list of usually 4 URLs
Is there a script I could run in phpMyAdmin to get a list of all duplicate URLs so that I could go through them all and change the URL of each product?