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

Product Prices, Product Flat Data & Tag Aggregation Data can’t Reindex, How can I fix that, please? 
 
WebDux
Jr. Member
 
Total Posts:  23
Joined:  2011-04-27
 

These days, I just migrate our magento store and ugprade from 1.5 to 1.7.

When we export the database, we have not choose “disable foreign key check”, after we migration, the order products have not details and there is not ship item for processing order. But customer still can place new order and new order everything is ok. We can don’t care the old information because it still can place new order.

Our question is Product Prices, Product Flat Data & Tag Aggregation Data can’t Reindex and we tried to repair the database but the problem still have. We want to know if there is other way to fix these problem. Or if we don’t fix the problem, what will be there bad effect for our store run? If we can don’t fix these problem and run the store normally.

We hope there is good guys to help us.

Thanks in advance.

Image Attachments
admin-error.jpg
 
Magento Community Magento Community
Magento Community
Magento Community
 
srmobile
Sr. Member
 
Total Posts:  276
Joined:  2011-10-25
 

Hi there,

I was having a similar issue after noticing my prices were not being updated on product views.

What you will need to do it ssh into your site and manually flush all the cache

/site/var/cache
/site/var/locks

Then go into /site/shell

run

php indexer.php --reindexall

This should clear up your problem.

Let us know,

SR

 
Magento Community Magento Community
Magento Community
Magento Community
 
WebDux
Jr. Member
 
Total Posts:  23
Joined:  2011-04-27
 

Hi srmobile,

Many thanks for your reply.

In fact, I have tried this methord before but I still try that again but it still have the same problem and I have attached the error details, so would you like to check that for us, please?

