Edit Tag

hi

any one know how can i edit tag Area

Because I have a lot of bad tags and I want to delete them

thanks to everyone who can help

first thing you can do, is add the 'bad' tags to your non-parseable list on the admin panel.

admin --> settings --> Tag Settings

then go to phpmyadmin or however you manage  your database, and look for the table sys_tags

and clean that up

Deano's tools lets you delete them, but there should be some tool that lets you "normalize' them  - i.e. edit similarly spelled tags into one format.

Well, it's kinda boring to check the sys_tag every day to remove the profile tags some users uses for spam, it would be so easy maintained if it was within dolphin, and a permission for say moderators of the site to be able to maintain this too, just my 2c..

Thank you all again

 you are correct, that was the reason for mentioning the Tag Settings in the admin panel which will allow you to omit certain known spam tags ugg boots and italian leather handbags.

 then somebody else mentioned Deanos Tools (free mod) that will allow management of those tags as well.

Any other ideas besides Deanos Tools, which I have, to remove tags easily?

Some kind of sql code to remove them.. I have couple sites with too many tags..

• 27686 of them on one site as of right now. 

Using D Tools I'm only able to remove 10 at a time and going DosDawgs way is not going to happen.

I need to be able to clean them up like weekly or something.

Any help is greatly appreciated!

Anyone? 

Can't I just drop the table from the database then put back empty?

Thought I'd bring this back up since I'm working on a site with 1,869,090 site "Tags" and need to clean this mess up.

If dumping them all is what you want, then this will do it. Run this SQL in phpMyAdmin

TRUNCATE TABLE `sys_tags`

 Thanks Deano, I will make that suggestion to them.

Tags can be a way to make it easy to search for topics but I am wondering if on a very large site that is very busy if not having tags would be desirable. 

 the site is heavy in videos, not much at all from the tags, these are all from spammers mostly.

site is fine until one of the users tries to pull up the tags page and start searching; brings the site to a crawl.

You could be more specific on the removal as well. For example..

DELETE FROM `sys_tags` WHERE `Type` != 'bx_videos'

Should delete all tags that are not video tags.