cancel
Showing results for 
Search instead for 
Did you mean: 

ID already exists

SOLVED

ID already exists

Hello,

 

I have a duplicate ID in a table.. This is my error:

 

Item (Magento/Eav/Model/Entity/Attribute/Option) with the same ID 91 already exists.

In which table should i go find this? (Product admin page does not load anymore).

 

Thanks!

Pieter

1 ACCEPTED SOLUTION

Accepted Solutions

Re: ID already exists

You need to go to database with table name, eav_attribute_option 

Now check option_id field within this table and if duplicates row are exist one field need to delete.

If Issue Solved, Click Kudos/Accept As solutions. Get Magento insight from
Magento 2 Blogs/Tutorial

View solution in original post

4 REPLIES 4

Re: ID already exists

You need to go to database with table name, eav_attribute_option 

Now check option_id field within this table and if duplicates row are exist one field need to delete.

If Issue Solved, Click Kudos/Accept As solutions. Get Magento insight from
Magento 2 Blogs/Tutorial

Re: ID already exists

this solution is not working for me.

Item (Magento\Eav\Model\Entity\Attribute\Option) with the same ID "24" already exists.

but in eav_attribute_option table there is only one entry for option_id 24.

 https://www.canineproducts.in/dogs

Re: ID already exists

check "eav_attribute_option_value" table delete duplicate row with this option_id

Re: ID already exists

This is a little old, but I will write here anyway. Other possibility is that the values in  table `eav_attribute_option_value` for the same store_id are duplicate