How do i remove tags from database?

In this board you can talk about general questions about phpMyFAQ

Moderator: Thorsten

Post Reply
epicflupe
Posts: 42
Joined: Thu Sep 20, 2007 8:42 am

How do i remove tags from database?

Post by epicflupe » Tue Oct 21, 2008 7:28 am

Hi!

I have deleted a lot of questions, but the tags remain in the frontend.

How do i remove the tags?

Thanks in advance.

/Eric

Lidio
Posts: 25
Joined: Mon Dec 10, 2007 9:26 pm

Post by Lidio » Tue Oct 21, 2008 4:19 pm

Eric,

I would caution you about removing "too many" tags. [In my instance we had authors use Tags as if they were "keywords" (yikes!) and got over 350 tags] One of the routines gets a random selection of 50 tags and if a certain combination is triggered you will find it will go into a infinite loop resulting in a PHP time out and nothing displayed on the browser.

I discovered this the hard way in a test environment and have not had time to re-write that code to offer as a patch. Perhaps Thorsten & company will re-visit the management of tags for a better solution.

Lidio.

Thorsten
Posts: 14913
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Post by Thorsten » Tue Oct 21, 2008 6:09 pm

Hi,

I take a look in the "tagging" code. The tags should be deleted if a record is deleted.

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist

Thorsten
Posts: 14913
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Post by Thorsten » Tue Oct 21, 2008 6:21 pm

Hi,

okay, the relation between the FAQ record and the tagging id is deleted, but not the tag itself because a tag can be in various records. A routine for deleting tags with no relation with any FAQ record is missing. I'll work on that issue.

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist

epicflupe
Posts: 42
Joined: Thu Sep 20, 2007 8:42 am

Re: How do i remove tags from database?

Post by epicflupe » Thu Mar 26, 2009 2:59 pm

Hi!

Thorsten! Do you have a solution for this? I don´t want to upgrade (running 2.0.3) - can i remove tags manually without implications?

Thanks. /Eric

Thorsten
Posts: 14913
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Re: How do i remove tags from database?

Post by Thorsten » Thu Mar 26, 2009 3:07 pm

Hi,

yes, you can remove them.

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist

epicflupe
Posts: 42
Joined: Thu Sep 20, 2007 8:42 am

Re: How do i remove tags from database?

Post by epicflupe » Thu Mar 26, 2009 3:24 pm

Thanks for the anwser. In which file, och how, do i remove the tags?

Thorsten
Posts: 14913
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Re: How do i remove tags from database?

Post by Thorsten » Thu Mar 26, 2009 3:40 pm

Hi,

you have to delete them in the DB table faqtags.

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist

valeu
Posts: 1
Joined: Sun May 17, 2009 10:48 pm
Contact:

Re: How do i remove tags from database?

Post by valeu » Sun May 17, 2009 10:52 pm

Hello,
It is possible to remove somehow from a database all tags automatically one command?

Post Reply