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

After upgrade to 1.6.0 from 1.5.1,Error:1062 Duplicate entry ‘69-General’ for key ‘UNQ_EAV_ATTRIBUTE_GROUP_ATTRIBUTE_SET_ID_ATTRIBUTE_GROUP_NAME
 
ctrol
Member
 
Total Posts:  43
Joined:  2010-10-22
 

I upgrade to 1.6.0 from 1.5.1 via magento connect successfully(a little long time), see follow message:

Checking dependencies of packages
Starting to download Mage_All_Latest
-1.6.0.0.tgz ...
...
done887 bytes
Installing package community
/Mage_All_Latest 1.6.0.0
Package community
/Mage_All_Latest 1.6.0.0 installed successfully
Starting to download Interface_Adminhtml_Default
-1.6.0.0.tgz ...
...
done1,081,269 bytes
Installing package community
/Interface_Adminhtml_Default 1.6.0.0
Package community
/Interface_Adminhtml_Default 1.6.0.0 installed 

successfully
Starting to download Interface_Frontend_Default
-1.6.0.0.tgz ...
...
done746,746 bytes
Installing package community
/Interface_Frontend_Default 1.6.0.0
Package community
/Interface_Frontend_Default 1.6.0.0 installed 

successfully
Starting to download Interface_Install_Default
-1.6.0.0.tgz ...
...
done108,902 bytes
Installing package community
/Interface_Install_Default 1.6.0.0
Package community
/Interface_Install_Default 1.6.0.0 installed 

successfully
Starting to download Mage_Downloader
-1.6.0.0.tgz ...
...
done264,756 bytes
Installing package community
/Mage_Downloader 1.6.0.0
Package community
/Mage_Downloader 1.6.0.0 installed successfully
Starting to download Mage_Centinel
-1.6.0.0.tgz ...
...
done37,750 bytes
Installing package community
/Mage_Centinel 1.6.0.0
Package community
/Mage_Centinel 1.6.0.0 installed successfully
Starting to download Interface_Frontend_Base_Default
-1.6.0.0.tgz ...
...
done372,138 bytes
Installing package community
/Interface_Frontend_Base_Default 1.6.0.0
Package community
/Interface_Frontend_Base_Default 1.6.0.0 installed 

successfully
Starting to download Phoenix_Moneybookers
-1.3.0.tgz ...
...
done365,811 bytes
Installing package community
/Phoenix_Moneybookers 1.3.0
Package community
/Phoenix_Moneybookers 1.3.0 installed successfully
Starting to download Find_Feed
-1.1.0.tgz ...
...
done14,591 bytes
Installing package community
/Find_Feed 1.1.0
Package community
/Find_Feed 1.1.0 installed successfully
Starting to download Mage_Compiler
-1.6.0.0.tgz ...
...
done10,235 bytes
Installing package community
/Mage_Compiler 1.6.0.0
Package community
/Mage_Compiler 1.6.0.0 installed successfully
Already installed
community/Magento_Mobile 1.5.0.0.21.1skipping
Starting to download Mage_Core_Adminhtml
-1.6.0.0.tgz ...
...
done502,601 bytes
Installing package community
/Mage_Core_Adminhtml 1.6.0.0
Package community
/Mage_Core_Adminhtml 1.6.0.0 installed successfully
Starting to download Mage_Core_Modules
-1.6.0.0.tgz ...
...
done2,664,843 bytes
Installing package community
/Mage_Core_Modules 1.6.0.0
Package community
/Mage_Core_Modules 1.6.0.0 installed successfully
Already installed
community/Lib_Js_Ext 1.6.0.0skipping
Already installed
community/Lib_LinLibertineFont 2.8.14.0skipping
Already installed
community/Lib_Js_TinyMCE 3.3.7.0skipping
Already installed
community/Lib_Varien 1.6.0.0skipping
Already installed
community/Lib_Google_Checkout 1.5.0.0skipping
Already installed
community/Lib_Js_Calendar 1.51.1skipping
Already installed
community/Lib_Js_Mage 1.6.0.0skipping
Already installed
community/Lib_Phpseclib 1.5.0.0skipping
Already installed
community/Mage_Locale_en_US 1.6.0.0skipping
Already installed
community/Lib_Mage 1.6.0.0skipping
Already installed
community/Lib_ZF 1.11.1.0skipping
Starting to download Lib_Js_Prototype
-1.7.0.0.1.tgz ...
...
done237,617 bytes
Installing package community
/Lib_Js_Prototype 1.7.0.0.1
Package community
/Lib_Js_Prototype 1.7.0.0.1 installed successfully
Already installed
community/Lib_ZF_Locale 1.11.1.0skipping
Package upgraded

 
community Mage_All_Latest 1.6.0.0
 community Interface_Adminhtml_Default 1.6.0.0
 community Interface_Frontend_Default 1.6.0.0
 community Interface_Install_Default 1.6.0.0
 community Mage_Downloader 1.6.0.0
 community Mage_Centinel 1.6.0.0
 community Interface_Frontend_Base_Default 1.6.0.0
 community Phoenix_Moneybookers 1.3.0
 community Find_Feed 1.1.0
 community Mage_Compiler 1.6.0.0
 community Mage_Core_Adminhtml 1.6.0.0
 community Mage_Core_Modules 1.6.0.0
 community Lib_Js_Prototype 1.7.0.0.1

