Don't like ads? PRO users don't see any ads ;-)
Public Pastes

Magento Duplicate ID Solution

By: amhustle on Jun 2nd, 2012  |  syntax: None  |  size: 0.77 KB  |  hits: 91  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. Hi Guys,
  2.  
  3. I have been having the same problem after attribute import. My solution is by using PhpAdmin because I didn’t want to modify core files .
  4.  
  5. 1. Copy the number from the error msg ( ex:  Item (Mage_Eav_Model_Entity_Attribute_Option) with the same id “721” already exist )
  6. 2. Go to PhpAdmin , choose your database and click Search on top. Paste or write the number. Choose “eav_attribute_option_value” from “Inside table(s):” and click GO.
  7. 3. Click Browse from the search result. If you see 2 rows which has the same option_id , delete the second one.
  8.  
  9. Thats it .
  10.  
  11. I had only 4-5 duplicate values so it took 5 minutes to delete them . If you have 1000 duplicate values then you might want to modify the code.
  12.  
  13. Have a nice day
  14. Hope this helps some people
create a new version of this paste RAW Paste Data