Product Attributes index was rebuilt successfully
Product Prices index process unknown error:
exception ‘PDOException’ with message ‘SQLSTATE[23000]: Integrity constraint vio lation: 1452 Cannot add or update a child row: a foreign key constraint fails (` herawigs_herawigs`.`catalog_product_index_tier_price`, CONSTRAINT `FK_CAT_PRD_ID X_TIER_PRICE_ENTT_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_entity` (`enti)’ in /home/herawigs/public_html/lib/Zend/Db/Stat ement/Pdo.php:228
Stack trace:
#0 /home/herawigs/public_html/lib/Zend/Db/Statement/Pdo.php(228): PDOStatement-> execute(Array)
#1 /home/herawigs/public_html/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_D b_Statement_Pdo->_execute(Array)
#2 /home/herawigs/public_html/lib/Zend/Db/Statement.php(300): Varien_Db_Statemen t_Pdo_Mysql->_execute(Array)
#3 /home/herawigs/public_html/lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Sta tement->execute(Array)
#4 /home/herawigs/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db _Adapter_Abstract->query(’INSERT INTO `ca...’, Array)
#5 /home/herawigs/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(419): Zend_Db_ Adapter_Pdo_Abstract->query(’INSERT INTO `ca...’, Array)
#6 /home/herawigs/public_html/app/code/core/Mage/Catalog/Model/Resource/Product/ Indexer/Price.php(455): Varien_Db_Adapter_Pdo_Mysql->query(’INSERT INTO `ca...’)
#7 /home/herawigs/public_html/app/code/core/Mage/Catalog/Model/Resource/Product/ Indexer/Price.php(379): Mage_Catalog_Model_Resource_Product_Indexer_Price->_prep areTierPriceIndex()
#8 /home/herawigs/public_html/app/code/core/Mage/Index/Model/Indexer/Abstract.ph p(143): Mage_Catalog_Model_Resource_Product_Indexer_Price->reindexAll()
#9 /home/herawigs/public_html/app/code/core/Mage/Index/Model/Process.php(209): M age_Index_Model_Indexer_Abstract->reindexAll()
#10 /home/herawigs/public_html/app/code/core/Mage/Index/Model/Process.php(255):  Mage_Index_Model_Process->reindexAll()
#11 /home/herawigs/public_html/shell/indexer.php(158): Mage_Index_Model_Process- >reindexEverything()
#12 /home/herawigs/public_html/shell/indexer.php(198): Mage_Shell_Compiler->run( )
#13 {main}

Next exception ‘Zend_Db_Statement_Exception’ with message ‘SQLSTATE[23000]: Inte grity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`herawigs_herawigs`.`catalog_product_index_tier_price`, CONST RAINT `FK_CAT_PRD_IDX_TIER_PRICE_ENTT_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`ent ity_id`) REFERENCES `catalog_product_entity` (`enti)’ in /home/herawigs/public_h tml/lib/Zend/Db/Statement/Pdo.php:234
Stack trace:
#0 /home/herawigs/public_html/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_D b_Statement_Pdo->_execute(Array)
#1 /home/herawigs/public_html/lib/Zend/Db/Statement.php(300): Varien_Db_Statemen t_Pdo_Mysql->_execute(Array)
#2 /home/herawigs/public_html/lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Sta tement->execute(Array)
#3 /home/herawigs/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db _Adapter_Abstract->query(’INSERT INTO `ca...’, Array)
#4 /home/herawigs/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(419): Zend_Db_ Adapter_Pdo_Abstract->query(’INSERT INTO `ca...’, Array)
#5 /home/herawigs/public_html/app/code/core/Mage/Catalog/Model/Resource/Product/ Indexer/Price.php(455): Varien_Db_Adapter_Pdo_Mysql->query(’INSERT INTO `ca...’)
#6 /home/herawigs/public_html/app/code/core/Mage/Catalog/Model/Resource/Product/ Indexer/Price.php(379): Mage_Catalog_Model_Resource_Product_Indexer_Price->_prep areTierPriceIndex()
#7 /home/herawigs/public_html/app/code/core/Mage/Index/Model/Indexer/Abstract.ph p(143): Mage_Catalog_Model_Resource_Product_Indexer_Price->reindexAll()
#8 /home/herawigs/public_html/app/code/core/Mage/Index/Model/Process.php(209): M age_Index_Model_Indexer_Abstract->reindexAll()
#9 /home/herawigs/public_html/app/code/core/Mage/Index/Model/Process.php(255): M age_Index_Model_Process->reindexAll()
#10 /home/herawigs/public_html/shell/indexer.php(158): Mage_Index_Model_Process- >reindexEverything()
#11 /home/herawigs/public_html/shell/indexer.php(198): Mage_Shell_Compiler->run( )
#12 {main}
Catalog URL Rewrites index was rebuilt successfully
Product Flat Data index process unknown error:
exception ‘PDOException’ with message ‘SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`herawigs_herawigs`.<result 2 when explaining filename ‘#sql-4c52_3447a’>, CONSTRAINT `FK_CAT_PRD_FLAT_1_ENTT_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_ent)’ in /home/herawigs/public_html/lib/Zend/Db/Statement/Pdo.php:228
Stack trace:
#0 /home/herawigs/public_html/lib/Zend/Db/Statement/Pdo.php(228): PDOStatement->execute(Array)
#1 /home/herawigs/public_html/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#2 /home/herawigs/public_html/lib/Zend/Db/Statement.php(300): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#3 /home/herawigs/public_html/lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#4 /home/herawigs/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(’ALTER TABLE `ca...’, Array)
#5 /home/herawigs/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(419): Zend_Db_Adapter_Pdo_Abstract->query(’ALTER TABLE `ca...’, Array)
#6 /home/herawigs/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(340): Varien_Db_Adapter_Pdo_Mysql->query(’ALTER TABLE `ca...’)
#7 /home/herawigs/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(2569): Varien_Db_Adapter_Pdo_Mysql->raw_query(’ALTER TABLE `ca...’)
#8 /home/herawigs/public_html/app/code/core/Mage/Catalog/Model/Resource/Product/Flat/Indexer.php(816): Varien_Db_Adapter_Pdo_Mysql->addForeignKey(’FK_CAT_PRD_FLAT...’, ‘catalog_product...’, ‘entity_id’, ‘catalog_product...’, ‘entity_id’, ‘CASCADE’, ‘CASCADE’)
#9 /home/herawigs/public_html/app/code/core/Mage/Catalog/Model/Resource/Product/Flat/Indexer.php(1390): Mage_Catalog_Model_Resource_Product_Flat_Indexer->prepareFlatTable(1)
#10 /home/herawigs/public_html/app/code/core/Mage/Catalog/Model/Product/Flat/Indexer.php(296): Mage_Catalog_Model_Resource_Product_Flat_Indexer->reindexAll()
#11 /home/herawigs/public_html/app/code/core/Mage/Catalog/Model/Product/Indexer/Flat.php(336): Mage_Catalog_Model_Product_Flat_Indexer->reindexAll()
#12 /home/herawigs/public_html/app/code/core/Mage/Index/Model/Process.php(209): Mage_Catalog_Model_Product_Indexer_Flat->reindexAll()
#13 /home/herawigs/public_html/app/code/core/Mage/Index/Model/Process.php(255): Mage_Index_Model_Process->reindexAll()
#14 /home/herawigs/public_html/shell/indexer.php(158): Mage_Index_Model_Process->reindexEverything()
#15 /home/herawigs/public_html/shell/indexer.php(198): Mage_Shell_Compiler->run()
#16 {main}
Category Flat Data index was rebuilt successfully
Category Products index was rebuilt successfully
Catalog Search Index index was rebuilt successfully
Stock Status index was rebuilt successfully
Tag Aggregation Data index process unknown error:
exception ‘PDOException’ with message ‘SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`herawigs_herawigs`.`tag_summary`, CONSTRAINT `FK_TAG_SUMMARY_TAG_ID_TAG_TAG_ID` FOREIGN KEY (`tag_id`) REFERENCES `tag` (`tag_id`) ON DELETE CASCADE ON UPDATE CASCADE)’ in /home/herawigs/public_html/lib/Zend/Db/Statement/Pdo.php:228
Stack trace:
#0 /home/herawigs/public_html/lib/Zend/Db/Statement/Pdo.php(228): PDOStatement->execute(Array)
#1 /home/herawigs/public_html/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#2 /home/herawigs/public_html/lib/Zend/Db/Statement.php(300): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#3 /home/herawigs/public_html/lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#4 /home/herawigs/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(’INSERT INTO `ta...’, Array)
#5 /home/herawigs/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(419): Zend_Db_Adapter_Pdo_Abstract->query(’INSERT INTO `ta...’, Array)
#6 /home/herawigs/public_html/app/code/core/Mage/Tag/Model/Resource/Indexer/Summary.php(233): Varien_Db_Adapter_Pdo_Mysql->query(’INSERT INTO `ta...’)
#7 /home/herawigs/public_html/app/code/core/Mage/Tag/Model/Resource/Indexer/Summary.php(135): Mage_Tag_Model_Resource_Indexer_Summary->aggregate()
#8 /home/herawigs/public_html/app/code/core/Mage/Index/Model/Indexer/Abstract.php(143): Mage_Tag_Model_Resource_Indexer_Summary->reindexAll()
#9 /home/herawigs/public_html/app/code/core/Mage/Index/Model/Process.php(209): Mage_Index_Model_Indexer_Abstract->reindexAll()
#10 /home/herawigs/public_html/app/code/core/Mage/Index/Model/Process.php(255): Mage_Index_Model_Process->reindexAll()
#11 /home/herawigs/public_html/shell/indexer.php(158): Mage_Index_Model_Process->reindexEverything()
#12 /home/herawigs/public_html/shell/indexer.php(198): Mage_Shell_Compiler->run()
#13 {main}

