How to delete unused term - not displayed, but in database?

Posted by bwooster47 on January 31, 2006 at 6:51pm

Using pathauto to generate url-aliases, I noticed I got an alias for a term that I had deleted from my categories - "Test Gallery" - it does not show up in the categories list, but when I looked at the database, I noticed that the term_data table had this entry:
tid=15, vid=3, name="Test Gallery".

I presume this is some bug where it did not get cleaned up fully - the vocabulary got deleted, so it does not show in the Categories list, and there is no way to use the Drupal Admin UI to delete just a hanging term?

Can I safely delete that term_data row from the database? Or will it mess up the counter value for the next term, when I create one?

I don't have any vocabulary with vid=3.

Comments

Good question, how to delete specific terms using sql

Posted by cybe on March 12, 2007 at 4:45pm

I would like to know this too, and know how to delete specific terms which are in use (that the leech+yahoo terms module makes).
This should be easier than an SQL string to delete unused terms.

I thought something like:

DELETE FROM `term_data` WHERE `term_data`.`name`= fubar LIMIT 1

would work but no, I'm not SQL skillfull enough.

Anyone please?

http://groups.drupal.org/node

Posted by giorgio79 on March 26, 2009 at 1:33pm

http://groups.drupal.org/node/16979

****Me and Drupal :)****
Clickbank IPN - Sell online or create a membership site with the largest affiliate network!
Review Critical - One of my sites