I've a problem with my product import extension that is returned the "classic" violation integrity error:
SQLSTATE: Integrity constraint violation: 1062 Duplicate entry '25061-1' for key 'UNQ_CATALOGINVENTORY_STOCK_ITEM_PRODUCT_ID_STOCK_ID'
I'm using Magento
There are multiple topics about that issue on
stackoverflow, magento forums with different technical approaches like below:
Someone recommends to download and use the
dbtoolsrepairs provided by Magento, **.
Some are providing db tables list to truncate** "with no major risk".
An another proposal is to identify with precision the data and remove it from the related db table.
What is the pragmatic way to identify and fix that issue?