Magento Forum

   
There was a problem with reindexing process. 
 
faIsaL_bhaTti
Jr. Member
 
Avatar
Total Posts:  19
Joined:  2011-11-22
Lahore
 

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 !

 
Magento Community Magento Community
Magento Community
Magento Community
 
niro
Mentor
 
Avatar
Total Posts:  1592
Joined:  2009-03-04
Latvia, Riga
 

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

 
Magento Community Magento Community
Magento Community
Magento Community
 
blurg
Jr. Member
 
Total Posts:  11
Joined:  2011-04-19
 

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

 
Magento Community Magento Community
Magento Community
Magento Community
 
faIsaL_bhaTti
Jr. Member
 
Avatar
Total Posts:  19
Joined:  2011-11-22
Lahore
 

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 ?

 
Magento Community Magento Community
Magento Community
Magento Community
 
faIsaL_bhaTti
Jr. Member
 
Avatar
Total Posts:  19
Joined:  2011-11-22
Lahore
 

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 ?

 
Magento Community Magento Community
Magento Community
Magento Community
 
niro
Mentor
 
Avatar
Total Posts:  1592
Joined:  2009-03-04
Latvia, Riga
 

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.

 
Magento Community Magento Community
Magento Community
Magento Community
 
faIsaL_bhaTti
Jr. Member
 
Avatar
Total Posts:  19
Joined:  2011-11-22
Lahore
 

Thanks niro it worked for me .

 
Magento Community Magento Community
Magento Community
Magento Community
 
maxhodges
Jr. Member
 
Total Posts:  15
Joined:  2011-05-17
 

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!

 
Magento Community Magento Community
Magento Community
Magento Community
 
wjohan
Member
 
Avatar
Total Posts:  46
Joined:  2011-03-08
Monnickendam
 
maxhodges - 04 December 2011 06: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?

 
Magento Community Magento Community
Magento Community
Magento Community
 
NickBerg
Jr. Member
 
Total Posts:  11
Joined:  2012-08-12
 
maxhodges - 04 December 2011 06: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.

 
Magento Community Magento Community
Magento Community
Magento Community
 
Richardmaximun
Jr. Member
 
Total Posts:  30
Joined:  2010-01-27
 

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

 
Magento Community Magento Community
Magento Community
Magento Community
 
Brain_strom
Jr. Member
 
Total Posts:  2
Joined:  2013-07-29
 

Hi All,

I know the main post is old, but i have this issue too since my upgrade from 1.4.0.2 to 1.7.0.2

There was a problem with reindexing process.

The magento_db_repair_tool returns that the DB is OK.

but i still have this message on the admin panel when i try to reindex Category Products.

The error log returns me :

2013-08-07T14:07:33+00:00 DEBUG (7): Exception message: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`catalog_category_product_index`, CONSTRAINT `FK_CAT_CTGR_PRD_IDX_CTGR_ID_CAT_CTGR_ENTT_ENTT_ID` FOREIGN KEY (`category_id`) REFERENCES `catalog_category_entity` (`entity_id`) ON )

I really don’t understand, what this exactly means, i know the DB is ok, but there is an error witha foreign key…

I followed many tutorials, to repair this, but with no luck and no results.

Can anyone help me ?

PS Sorry for my english...not my mother tongue smile

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
    Back to top