Cleaning cache
.................................
Exception during cache and session cleaning
So before i am cheering up,When i open my front page, a error happens as follws:
Error in file"D:\HostingServer\www\htdocs\www.domain.com\app\code\core\Mage\Catalog\sql\catalog_setup\upgrade-1.6.0.0.1-1.6.0.0.2.php" SQLSTATE[23000]Integrity constraint violation1062 Duplicate entry '69-General' for key 'UNQ_EAV_ATTRIBUTE_GROUP_ATTRIBUTE_SET_ID_ATTRIBUTE_GROUP_NAME'
Trace:
#0 D:\HostingServer\www\htdocs\www.domain.com\app\code\core\Mage\Core\Model\Resource\Setup.php(645): Mage::exception('Mage_Core', 'Error in file: ...')
#1 D:\HostingServer\www\htdocs\www.domain.com\app\code\core\Mage\Core\Model\Resource\Setup.php(437): Mage_Core_Model_Resource_Setup->_modifyResourceDb('upgrade', '1.6.0.0', '1.6.0.0.5')
#2 D:\HostingServer\www\htdocs\www.domain.com\app\code\core\Mage\Core\Model\Resource\Setup.php(320): Mage_Core_Model_Resource_Setup->_upgradeResourceDb('1.6.0.0', '1.6.0.0.5')
#3 D:\HostingServer\www\htdocs\www.domain.com\app\code\core\Mage\Core\Model\Resource\Setup.php(235): Mage_Core_Model_Resource_Setup->applyUpdates()
#4 D:\HostingServer\www\htdocs\www.domain.com\app\code\core\Mage\Core\Model\App.php(408): Mage_Core_Model_Resource_Setup::applyAllUpdates()
#5 D:\HostingServer\www\htdocs\www.domain.com\app\code\core\Mage\Core\Model\App.php(336): Mage_Core_Model_App->_initModules()
#6 D:\HostingServer\www\htdocs\www.domain.com\app\Mage.php(640): Mage_Core_Model_App->run(Array)
#7 D:\HostingServer\www\htdocs\www.domain.com\index.php(80): Mage::run('', 'store')
#8 {main}

And some one told me to set app/etc/config.xml

