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.
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}
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
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}
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.
