Magento Forum

   
Install Magento 1.7.0 error: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry
 
luischeung
Jr. Member
 
Total Posts:  1
Joined:  2012-05-02
 

After I setup the database using the Sample provided by Magento, I use the downloader to install the magento, however, magento gives the following error:

Error in file"H:\dwphp2004\catalog\app\code\core\Mage\Customer\sql\customer_setup\upgrade-1.6.1.0-1.6.2.0.php" SQLSTATE[23000]Integrity constraint violation1062 Duplicate entry '1-disable_auto_group_change' for key 'UNQ_EAV_ATTRIBUTE_ENTITY_TYPE_ID_ATTRIBUTE_CODE'

Trace:
#0 H:\dwphp2004\catalog\app\code\core\Mage\Core\Model\Resource\Setup.php(645): Mage::exception('Mage_Core', 'Error in file: ...')
#1 H:\dwphp2004\catalog\app\code\core\Mage\Core\Model\Resource\Setup.php(437): Mage_Core_Model_Resource_Setup->_modifyResourceDb('upgrade', '1.6.1.0', '1.6.2.0.1')
#2 H:\dwphp2004\catalog\app\code\core\Mage\Core\Model\Resource\Setup.php(320): Mage_Core_Model_Resource_Setup->_upgradeResourceDb('1.6.1.0', '1.6.2.0.1')
#3 H:\dwphp2004\catalog\app\code\core\Mage\Core\Model\Resource\Setup.php(235): Mage_Core_Model_Resource_Setup->applyUpdates()
#4 H:\dwphp2004\catalog\app\code\core\Mage\Core\Model\App.php(417): Mage_Core_Model_Resource_Setup::applyAllUpdates()
#5 H:\dwphp2004\catalog\app\code\core\Mage\Core\Model\App.php(343): Mage_Core_Model_App->_initModules()
#6 H:\dwphp2004\catalog\app\Mage.php(683): Mage_Core_Model_App->run(Array)
#7 H:\dwphp2004\catalog\index.php(87): Mage::run('', 'store')
#8 {main}

I have tried to emove /var/cache, /var/session and modify \app\etc\config.xml, but the error still exist. Please suggest me some solution. Thanks!!!

 
Magento Community Magento Community
Magento Community
Magento Community
 
gamecat2300
Jr. Member
 
Total Posts:  19
Joined:  2010-03-05
 

Hi,

I am also having this error and issue. However not with sample data, a plugin for constant contact integration. I suspect the root of this issue may be the same however. Does anyone have any clues?

=-Steve

 
Magento Community Magento Community
Magento Community
Magento Community
 
aaronwallace
Member
 
Total Posts:  59
Joined:  2011-07-18
 

I have a blog post which states possible Magento 1.7 Upgrade errors with their possible solutions:
http://www.expertmagentodevelopers.com/blog/magento-1-7-upgrade-errors-with-solutions/

 
Magento Community Magento Community
Magento Community
Magento Community
 
RB2009
Member
 
Total Posts:  40
Joined:  2010-12-05
 

Here was my solution

http://www.magentocommerce.com/boards/viewthread/285172/

and it actually fixed the database in my case rather than avoiding the problem using “go arounds”

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