<initStatements>SET NAMES utf8</initStatements>
to
<initStatements>SET NAMES utf8SET FOREIGN_KEY_CHECKS=0SET UNIQUE_CHECKS=0</initStatements>
Yes,the “"1062 Duplicate entry ‘69-General’ for key ‘UNQ_EAV_ATTRIBUTE_GROUP_ATTRIBUTE_SET_ID_ATTRIBUTE_GROUP_NAME” problem"” disappeared,but a new error occured as follows:
SQLSTATE[HY000]General error2014 Cannot execute queries while other unbuffered queries are active.  Consider using PDOStatement::fetchAll().  Alternatively, if your code is only ever going to run against mysqlyou may enable query buffering by setting the PDO::MYSQL_ATTR_USE_BUFFERED_QUERY attribute.
Trace:
#0 D:\HostingServer\www\htdocs\www.domain.com\lib\Zend\Db\Statement\Pdo.php(228): PDOStatement->execute(Array)
#1 D:\HostingServer\www\htdocs\www.domain.com\lib\Varien\Db\Statement\Pdo\Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#2 D:\HostingServer\www\htdocs\www.domain.com\lib\Zend\Db\Statement.php(300): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#3 D:\HostingServer\www\htdocs\www.domain.com\lib\Zend\Db\Adapter\Abstract.php(479): Zend_Db_Statement->execute(Array)
#4 D:\HostingServer\www\htdocs\www.domain.com\lib\Zend\Db\Adapter\Pdo\Abstract.php(238): Zend_Db_Adapter_Abstract->query('SHOW TABLE STAT...', Array)
#5 D:\HostingServer\www\htdocs\www.domain.com\lib\Varien\Db\Adapter\Pdo\Mysql.php(389): Zend_Db_Adapter_Pdo_Abstract->query('SHOW TABLE STAT...', Array)
#6 D:\HostingServer\www\htdocs\www.domain.com\lib\Varien\Db\Adapter\Pdo\Mysql.php(327): Varien_Db_Adapter_Pdo_Mysql->query('SHOW TABLE STAT...')
#7 D:\HostingServer\www\htdocs\www.domain.com\lib\Varien\Db\Adapter\Pdo\Mysql.php(358): Varien_Db_Adapter_Pdo_Mysql->raw_query('SHOW TABLE STAT...')
#8 D:\HostingServer\www\htdocs\www.domain.com\lib\Varien\Db\Adapter\Pdo\Mysql.php(948): Varien_Db_Adapter_Pdo_Mysql->raw_fetchRow('SHOW TABLE STAT...')
#9 D:\HostingServer\www\htdocs\www.domain.com\lib\Varien\Db\Adapter\Pdo\Mysql.php(2293): Varien_Db_Adapter_Pdo_Mysql->showTableStatus('core_resource', NULL)
#10 D:\HostingServer\www\htdocs\www.domain.com\app\code\core\Mage\Core\Model\Resource\Resource.php(77): Varien_Db_Adapter_Pdo_Mysql->isTableExists('core_resource')
#11 D:\HostingServer\www\htdocs\www.domain.com\app\code\core\Mage\Core\Model\Resource\Resource.php(108): Mage_Core_Model_Resource_Resource->_loadVersionData('db')
#12 D:\HostingServer\www\htdocs\www.domain.com\app\code\core\Mage\Core\Model\Resource\Setup.php(301): Mage_Core_Model_Resource_Resource->getDbVersion('core_setup')
#13 D:\HostingServer\www\htdocs\www.domain.com\app\code\core\Mage\Core\Model\Resource\Setup.php(235): Mage_Core_Model_Resource_Setup->applyUpdates()
#14 D:\HostingServer\www\htdocs\www.domain.com\app\code\core\Mage\Core\Model\App.php(408): Mage_Core_Model_Resource_Setup::applyAllUpdates()
#15 D:\HostingServer\www\htdocs\www.domain.com\app\code\core\Mage\Core\Model\App.php(336): Mage_Core_Model_App->_initModules()
#16 D:\HostingServer\www\htdocs\www.domain.com\app\Mage.php(640): Mage_Core_Model_App->run(Array)
#17 D:\HostingServer\www\htdocs\www.domain.com\index.php(80): Mage::run('', 'store')
#18 {main}
Do any one know how to solve"1062 Duplicate entry ‘69-General’ for key ‘UNQ_EAV_ATTRIBUTE_GROUP_ATTRIBUTE_SET_ID_ATTRIBUTE_GROUP_NAME” problem and the “PDO::MYSQL_ATTR_USE_BUFFERED_QUERY “ problem ?
I think it’s the last step of entire success !
Please anyone helps out !
 
Magento Community Magento Community
Magento Community
Magento Community
 
ctrol
Member
 
Total Posts:  43
Joined:  2010-10-22
 

Fllow the instruction Set foreign key then delete the error file and the problem solved
thanks for all that care this problem
hope this will help

 
Magento Community Magento Community
Magento Community
Magento Community
 
ashwinimaurya
Jr. Member
 
Total Posts:  3
Joined:  2012-03-22
 

run the sql command below this should solve the problem

UPDATE  `mage_eav_attribute_group
SET `default_id` = 1
WHERE 
`attribute_group_name` = \\\"General\\\" AND `default_id` = 0

hope this helps if anyone comes up with this problem

 
Magento Community Magento Community
Magento Community
Magento Community
 
Alexandrovici
Jr. Member
 
Total Posts:  7
Joined:  2010-03-07
 

This really worked for me
Thank’’s a lot!!

ashwinimaurya - 22 March 2012 04:11 PM

run the sql command below this should solve the problem

UPDATE  `mage_eav_attribute_group
SET `default_id` = 1
WHERE 
`attribute_group_name` = \\\"General\\\" AND `default_id` = 0


hope this helps if anyone comes up with this problem
 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top