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

You cannot define a correlation name ‘link_attribute_position_int’ more than once
 
nafem
Jr. Member
 
Total Posts:  1
Joined:  2012-10-22
 

I have a new installation of 1.7.0.2 which I have then copied an existing database to. Everything is fine but if I try and duplicate a product in the backend, I get the following error:

You cannot define a correlation name ‘link_attribute_position_int’ more than once

The full entry from the Exception log is:

2013-05-08T13:30:53+00:00 ERR (3):
exception ‘Zend_Db_Select_Exception’ with message ‘You cannot define a correlation name ‘link_attribute_position_int’ more than once’ in/httpdocs/lib/Zend/Db/Select.php:808
Stack trace:
#0/httpdocs/lib/Varien/Db/Select.php(281): Zend_Db_Select->_join(’left join’, Array, ‘`link_attribute...’, Array, NULL)
#1/httpdocs/lib/Zend/Db/Select.php(357): Varien_Db_Select->_join(’left join’, Array, ‘`link_attribute...’, Array, NULL)
#2/httpdocs/app/code/core/Mage/Catalog/Model/Resource/Product/Link/Collection.php(161): Zend_Db_Select->joinLeft(Array, ‘`link_attribute...’, Array)
#3/httpdocs/app/code/core/Mage/Catalog/Model/Product.php(962): Mage_Catalog_Model_Resource_Product_Link_Collection->joinAttributes()
#4/httpdocs/app/code/core/Mage/Catalog/Model/Product.php(1123): Mage_Catalog_Model_Product->getCrossSellLinkCollection()
#5/httpdocs/app/code/core/Mage/Adminhtml/controllers/Catalog/ProductController.php(767): Mage_Catalog_Model_Product->duplicate()
#6/httpdocs/app/code/core/Mage/Core/Controller/Varien/Action.php(419): Mage_Adminhtml_Catalog_ProductController->duplicateAction()
#7/httpdocs/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(250): Mage_Core_Controller_Varien_Action->dispatch(’duplicate’)
#8/httpdocs/app/code/core/Mage/Core/Controller/Varien/Front.php(176): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#9/httpdocs/app/code/core/Mage/Core/Model/App.php(354): Mage_Core_Controller_Varien_Front->dispatch()
#10/httpdocs/app/Mage.php(683): Mage_Core_Model_App->run(Array)
#11/httpdocs/index.php(87): Mage::run(’’, ‘store’)
#12 {main}

I can’t access the Cross-sells tab either.

Any ideas?

 
Magento Community Magento Community
Magento Community
Magento Community
 
sabba87
Jr. Member
 
Total Posts:  2
Joined:  2010-10-02
 

Did you ever figure this out? I have the same issue and is driving me mad.

Thanks

Jamie

 
Magento Community Magento Community
Magento Community
Magento Community
 
Mohammed Meabed
Jr. Member
 
Avatar
Total Posts:  6
Joined:  2010-10-28
Dubai
 

In your database, go to this table catalog_product_link_attribute
You will find multiple rows for the attribute “position” and “link_type_id” delete last duplicate record and try again.

if you are not sure what rows to delete post here then ill tell you.

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