Next exception ‘Zend_Db_Statement_Exception’ with message ‘SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`herawigs_herawigs`.`tag_summary`, CONSTRAINT `FK_TAG_SUMMARY_TAG_ID_TAG_TAG_ID` FOREIGN KEY (`tag_id`) REFERENCES `tag` (`tag_id`) ON DELETE CASCADE ON UPDATE CASCADE)’ in /home/herawigs/public_html/lib/Zend/Db/Statement/Pdo.php:234
Stack trace:
#0 /home/herawigs/public_html/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#1 /home/herawigs/public_html/lib/Zend/Db/Statement.php(300): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#2 /home/herawigs/public_html/lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#3 /home/herawigs/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(’INSERT INTO `ta...’, Array)
#4 /home/herawigs/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(419): Zend_Db_Adapter_Pdo_Abstract->query(’INSERT INTO `ta...’, Array)
#5 /home/herawigs/public_html/app/code/core/Mage/Tag/Model/Resource/Indexer/Summary.php(233): Varien_Db_Adapter_Pdo_Mysql->query(’INSERT INTO `ta...’)
#6 /home/herawigs/public_html/app/code/core/Mage/Tag/Model/Resource/Indexer/Summary.php(135): Mage_Tag_Model_Resource_Indexer_Summary->aggregate()
#7 /home/herawigs/public_html/app/code/core/Mage/Index/Model/Indexer/Abstract.php(143): Mage_Tag_Model_Resource_Indexer_Summary->reindexAll()
#8 /home/herawigs/public_html/app/code/core/Mage/Index/Model/Process.php(209): Mage_Index_Model_Indexer_Abstract->reindexAll()
#9 /home/herawigs/public_html/app/code/core/Mage/Index/Model/Process.php(255): Mage_Index_Model_Process->reindexAll()
#10 /home/herawigs/public_html/shell/indexer.php(158): Mage_Index_Model_Process->reindexEverything()
#11 /home/herawigs/public_html/shell/indexer.php(198): Mage_Shell_Compiler->run()
#12 {main}

