I have been using intensively the Feeds module. After many imports of data doing test, I sometimes get the following error message: ´SQLSTATE: Integrity constraint violation:
1062 Duplicate entry taxonomy_term-32591-0-0-und' for key 'PRIMARY'
Can I clean the database in such a way that I will no longer have this error message? Of course, when it happens, the taxonomy terms are not imported. After deleting the Feeds and importing again, it goes perfect, but the problem happens from time to time.
I don't think I have many extra modules which will store taxonomy tid's on them, so maybe the problem is with the core database tables, but I cannot find where there are still rows to be deleted manually to solve the problem.
Because the data are already corrupted, I pretend to manually repair the integrity of database (or with the help of a module) without having to look for a previous backup, which would imply losing hours of work done on other sections (and thus tables of the database).