Magento - Problem with Reindexing Process for Tag Aggregation Data only! - Magento 1.6.0 Upgrade Issues - eCommerce Software for Growth

Log In

Username or Email

Password:

Forgot Password

or
Register

Skip to site navigation »
Skip to main content »
Skip to footer content »

Magento Forum

Problem with Reindexing Process for Tag Aggregation Data only!

MageClub Total Posts: 375 Joined: 2009-07-25 India Ignore user	Hi.. Client website was running on 1.4.x . We recently upgraded it to 1.6.1 and all good, except one issue. On Index Management, all the indexes are upto date, except the Tag Aggregation Data . It gets stuck with an error , “Cannot initialize the indexer process.” Also if I goto Featured Products page, and try to select and save some products as featured, it shows an error on top : SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`devnov2`.`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) Looks like, there is a problem with the tags tables. How to fix this ? Signature █ Premium Magento Templates & Magento Extensions █ Professional Magento Upgrade Service █ PSD to Magento Service █ Magento Tips and Tricks
	Posted: November 23 2011 \| top

MageClub Total Posts: 375 Joined: 2009-07-25 India Ignore user	On another client site, he also got indexing issues, but for other 3 items. [I tried reindexing from SSH , so know the errors. And I have posted below the exact errors, while magento is trying to reindex my data. ] Product Prices - Index product prices exception 'PDOException' with message 'SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`mageclub_jay/catalog_product_index_tier_price`, CONSTRAINT `FK_CAT_PRD_IDX_TIER_PRICE_ENTT_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_entity` (`entity_id`))' in /home/mageclub/public_html/demolink.biz/jay/lib/Zend/Db/Statement/Pdo.php:228 Product Flat Data - Reorganize EAV product structure to flat structure 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 (`mageclub_jay/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 )' in /home/mageclub/public_html/demolink.biz/jay/lib/Zend/Db/Statement/Pdo.php:234 Category Products - Indexed category/products association Category Products 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 (`mageclub_jay/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 )' in /home/mageclub/public_html/demolink.biz/jay/lib/Zend/Db/Statement/Pdo.php:228 Signature █ Premium Magento Templates & Magento Extensions █ Professional Magento Upgrade Service █ PSD to Magento Service █ Magento Tips and Tricks
	Posted: November 23 2011 \| top \| # 1

MageClub Total Posts: 375 Joined: 2009-07-25 India Ignore user	Okay.. I fixed the issues by running database repair tool. But only, Product Flat Data - Reorganize EAV product structure to flat structure is still stuck! What can be the issue ? Signature █ Premium Magento Templates & Magento Extensions █ Professional Magento Upgrade Service █ PSD to Magento Service █ Magento Tips and Tricks
	Posted: November 23 2011 \| top \| # 2

Tetsuo_ Total Posts: 6 Joined: 2009-09-22 Ignore user	soam - 22 November 2011 08:59 PM On Index Management, all the indexes are upto date, except the Tag Aggregation Data . It gets stuck with an error , “Cannot initialize the indexer process.” Same issue here. “Cannot initialize the indexer process.” when I attempt it to re-index. I also can’t add products to my cart because of this.
	Posted: December 16 2011 \| top \| # 3

jinful Total Posts: 1 Joined: 2010-07-21 Ignore user	My site experience the same issue, who can help me or tell me how to solve the problem?
	Posted: January 1 2012 \| top \| # 4

wien173 Total Posts: 8 Joined: 2008-07-26 tokyo Ignore user	Fixed Tag Aggregation Data Reindexing Problem. In my case, fixed by deleteing the table data in tag_relation and tag_summary tables. Though, you should add the products related with tag name again.
	Posted: January 19 2012 \| top \| # 5

Magento Community

Magento Community

Back to top

Fatal error: Call to a member function getRate()

1.6.0 to 1.6.1 sales_order_tax_item’ doesn’t exist