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

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘9-include_in_menu’ for key 2
 
Ija A
Jr. Member
 
Total Posts:  5
Joined:  2009-07-09
 

Hi all,

Am getting this error after upgrading to 1.4.1.0 from 1.4.0.1

Error in file: “/home/nurhamper/domains/nurhampers.com/public_html/shop/app/code/core/Mage/Catalog/sql/catalog_setup/mysql4-upgrade-1.4.0.0.21-1.4.0.0.22.php” - SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘9-include_in_menu’ for key 2

Trace:
#0 /home/nurhamper/domains/nurhampers.com/public_html/shop/app/code/core/Mage/Core/Model/Resource/Setup.php(390): Mage::exception(’Mage_Core’, ‘Error in file: ...’)
#1 /home/nurhamper/domains/nurhampers.com/public_html/shop/app/code/core/Mage/Core/Model/Resource/Setup.php(289): Mage_Core_Model_Resource_Setup->_modifyResourceDb(’upgrade’, ‘1.4.0.0.21’, ‘1.4.0.0.28’)
#2 /home/nurhamper/domains/nurhampers.com/public_html/shop/app/code/core/Mage/Core/Model/Resource/Setup.php(233): Mage_Core_Model_Resource_Setup->_upgradeResourceDb(’1.4.0.0.21’, ‘1.4.0.0.28’)
#3 /home/nurhamper/domains/nurhampers.com/public_html/shop/app/code/core/Mage/Core/Model/Resource/Setup.php(161): Mage_Core_Model_Resource_Setup->applyUpdates()
#4 /home/nurhamper/domains/nurhampers.com/public_html/shop/app/code/core/Mage/Core/Model/App.php(363): Mage_Core_Model_Resource_Setup::applyAllUpdates()
#5 /home/nurhamper/domains/nurhampers.com/public_html/shop/app/code/core/Mage/Core/Model/App.php(295): Mage_Core_Model_App->_initModules()
#6 /home/nurhamper/domains/nurhampers.com/public_html/shop/app/Mage.php(596): Mage_Core_Model_App->run(Array)
#7 /home/nurhamper/domains/nurhampers.com/public_html/shop/index.php(78): Mage::run(’’, ‘store’)
#8 {main}

Can help? It’s on a live server.

 
Magento Community Magento Community
Magento Community
Magento Community
 
DCAlmeida
Sr. Member
 
Avatar
Total Posts:  164
Joined:  2008-12-28
PRT
 

Check your permissions (http://www.magentocommerce.com/wiki/groups/227/resetting_file_permissions)

My tip is to run Magento Cleanup Tool (you can download this at above link)

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