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
Got this.
then I deleted the entries where tid = 0
How did you do this? Do you mean entries in a certain table? Is this something I could do through phpmyadmin?
and re-imported term_node.sql
I am an ignoramus -- how did you do this?
after deleting the table structure on top of the file.
And this?
Afterwards add the index:
ALTER TABLE term_node ADD PRIMARY KEY (tid,nid);
This is just a mysql command?
Thanks.