How do i remove tags from database?

In this board you can talk about general questions about phpMyFAQ

Moderator: Thorsten

Post Reply
epicflupe

How do i remove tags from database?

Post by epicflupe »

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 »

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: 15560
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Post by Thorsten »

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: 15560
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Post by Thorsten »

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

Re: How do i remove tags from database?

Post by epicflupe »

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: 15560
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Re: How do i remove tags from database?

Post by Thorsten »

Hi,

yes, you can remove them.

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
epicflupe

Re: How do i remove tags from database?

Post by epicflupe »

Thanks for the anwser. In which file, och how, do i remove the tags?
Thorsten
Posts: 15560
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Re: How do i remove tags from database?

Post by Thorsten »

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 »

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