Magento

hi .
when i try to reindex Product Flat Data there comes an error . sumthing like this “There was a problem with reindexing process.”.
can any body help me solving this problem . ??
Thanks in advance !

1. try to truncate tables catalog_product_flat_1 and catalog_product_flat_2.
if it not helps

2. try to repare database with repair tool http://www.magentocommerce.com/download
mostly this problem appear after version upgrade

Check the logs for more information, this is only a short remark from your backend , but to really know what goes wrong please post the related logs entries here

hi niro !
i tried bothof your techniques bt it didn’t workd for me .
have you any other idea ?
do any one can help me ?

In Error Log File This message comes .

2011-11-29T04:31:51+00:00 DEBUG (7): Exception message: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`aquatic/#sql-120c_105895`, CONSTRAINT `FK_CAT_PRD_FLAT_1_ENTT_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE ON UPDATE )
Trace: #0 /home/content/67/8545467/html/lib/Zend/Db/Statement/Pdo.php(228): PDOStatement->execute(Array)
#1 /home/content/67/8545467/html/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#2 /home/content/67/8545467/html/lib/Zend/Db/Statement.php(300): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#3 /home/content/67/8545467/html/lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#4 /home/content/67/8545467/html/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(’ALTER TABLE `ca...’, Array)
#5 /home/content/67/8545467/html/lib/Varien/Db/Adapter/Pdo/Mysql.php(389): Zend_Db_Adapter_Pdo_Abstract->query(’ALTER TABLE `ca...’, Array)
#6 /home/content/67/8545467/html/lib/Varien/Db/Adapter/Pdo/Mysql.php(327): Varien_Db_Adapter_Pdo_Mysql->query(’ALTER TABLE `ca...’)
#7 /home/content/67/8545467/html/lib/Varien/Db/Adapter/Pdo/Mysql.php(2548): Varien_Db_Adapter_Pdo_Mysql->raw_query(’ALTER TABLE `ca...’)
#8 /home/content/67/8545467/html/app/code/core/Mage/Catalog/Model/Resource/Product/Flat/Indexer.php(806): Varien_Db_Adapter_Pdo_Mysql->addForeignKey(’FK_CAT_PRD_FLAT...’, ‘catalog_product...’, ‘entity_id’, ‘catalog_product...’, ‘entity_id’, ‘CASCADE’, ‘CASCADE’)
#9 /home/content/67/8545467/html/app/code/core/Mage/Catalog/Model/Resource/Product/Flat/Indexer.php(125): Mage_Catalog_Model_Resource_Product_Flat_Indexer->prepareFlatTable(1)
#10 /home/content/67/8545467/html/app/code/core/Mage/Catalog/Model/Resource/Product/Flat/Indexer.php(115): Mage_Catalog_Model_Resource_Product_Flat_Indexer->rebuild(’1’)
#11 /home/content/67/8545467/html/app/code/core/Mage/Catalog/Model/Product/Flat/Indexer.php(73): Mage_Catalog_Model_Resource_Product_Flat_Indexer->rebuild(NULL)
#12 /home/content/67/8545467/html/app/code/core/Mage/Catalog/Model/Product/Indexer/Flat.php(303): Mage_Catalog_Model_Product_Flat_Indexer->rebuild()
#13 /home/content/67/8545467/html/app/code/core/Mage/Index/Model/Process.php(166): Mage_Catalog_Model_Product_Indexer_Flat->reindexAll()
#14 /home/content/67/8545467/html/app/code/core/Mage/Index/Model/Process.php(194): Mage_Index_Model_Process->reindexAll()
#15 /home/content/67/8545467/html/app/code/core/Mage/Index/controllers/Adminhtml/ProcessController.php(124): Mage_Index_Model_Process->reindexEverything()
#16 /home/content/67/8545467/html/app/code/core/Mage/Core/Controller/Varien/Action.php(420): Mage_Index_Adminhtml_ProcessController->reindexProcessAction()
#17 /home/content/67/8545467/html/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(250): Mage_Core_Controller_Varien_Action->dispatch(’reindexProcess’)
#18 /home/content/67/8545467/html/app/code/core/Mage/Core/Controller/Varien/Front.php(176): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#19 /home/content/67/8545467/html/app/code/core/Mage/Core/Model/App.php(349): Mage_Core_Controller_Varien_Front->dispatch()
#20 /home/content/67/8545467/html/app/Mage.php(640): Mage_Core_Model_App->run(Array)
#21 /home/content/67/8545467/html/index.php(84): Mage::run(’’, ‘store’)
#22 {main}

anyone ?

Have repair tool made any changes to database?

If yes - truncate tables above and reindex.
If not - search product tables for dublicates.

P.S. Last time i had problem with dublicate keys too. Repair tool added 3 keys and after i have truncated flat tables reindex process start to work.

Thanks niro it worked for me .

Did you import your products with Cart2Cart?

Cart2Cart is poison! Magneto Connect should delist this product. It destroys Magento installations. We have a new, clean install and after running Cart2Cart we are plagued with SQL errors, reindexing errors, and other issues related to corrupt product and attribute entries. It’s not just us: several Magento consultants have told us they’ve experienced similar problems. Google “errors cart2cart” or “error index cart2cart” etc for more evidence. 

This product is defective, and it has cost my company countless hours and dollars to fix. AVOID!

maxhodges - 04 December 2011 07:47 AM

Did you import your products with Cart2Cart?

Cart2Cart is poison! Magneto Connect should delist this product. It destroys Magento installations. We have a new, clean install and after running Cart2Cart we are plagued with SQL errors, reindexing errors, and other issues related to corrupt product and attribute entries. It’s not just us: several Magento consultants have told us they’ve experienced similar problems. Google “errors cart2cart” or “error index cart2cart” etc for more evidence. 

This product is defective, and it has cost my company countless hours and dollars to fix. AVOID!

I transfered my 1.5 installation to a 1.6 installation and when I try to edit my (custom) attributes it shows “no” on the frontend. Do you think this has something to do with the C2C migration?

maxhodges - 04 December 2011 07:47 AM

Did you import your products with Cart2Cart?

Cart2Cart is poison! Magneto Connect should delist this product. It destroys Magento installations. We have a new, clean install and after running Cart2Cart we are plagued with SQL errors, reindexing errors, and other issues related to corrupt product and attribute entries. It’s not just us: several Magento consultants have told us they’ve experienced similar problems. Google “errors cart2cart” or “error index cart2cart” etc for more evidence. 

This product is defective, and it has cost my company countless hours and dollars to fix. AVOID!

Hi,

maybe in your case it is true. But I have used cart2cart and had no problems. You know, sometimes s**t happens don’t be so tough in your comments.

Hi,

My store work OK for two months until change position of categories in Manages Category admin panel. Now it show error (There was a problem with reindexing process) for “Product Prices” index.

Any body have a solution? I tried alls tips founded in www.

Regards

hai, me too My store work OK for two months until change position of categories in Manages Category admin panel.
Manfaat Madu Untuk Ibu Hamil