On Wed, 20 Jul 2005 sunblockster@gmail.com wrote:
2005-03-21
user error: Duplicate entry '0-11' for key 1 query: ALTER TABLE term_node ADD PRIMARY KEY (tid,nid) in /path/to/ file/www/drupal462/includes/database.mysql.inc on line 66.
ALTER TABLE {term_node} ADD PRIMARY KEY (tid,nid) FAILED
This has happened today to me as well. What I did is:
mysqldump -uuser -ppass db term_node -w 'tid = 0'| sort | uniq > term_node.sql
then I deleted the entries where tid = 0 and re-imported term_node.sql after deleting the table structure on top of the file.
Afterwards add the index:
ALTER TABLE term_node ADD PRIMARY KEY (tid,nid);
Any ideas why this failed, and how to fix it?
For some reason, there are duplicates of (tid, nid) = (0, 11) in the database. Probably many more.
No idea why.
Cheers, Gerhard