MySQL Forums
Forum List  »  German

Re: Mysteriöser "duplicate entry error"
Posted by: Thomas Wiedmann
Date: August 08, 2012 12:03AM

Hallo Mathis,
der Import-Fehler meldet den UNIQUE KEY
..
UNIQUE KEY `UNQ_CAT_PRD_LNK_ATTR_INT_PRD_LNK_ATTR_ID_LNK_ID` (`product_link_attribute_id`,`link_id`),

Es es kommt in den Daten ein Kombination aus (`product_link_attribute_id`,`link_id`) doppelt vor.
Prüfe doch mal in den Ausgangsdaten folgendes

SELECT product_link_attribute_id, link_id, COUNT(*) AS anzahl
  FROM catalog_product_link_attribute_int
GROUP BY product_link_attribute_id, link_id
HAVING COUNT(*) > 1

Das Problem ist eventuell, dass in der Spalte product_link_attribute_id der Wert NULL erlaubt ist.

Grüße
Thomas



Edited 2 time(s). Last edit at 08/08/2012 12:07AM by Thomas Wiedmann.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Mysteriöser "duplicate entry error"
1146
August 08, 2012 12:03AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.