organicinternet/magento-configurable-simple — Issue #57: Upgrade to M1.6.0.0 failed
Author: leiweke
Created: 2011-10-08 16:14:56+00:00
State: open

Hello i updated from 1.5.0.1 to 1.6.0.0.
when i save a product i got this error:
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1242-0-1' for key 'PRIMARY'

when i check the exception.log i got the following:
Next exception 'Zend_Db_Statement_Exception' with message 'SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1242-0-1' for key 'PRIMARY'' in /home/doggieba/public_html/1501/lib/Zend/Db/Statement/Pdo.php:234
Stack trace:
#0 /home/doggieba/public_html/1501/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#1 /home/doggieba/public_html/1501/lib/Zend/Db/Statement.php(300): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#2 /home/doggieba/public_html/1501/lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#3 /home/doggieba/public_html/1501/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('INSERT INTO `ca...', Array)
#4 /home/doggieba/public_html/1501/lib/Varien/Db/Adapter/Pdo/Mysql.php(389): Zend_Db_Adapter_Pdo_Abstract->query('INSERT INTO `ca...', Array)
#5 /home/doggieba/public_html/1501/app/code/core/Mage/Catalog/Model/Resource/Product/Indexer/Price/Default.php(535): Varien_Db_Adapter_Pdo_Mysql->query('INSERT INTO `ca...')
#6 /home/doggieba/public_html/1501/app/code/core/Mage/Catalog/Model/Resource/Product/Indexer/Price/Default.php(135): Mage_Catalog_Model_Resource_Product_Indexer_Price_Default->_movePriceDataToIndexTable()
#7 /home/doggieba/public_html/1501/app/code/community/OrganicInternet/SimpleConfigurableProducts/Catalog/Model/Resource/Eav/Mysql4/Product/Indexer/Price.php(107): Mage_Catalog_Model_Resource_Product_Indexer_Price_Default->reindexEntity('1242')
#8 /home/doggieba/public_html/1501/app/code/core/Mage/Index/Model/Indexer/Abstract.php(144): OrganicInternet_SimpleConfigurableProducts_Catalog_Model_Resource_Eav_Mysql4_Product_Indexer_Price->catalogProductSave(Object(Mage_Index_Model_Event))
#9 /home/doggieba/public_html/1501/app/code/core/Mage/Catalog/Model/Product/Indexer/Price.php(283): Mage_Index_Model_Indexer_Abstract->callEventHandler(Object(Mage_Index_Model_Event))
#10 /home/doggieba/public_html/1501/app/code/core/Mage/Index/Model/Indexer/Abstract.php(85): Mage_Catalog_Model_Product_Indexer_Price->_processEvent(Object(Mage_Index_Model_Event))
#11 /home/doggieba/public_html/1501/app/code/core/Mage/Index/Model/Process.php(206): Mage_Index_Model_Indexer_Abstract->processEvent(Object(Mage_Index_Model_Event))
#12 [internal function]: Mage_Index_Model_Process->processEvent(Object(Mage_Index_Model_Event))
#13 /home/doggieba/public_html/1501/app/code/core/Mage/Index/Model/Indexer.php(252): call_user_func_array(Array, Array)
#14 /home/doggieba/public_html/1501/app/code/core/Mage/Index/Model/Indexer.php(154): Mage_Index_Model_Indexer->_runAll('processEvent', Array)
#15 /home/doggieba/public_html/1501/app/code/core/Mage/Index/Model/Indexer.php(219): Mage_Index_Model_Indexer->indexEvent(Object(Mage_Index_Model_Event))
#16 /home/doggieba/public_html/1501/app/code/core/Mage/Catalog/Model/Product.php(557): Mage_Index_Model_Indexer->processEntityAction(Object(OrganicInternet_SimpleConfigurableProducts_Catalog_Model_Product), 'catalog_product', 'save')
#17 [internal function]: Mage_Catalog_Model_Product->afterCommitCallback()
#18 /home/doggieba/public_html/1501/app/code/core/Mage/Core/Model/Resource/Abstract.php(110): call_user_func(Array)
#19 /home/doggieba/public_html/1501/app/code/core/Mage/Core/Model/Abstract.php(322): Mage_Core_Model_Resource_Abstract->commit()
#20 /home/doggieba/public_html/1501/app/code/core/Mage/Adminhtml/controllers/Catalog/ProductController.php(700): Mage_Core_Model_Abstract->save()
#21 /home/doggieba/public_html/1501/app/code/core/Mage/Core/Controller/Varien/Action.php(420): Mage_Adminhtml_Catalog_ProductController->saveAction()
#22 /home/doggieba/public_html/1501/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(250): Mage_Core_Controller_Varien_Action->dispatch('save')
#23 /home/doggieba/public_html/1501/app/code/core/Mage/Core/Controller/Varien/Front.php(176): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#24 /home/doggieba/public_html/1501/app/code/core/Mage/Core/Model/App.php(347): Mage_Core_Controller_Varien_Front->dispatch()
#25 /home/doggieba/public_html/1501/app/Mage.php(640): Mage_Core_Model_App->run(Array)
#26 /home/doggieba/public_html/1501/index.php(80): Mage::run('', 'store')
#27 {main}

if i disable the module with false the product save runs fine.
i´m running the 0.8.2 stable

Please fix it.

Thanks a lot for this Module
Sebastian