Duplicate entry issue in magento database

Posted by user691146 on Stack Overflow See other posts from Stack Overflow or by user691146
Published on 2012-09-24T12:54:32Z Indexed on 2012/09/24 15:37 UTC
Read the original article Hit count: 330

Filed under:

magento

The problem is as below...

ERROR 1062 (23000) at line 1893: Duplicate entry '179-81-0' for key 'UNQ_CAT_PRD_ENTT_DTIME_ENTT_ID_ATTR_ID_STORE_ID'

Probably you have faced the similar issue as I am.If I take the value '179-81-0'

I am sure 179 is the product id but not sure about other -81-0.Also in other threads it was suggested to delete the row from the table but without knowing 100% what I am doing it would be a foolish act to just delete the row.I need to know what exactly is it.

Thanks, Raj

Related posts about magento

Can't view order in magento

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I've been setting up a fresh magento 1.4.0.1 install, working great so far. I did some test orders just to see. Everything works fine, but when I click on "view order" under "my orders", I get a bunch of error messages: There has been an error processing your request Notice: iconv_substr() … >>> More
Magento Community - Hosting :: Need Advice which sharing hosting will run magento fast

as seen on Server Fault - Search for 'Server Fault'
Hi, Need Advice which sharing hosting will run Magento Community fast or some other not expensive solution. This website will not have a lot of users, I only need that it will run fast for 100-20 users in same time. The problem with magento is database design that make this system very slow ,… >>> More
Magento Community - Hosting :: Need Advice which sharing hosting will run magento fast

as seen on Server Fault - Search for 'Server Fault'
Hi, Need Advice which sharing hosting will run Magento Community fast or some other not expensive solution. This website will not have a lot of users, I only need that it will run fast for 100-20 users in same time. The problem with magento is database design that make this system very slow ,… >>> More
Magento Developers: Is Magento really -that- good?

as seen on Stack Overflow - Search for 'Stack Overflow'
We are looking at Magento as a possible commerce solution, but we are reading more bad than good on the free product. However Magento sells itself as the best thing ever, so I am confused on its actual value. Thought I'd ask the pros here. Can any seasoned developer here explain the difficulties… >>> More
Loading Magento child html outside of Magento

as seen on Stack Overflow - Search for 'Stack Overflow'
I am loading Magento blocks outside of Magento for certain parts of my site. I can do this successfully with something similar the following. require_once $docRoot.'/app/Mage.php'; umask(0); Mage::app('default'); ... $layout = Mage::getSingleton('core/layout'); $block = $layout->createBlock('Mage_Page_Block_Html_Header'); $block->setTemplate('page/html/header… >>> More

Developer IT