Thanks in advance.

 
Magento Community Magento Community
Magento Community
Magento Community
 
srmobile
Sr. Member
 
Total Posts:  276
Joined:  2011-10-25
 

Okay first backup your database.

1. Login to phpmyadmin
2. Look for tables catalog_product_flat_1 catalog_product_flat_2 (you may have more)
3. drop these tables
4. clear the /var/locks, /var/cache
5. run the indexer.php --reindexall

Let me know!

 
Magento Community Magento Community
Magento Community
Magento Community
 
WebDux
Jr. Member
 
Total Posts:  23
Joined:  2011-04-27
 

Hi srmobile,

Many thanks for your help and I have done as what you told us.

It did solve one problem and now there is two item can’t reindex and I have attached the picture and the result, so could you help us to fix other two problem, please?

Product Attributes index was rebuilt successfully
Product Prices index process unknown error:
exception ‘PDOException’ with message ‘SQLSTATE[23000]: Integrity constraint vio lation: 1452 Cannot add or update a child row: a foreign key constraint fails (` herawigs_herawigs`.`catalog_product_index_tier_price`, CONSTRAINT `FK_CAT_PRD_ID X_TIER_PRICE_ENTT_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_entity` (`enti)’ in /home/herawigs/public_html/lib/Zend/Db/Stat ement/Pdo.php:228
Stack trace:
#0 /home/herawigs/public_html/lib/Zend/Db/Statement/Pdo.php(228): PDOStatement-> execute(Array)
#1 /home/herawigs/public_html/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_D b_Statement_Pdo->_execute(Array)
#2 /home/herawigs/public_html/lib/Zend/Db/Statement.php(300): Varien_Db_Statemen t_Pdo_Mysql->_execute(Array)
#3 /home/herawigs/public_html/lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Sta tement->execute(Array)
#4 /home/herawigs/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db _Adapter_Abstract->query(’INSERT INTO `ca...’, Array)
#5 /home/herawigs/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(419): Zend_Db_ Adapter_Pdo_Abstract->query(’INSERT INTO `ca...’, Array)
#6 /home/herawigs/public_html/app/code/core/Mage/Catalog/Model/Resource/Product/ Indexer/Price.php(455): Varien_Db_Adapter_Pdo_Mysql->query(’INSERT INTO `ca...’)
#7 /home/herawigs/public_html/app/code/core/Mage/Catalog/Model/Resource/Product/ Indexer/Price.php(379): Mage_Catalog_Model_Resource_Product_Indexer_Price->_prep areTierPriceIndex()
#8 /home/herawigs/public_html/app/code/core/Mage/Index/Model/Indexer/Abstract.ph p(143): Mage_Catalog_Model_Resource_Product_Indexer_Price->reindexAll()
#9 /home/herawigs/public_html/app/code/core/Mage/Index/Model/Process.php(209): M age_Index_Model_Indexer_Abstract->reindexAll()
#10 /home/herawigs/public_html/app/code/core/Mage/Index/Model/Process.php(255):  Mage_Index_Model_Process->reindexAll()
#11 /home/herawigs/public_html/shell/indexer.php(158): Mage_Index_Model_Process- >reindexEverything()
#12 /home/herawigs/public_html/shell/indexer.php(198): Mage_Shell_Compiler->run( )
#13 {main}

Next exception ‘Zend_Db_Statement_Exception’ with message ‘SQLSTATE[23000]: Inte grity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`herawigs_herawigs`.`catalog_product_index_tier_price`, CONST RAINT `FK_CAT_PRD_IDX_TIER_PRICE_ENTT_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`ent ity_id`) REFERENCES `catalog_product_entity` (`enti)’ in /home/herawigs/public_h tml/lib/Zend/Db/Statement/Pdo.php:234
Stack trace:
#0 /home/herawigs/public_html/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_D b_Statement_Pdo->_execute(Array)
#1 /home/herawigs/public_html/lib/Zend/Db/Statement.php(300): Varien_Db_Statemen t_Pdo_Mysql->_execute(Array)
#2 /home/herawigs/public_html/lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Sta tement->execute(Array)
#3 /home/herawigs/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db _Adapter_Abstract->query(’INSERT INTO `ca...’, Array)
#4 /home/herawigs/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(419): Zend_Db_ Adapter_Pdo_Abstract->query(’INSERT INTO `ca...’, Array)
#5 /home/herawigs/public_html/app/code/core/Mage/Catalog/Model/Resource/Product/ Indexer/Price.php(455): Varien_Db_Adapter_Pdo_Mysql->query(’INSERT INTO `ca...’)
#6 /home/herawigs/public_html/app/code/core/Mage/Catalog/Model/Resource/Product/ Indexer/Price.php(379): Mage_Catalog_Model_Resource_Product_Indexer_Price->_prep areTierPriceIndex()
#7 /home/herawigs/public_html/app/code/core/Mage/Index/Model/Indexer/Abstract.ph p(143): Mage_Catalog_Model_Resource_Product_Indexer_Price->reindexAll()
#8 /home/herawigs/public_html/app/code/core/Mage/Index/Model/Process.php(209): M age_Index_Model_Indexer_Abstract->reindexAll()
#9 /home/herawigs/public_html/app/code/core/Mage/Index/Model/Process.php(255): M age_Index_Model_Process->reindexAll()
#10 /home/herawigs/public_html/shell/indexer.php(158): Mage_Index_Model_Process- >reindexEverything()
#11 /home/herawigs/public_html/shell/indexer.php(198): Mage_Shell_Compiler->run( )
#12 {main}
Catalog URL Rewrites index was rebuilt successfully
Product Flat Data index was rebuilt successfully
Category Flat Data index was rebuilt successfully
Category Products index was rebuilt successfully
Catalog Search Index index was rebuilt successfully
Stock Status index was rebuilt successfully
Tag Aggregation Data index process unknown error:
exception ‘PDOException’ with message ‘SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`herawigs_herawigs`.`tag_summary`, CONSTRAINT `FK_TAG_SUMMARY_TAG_ID_TAG_TAG_ID` FOREIGN KEY (`tag_id`) REFERENCES `tag` (`tag_id`) ON DELETE CASCADE ON UPDATE CASCADE)’ in /home/herawigs/public_html/lib/Zend/Db/Statement/Pdo.php:228
Stack trace:
#0 /home/herawigs/public_html/lib/Zend/Db/Statement/Pdo.php(228): PDOStatement->execute(Array)
#1 /home/herawigs/public_html/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#2 /home/herawigs/public_html/lib/Zend/Db/Statement.php(300): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#3 /home/herawigs/public_html/lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#4 /home/herawigs/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(’INSERT INTO `ta...’, Array)
#5 /home/herawigs/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(419): Zend_Db_Adapter_Pdo_Abstract->query(’INSERT INTO `ta...’, Array)
#6 /home/herawigs/public_html/app/code/core/Mage/Tag/Model/Resource/Indexer/Summary.php(233): Varien_Db_Adapter_Pdo_Mysql->query(’INSERT INTO `ta...’)
#7 /home/herawigs/public_html/app/code/core/Mage/Tag/Model/Resource/Indexer/Summary.php(135): Mage_Tag_Model_Resource_Indexer_Summary->aggregate()
#8 /home/herawigs/public_html/app/code/core/Mage/Index/Model/Indexer/Abstract.php(143): Mage_Tag_Model_Resource_Indexer_Summary->reindexAll()
#9 /home/herawigs/public_html/app/code/core/Mage/Index/Model/Process.php(209): Mage_Index_Model_Indexer_Abstract->reindexAll()
#10 /home/herawigs/public_html/app/code/core/Mage/Index/Model/Process.php(255): Mage_Index_Model_Process->reindexAll()
#11 /home/herawigs/public_html/shell/indexer.php(158): Mage_Index_Model_Process->reindexEverything()
#12 /home/herawigs/public_html/shell/indexer.php(198): Mage_Shell_Compiler->run()
#13 {main}

