php - Magento 1.7.0.2 Reindexing Product Attributes Error -


On retrieving the product properties in Magento 1.7.0.2, we receive the following errors:

< Pre> product properties index process unknown error: exception with message 'PDOException' 'SQLSTATE [23,000]: Integrity barrier violation: 1452 can add or update a child line: a foreign key fails (`Xxdbnamexx` .`mage_catalog_product_index_eav`, constrained 'FK_CAT_PRD_IDX_EAV_ENTT_ID_CAT_PRD_ENTT_ENTT_ID' foreign key (` unit_ID`) references /home/xxxxxxxxx/public_html/lib/Zend/Db/Statement/Pdo.php#28 Stack Trace: In the `mage_catalog_product_entity` (` entity_id) 'in the # stack / home / xxxxxxxxx / public_html / lib / zend / db / Statement / Pdo.php (228): PDOStatement-> Operate (array) # 1 /home/xxxxxxxxx/public_html/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo- & gt; _execute (array) # 2 /home/xxxxxxxxx/public_html/lib/Zend/Db/Statement.php(300): Varien_Db_Statement_Pdo_Mysql- & gt; _execute (array) # 3 / home / XXXXXXXXX / public_htm l / lib / Zend / DB / Adapter / Abstract.php (479): Zend_Db_Statement-> Actual (array) # 4 /home/xxxxxxxxx/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract- & gt; Query ('inserting in ma ...', array) # 5 /home/xxxxxxxxx/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(419): Zend_Db_Adapter_Pdo_Abstract- & gt; Query (insert '' Ma ... ', Array) # 6 /home/xxxxxxxxx/public_html/app/code/core/Mage/Index/Model/Resource/Abstract.php(179): Varien_Db_Adapter_Pdo_Mysql- & gt; Query (insert '' Ma ... ') # 7 /home/xxxxxxxxx/public_html/app/code/core/Mage/Index/Model/Resource/Helper/Mysql4.php(48): Mage_Index_Model_Resource_Abstract- & gt; insertFromSelect (Object (Varien_Db_Select), 'mage_catalog_pr ...', array, false) # 8 /home/xxxxxxxxx/public_html/app/code/core/Mage/Index/Model/Resource/Abstract.php(153): Mage_Index_Model_Resource_Helper_Mysql4- & Gt; insertData (object (Mage_Catalog_Model_Resource_Product_Indexer_Eav_Source), object (Varien_Db_Select), 'mage_catalog_pr ...', array, false) # 9 / home / X XXXXXXXX / public_html / app / code / core / Mage / index / models / resource / Abstract.php (113): Mage_Index_Model_Resource_Abstract- & gt; insertFromTable ( 'mage_catalog_pr ...', 'mage_catalog_pr ...', false) # 10 / home / XXXXXXXXX / public_html / app / code / core / Mage / Catalog / model / process / product / index / EAV / Abstract.php (54): Mage_Index_Model_Resource_Abstract- & gt; syncData () # 11 / home / XXXXXXXXX / public_html / app /code/core/Mage/Catalog/Model/Resource/Product/Indexer/Eav.php(185): Mage_Catalog_Model_Resource_Product_Indexer_Eav_Abstract- & gt; reindexAll () # 12 / home / XXXXXXXXX / public_html / app / code / core / Mage / index / model / indexer / Sarkfip (143): Mage_Catalog_Model_Resource_Product_Indexer_Eav- & gt; Rendeksol () # 13 /hom/ksksksksksksksksks/pblik_html/app/kod/kor/mge/indeks/modl/proseskphp(20 9): Mge_indeks_modl_indecsser_abstrkt- & gt; ReindexAll () # 14 /home/xxxxxxxxx/public_html/app/code/core/Mage/Index/Model/Process.php(255): Mage_Index_Model_Process-> ReindexAll () # 15 / home / XXXXXXXXX / public_html / shell / indexer.php (158): Mage_ind ex_Model_Process-> ReindexEverything () # 16 /home/xxxxxxxxx/public_html/shell/indexer.php(198): Mage_Shell_Compiler- & gt; Run () # 17 {main}

Could anyone help with this help?

The error message shows what you are trying to do to violate the foreign key Interrupted between mage_catalog_product_index_eav and mage_catalog_product_entity .

Does this mean you is entity_ids in mage_catalog_product_index_eav table does not mage_catalog_product_entity is can be so that the table because mage_catalog_product_entity are zero

This can also happen because the record that attempts to refer to mage_catalog_product_index_eav is not at all. In that case, you can extract the record by discussing with mage_catalog_product_index_eav .

In any case, you will find out exactly what the attacker records. See the first answer for the pointer on how to do this. (This is not an exact problem because they are working with flat data but still are useful, I think.)


Comments

Popular posts from this blog

ios - How do I use CFArrayRef in Swift? -

eclipse plugin - Run java code error: Workspace is closed -

c - Error on building source code in VC 6 -