How to delete unused term - not displayed, but in database?
bwooster47 - January 31, 2006 - 18:51
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.
Good question, how to delete specific terms using sql
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 1would work but no, I'm not SQL skillfull enough.
Anyone please?
http://groups.drupal.org/node
http://groups.drupal.org/node/16979
Review Critical
ClipGlobe - World Travel