Next exception ‘Zend_Db_Statement_Exception’ with message ‘SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`herawigs_herawigs`.`tag_summary`, CONSTRAINT `FK_TAG_SUMMARY_TAG_ID_TAG_TAG_ID` FOREIGN KEY (`tag_id`) REFERENCES `tag` (`tag_id`) ON DELETE CASCADE ON UPDATE CASCADE)’ in /home/herawigs/public_html/lib/Zend/Db/Statement/Pdo.php:234
Stack trace:
#0 /home/herawigs/public_html/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#1 /home/herawigs/public_html/lib/Zend/Db/Statement.php(300): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#2 /home/herawigs/public_html/lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#3 /home/herawigs/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(’INSERT INTO `ta...’, Array)
#4 /home/herawigs/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(419): Zend_Db_Adapter_Pdo_Abstract->query(’INSERT INTO `ta...’, Array)
#5 /home/herawigs/public_html/app/code/core/Mage/Tag/Model/Resource/Indexer/Summary.php(233): Varien_Db_Adapter_Pdo_Mysql->query(’INSERT INTO `ta...’)
#6 /home/herawigs/public_html/app/code/core/Mage/Tag/Model/Resource/Indexer/Summary.php(135): Mage_Tag_Model_Resource_Indexer_Summary->aggregate()
#7 /home/herawigs/public_html/app/code/core/Mage/Index/Model/Indexer/Abstract.php(143): Mage_Tag_Model_Resource_Indexer_Summary->reindexAll()
#8 /home/herawigs/public_html/app/code/core/Mage/Index/Model/Process.php(209): Mage_Index_Model_Indexer_Abstract->reindexAll()
#9 /home/herawigs/public_html/app/code/core/Mage/Index/Model/Process.php(255): Mage_Index_Model_Process->reindexAll()
#10 /home/herawigs/public_html/shell/indexer.php(158): Mage_Index_Model_Process->reindexEverything()
#11 /home/herawigs/public_html/shell/indexer.php(198): Mage_Shell_Compiler->run()
#12 {main}

