URL Rewrite error duplicated entry - open to bidding

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

Magento

Prosjekt-ID: #5883174

Om prosjektet