How to delete tags?

Any other way than manual removal/ complete deletion of tag field?

foxhound	#1 2012-05-20 21:46
Donator Thanked: 5 times	Some member on my forums added completely bugged tags to their topics. They did not add "," but for example ";" which cause the tag line to become incredibly long (even if you only allow 4 tags per item cause of the choosen words). Additionally some users found it necassary to use the tags to flame other users. I can delete those tags from their fields but they will stay in the DB, meaning they still come up in a tag cloud. Also, those long tags screw the tag cloud layout as its becoming too wide. Is there a way one can remove only specific words from the tag cloud? Or is completely emptying the tag cloud field in the DB the only option? What would happen if I would close the site, manaully remove those unwanted tags from the tag field in the DB, upload the DB again and continue as if nothing happened. Could that cause issues with the way the tags are stored in the DB? <img src="http://www.armaholic.com/datas/thumbs/green-sea-battalion-uniforms-version-03-preview_4.jpg" alt="green-sea-battalion-uniforms-version-03-" />

foxhound

#1 2012-05-20 21:46

Some member on my forums added completely bugged tags to their topics. They did not add "," but for example ";" which cause the tag line to become incredibly long (even if you only allow 4 tags per item cause of the choosen words).
Additionally some users found it necassary to use the tags to flame other users.

I can delete those tags from their fields but they will stay in the DB, meaning they still come up in a tag cloud. Also, those long tags screw the tag cloud layout as its becoming too wide.
Is there a way one can remove only specific words from the tag cloud? Or is completely emptying the tag cloud field in the DB the only option?

What would happen if I would close the site, manaully remove those unwanted tags from the tag field in the DB, upload the DB again and continue as if nothing happened. Could that cause issues with the way the tags are stored in the DB?

GHengeveld	#2 2012-05-20 23:12
Team Thanked: 52 times	First, delete all the unwanted tag references the way you normally would (through the site). Then you can try this query in phpMyAdmin: DELETE FROM `cot_tags` WHERE `tag` NOT IN (SELECT `tag` FROM `cot_tag_references`); This will remove any 'orphan' entries in the cot_tags table which don't have a record in cot_tag_references, so they won't show up in tag autocomplete anymore.

foxhound	#3 2012-05-21 21:10
Donator Thanked: 5 times	Thank you very much! Going to try that tomorrow after the server maintenance. <img src="http://www.armaholic.com/datas/thumbs/green-sea-battalion-uniforms-version-03-preview_4.jpg" alt="green-sea-battalion-uniforms-version-03-" />