Image Attachments
error-311.jpg
 
Magento Community Magento Community
Magento Community
Magento Community
 
srmobile
Sr. Member
 
Total Posts:  276
Joined:  2011-10-25
 

I’m happy you got one problem solved, but for the other 2 it sounds like you’ll need to try the “Database Repair Tool”

http://www.magentocommerce.com/download

Scroll down and you’ll see it.

Place the contents of the file in the root of your magento installation and run the php file.

Let me know,

SR

 
Magento Community Magento Community
Magento Community
Magento Community
 
WebDux
Jr. Member
 
Total Posts:  23
Joined:  2011-04-27
 

Hi srmobile,

Frankly speaking, we have tried “Database repair tool” methord before and it can’t work, so do you think it’s necessary to try again, please?

 
Magento Community Magento Community
Magento Community
Magento Community
 
srmobile
Sr. Member
 
Total Posts:  276
Joined:  2011-10-25
 
herawigs - 12 March 2013 03:37 PM

Hi srmobile,

Frankly speaking, we have tried “Database repair tool” methord before and it can’t work, so do you think it’s necessary to try again, please?

Your original post wasn’t clear on what you did to “repair” the database.

I am far from a database expert, I was able to assist you with one of the problems because I had to deal with it from experience. For the rest, you can google (a quick search brought me to: http://www.magentocommerce.com/boards/viewthread/312438/ for one of the remaining issues) or you can higher someone to fix it for you if it is critical.

Good luck,

SR

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