For those who are having issues reindexing the product attributes and you know it’s due to the issue with DUPLICATE ENTRIES
First go to the /var/log/exception.log file and go to the bottom.
you will see the following error
1062 Duplicate entry '2050-180-1-139' for key
The 2050 is the product id, and the number next to it (180) is the attribute ID. So you will have to probably do some detective work but most likely it will be under the catalog_product_entity_varchar table. So in launch PHPmyAdmin or MySQL Workbench (what have you) and create a query like so:
SELECT * FROM schllib1.catalog_product_entity_varchar where attribute_id = 180;
Most of you will have commas seperated values with the same thing… if that is the case...run this
SET `value` = left(TRIM(REPLACE(`value`,',','')),3)
where attribute_id = 180;
Please note, the Attribute ID may vary and please note the LEFT 3 was something that was only for my situation. That value may be different. So you will need to find the longest character for it and use that value in replace of that 3.