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

Default Values index process unknown error 1.6 to 1.7
 
happydesigners
Jr. Member
 
Total Posts:  1
Joined:  2012-02-04
 

hello, i Cant reindex default Values, someone knows how to fix it?

Default Values 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 (`ahorraen_tres`.`m_filter2_value`, CONSTRAINT `FK_m_filter2_value_mana_db/edit_session` FOREIGN KEY (`edit_session_id`) REFERENCES `m_edit_session` (`id`) ON DELETE CASCADE ON UPDATE CASCADE)’ in /home/ahorraen/public_html/lib/Zend/Db/Statement/Pdo.php:228
Stack trace:
#0 /home/ahorraen/public_html/lib/Zend/Db/Statement/Pdo.php(228): PDOStatement->execute(Array)
#1 /home/ahorraen/public_html/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#2 /home/ahorraen/public_html/lib/Zend/Db/Statement.php(300): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#3 /home/ahorraen/public_html/lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#4 /home/ahorraen/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(’INSERT INTO `m_...’, Array)
#5 /home/ahorraen/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(419): Zend_Db_Adapter_Pdo_Abstract->query(’INSERT INTO `m_...’, Array)
#6 /home/ahorraen/public_html/lib/Zend/Db/Adapter/Abstract.php(574): Varien_Db_Adapter_Pdo_Mysql->query(’INSERT INTO `m_...’, Array)
#7 /home/ahorraen/public_html/app/code/core/Mage/Core/Model/Resource/Db/Abstract.php(453): Zend_Db_Adapter_Abstract->insert(’m_filter2_value’, Array)
#8 /home/ahorraen/public_html/app/code/core/Mage/Core/Model/Abstract.php(318): Mage_Core_Model_Resource_Db_Abstract->save(Object(Mana_Filters_Model_Filter2_Value))
#9 /home/ahorraen/public_html/app/code/local/Mana/Db/Helper/Data.php(182): Mage_Core_Model_Abstract->save()
#10 /home/ahorraen/public_html/app/code/local/Mana/Db/Model/Indexer.php(36): Mana_Db_Helper_Data->replicate()
#11 /home/ahorraen/public_html/app/code/core/Mage/Index/Model/Process.php(209): Mana_Db_Model_Indexer->reindexAll()
#12 /home/ahorraen/public_html/app/code/core/Mage/Index/Model/Process.php(255): Mage_Index_Model_Process->reindexAll()
#13 /home/ahorraen/public_html/shell/indexer.php(158): Mage_Index_Model_Process->reindexEverything()
#14 /home/ahorraen/public_html/shell/indexer.php(198): Mage_Shell_Compiler->run()
#15 {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 (`ahorraen_tres`.`m_filter2_value`, CONSTRAINT `FK_m_filter2_value_mana_db/edit_session` FOREIGN KEY (`edit_session_id`) REFERENCES `m_edit_session` (`id`) ON DELETE CASCADE ON UPDATE CASCADE)’ in /home/ahorraen/public_html/lib/Zend/Db/Statement/Pdo.php:234
Stack trace:
#0 /home/ahorraen/public_html/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#1 /home/ahorraen/public_html/lib/Zend/Db/Statement.php(300): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#2 /home/ahorraen/public_html/lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#3 /home/ahorraen/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(’INSERT INTO `m_...’, Array)
#4 /home/ahorraen/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(419): Zend_Db_Adapter_Pdo_Abstract->query(’INSERT INTO `m_...’, Array)
#5 /home/ahorraen/public_html/lib/Zend/Db/Adapter/Abstract.php(574): Varien_Db_Adapter_Pdo_Mysql->query(’INSERT INTO `m_...’, Array)
#6 /home/ahorraen/public_html/app/code/core/Mage/Core/Model/Resource/Db/Abstract.php(453): Zend_Db_Adapter_Abstract->insert(’m_filter2_value’, Array)
#7 /home/ahorraen/public_html/app/code/core/Mage/Core/Model/Abstract.php(318): Mage_Core_Model_Resource_Db_Abstract->save(Object(Mana_Filters_Model_Filter2_Value))
#8 /home/ahorraen/public_html/app/code/local/Mana/Db/Helper/Data.php(182): Mage_Core_Model_Abstract->save()
#9 /home/ahorraen/public_html/app/code/local/Mana/Db/Model/Indexer.php(36): Mana_Db_Helper_Data->replicate()
#10 /home/ahorraen/public_html/app/code/core/Mage/Index/Model/Process.php(209): Mana_Db_Model_Indexer->reindexAll()
#11 /home/ahorraen/public_html/app/code/core/Mage/Index/Model/Process.php(255): Mage_Index_Model_Process->reindexAll()
#12 /home/ahorraen/public_html/shell/indexer.php(158): Mage_Index_Model_Process->reindexEverything()
#13 /home/ahorraen/public_html/shell/indexer.php(198): Mage_Shell_Compiler->run()
#14 {main}

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