Welcome to the Question2Answer Q&A. There's also a demo if you just want to try it out.
+2 votes
200 views
in Q2A Core by
I changed my site's question classification to categories only. But still old spammy, irrelevant and common word tags are there. Moreover these tags are the main cause of showing wrong related posts. So I want to delete all irrelevant tags.
How can I delete all tags together without showing as retagged on activity page? Are there a table in database to delete all these tags?
Q2A version: 1.8
by
Yes, it should be possible. What do you mean by "showing wrong related posts"? Also do you want to delete ALL tags from ALL questions?
by
users will make irrelevant or useless tags. So the related posts will show based on these tags. For example if a post about difference between home and house has a tag 'difference' in it and another two posts about 'apple and mango' or 'car and bike' also having the same tag 'difference'. Then, even though these all are from different categories they will show up in related posts. In my opinion a general category q2a should not use tags. Only categories are needed. Even if we set it as only categories in general tab, still those tags are hidden there. how to delete those tags?
by
Got it. But still the second question is not answered. You want to delete "those tags" or "all tags"?
by
aLL TAGS. I don't want any tags on my site. Where is it located in database?

1 Answer

+2 votes
by
selected by
 
Best answer

Run this SQL query:

UPDATE `qa_posts`
SET `tags` = ''
WHERE `type` LIKE 'Q%';

Then navigate to admin/stats and click on the Reindex content button.

Also remember you can always use this plugin: https://github.com/svivian/q2a-tagging-tools for managing tags.

by
Yes now reindexed and all tags have gone. Thank you
by
While checking alexa change in cutestat google backlinks there are showing like  1410,000,000 something like that. a very big number. What does it mean? Is it something related to this huge number of tags ?
by
I think I'm not the right person to answer that question. I don't think it is. Anyway, make sure you don't have the Tags page enabled (like this one https://www.question2answer.org/qa/tags) and let's see if the number decrease after a while. If it does, maybe it is related. But that's definitely not my area of knowledge
by
let's see if it is changing after a week or not. thank you
...