On Wed, 20 Jul 2005 sunblockster@gmail.com wrote:
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?
Sure:
delete from term_node where tid = 0;
and re-imported term_node.sql
I am an ignoramus -- how did you do this?
You can upload the file through phpmyadmin or import through the mysql commandline.
after deleting the table structure on top of the file.
And this?
Open in editor, edit.
You can also use the -t flag with mysqldump, then you can skip this.
Afterwards add the index:
ALTER TABLE term_node ADD PRIMARY KEY (tid,nid);
This is just a mysql command?
Yes.
Cheers, Gerhard