URL Rewrite error duplicated entry - open to bidding
$10-30 USD
Πληρώθηκε κατά την παράδοση
When I do reindex on url Rewrite table using [url removed, login to view] --reindex catalog_url, i always get error, so it cannot complete URL_rewrite index.
I have tried the following:
1. disable compliation 2. Clear all cache and flushed all cache 3. Deleted all .lock files under var folder. 4. Run the [url removed, login to view] --reindex catalog_url, it still doesn't work
I do not want the following:
1. I do not want to truncate core_url_rewrite tables since it will affect SEO
2. I do not want to change any code, e.g. url class etc.
I have attached production data CORE_URL_rewrite SQL files and CSV files. Use the one you prefer to use
I have attached full log files for the error. 1062 Duplicate entry 'product/11132-1-1' for key 'UNQ_CORE_URL_REWRITE_ID_PATH_IS_SYSTEM_STORE_ID''
I have run the following queries
check if there are duplicated SKU
SELECT
DISTINCT(`sku`) as `sku`,
COUNT(`sku`) as `skuCount`, `entity_id` FROM `catalog_product_entity`
GROUP BY `sku` HAVING `skuCount` > 1;
No dup found
Check if there are dup URL
SELECT url_key,
COUNT(url_key) AS NumOccurrences
FROM catalog_product_flat_1
GROUP BY url_key HAVING ( COUNT(url_key) > 1 );
I found some duplicate, but I don't think it is related to product/11132-1-1. duplicates are listed below:
paolo-pendant-in-plum-red-v-m-imports
double-adjustable-long-body-wall-pillar-light-in-grey-cla-lighting
Check if there are dup product name
SELECT name,
COUNT(name) AS NumOccurrences
FROM catalog_product_flat_1
GROUP BY name HAVING ( COUNT(name) > 1 );
I found one duplicate, which is Paolo Pendant in Plum Red V M Imports, again, I don't think this is replated to product/11132-1-1
Ταυτότητα Εργασίας: #5883174