Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

Page 2 of 2
Can’t initialize indexer process - Product Attributes
 
diggableimages
Jr. Member
 
Total Posts:  1
Joined:  2013-04-21
 

Try:

http://www.magentocommerce.com/answers/discussion/772/Index-Management-Index-Products-Stuck-on-Processing/p1

Then, I went through each one and re-indexed it whether it needed it or not.

 
Magento Community Magento Community
Magento Community
Magento Community
 
Yireo
Member
 
Avatar
Total Posts:  52
Joined:  2008-05-26
The Netherland
 

Hi,

The hint about duplicate values for a multiselect attribute did it for us. I had written an import-script that imported values to existing products from CSV. But existing values for multiselect attributes were just imported as new values for that multiselect attribute, resulting in this reindexing errors. Besides the point that it is stupid that Magento does not simply check for unique values in a multiselect attribute, we wrote the following script that fixed things for us:

require_once 'app/Mage.php';
Mage::app();
Mage::app()->setCurrentStore(Mage_Core_Model_App::ADMIN_STORE_ID);

$attributes = array('subject''year');
        
$products Mage::getModel('catalog/product')->getCollection();
foreach(
$products as $product{
    $product 
$product->load($product->getId());
        
    foreach(
$attributes as $attributeName{
        $attributeValue 
$product->getData($attributeName);
        if(empty(
$attributeValue)) continue;
        
$attributeValue explode(','$attributeValue);
        
$attributeValue array_unique($attributeValue);
        
$product->setData($attributeName$attributeValue);
    
}

    $rt 
$product->save();
    echo 
$product->getName().": ";
    echo (
$rt) ? 'OK' 'failed';
    echo 
"\n";
}

Make sure to edit the attributes-array.

 
Magento Community Magento Community
Magento Community
Magento Community
 
simonpipeline
Jr. Member
 
Total Posts:  9
Joined:  2012-12-21
 

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

UPDATE schllib1.catalog_product_entity_varchar 
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.

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top
Page 2 of 2