Notifications
Clear all

wpForo 1.x.x [Solved] How to copy the forum title as a tag in all of it's topics (for thousands of topics)?

4 Posts
2 Users
1 Reactions
786 Views
Posts: 126
Topic starter
(@mplusplus)
Reputable Member
Joined: 5 years ago

Hi there

How to copy the forum title as a tag in all of the topics in that forum? 
Need to do that in thousands of topics.
E.g. all topics in "community/electric-cars" forum should get a tag "electric cars".

Thanks.

3 Replies
Alvina
Posts: 1863
Moderator
(@alvina)
Member
Joined: 5 years ago

Hi @mplusplus,

The first way is editing each topic and add "electric cars" as a tag.

I'll ask the developers if there is another easy way to do it. I'll update the topic as soon as possible.

Alvina
Posts: 1863
Moderator
(@alvina)
Member
Joined: 5 years ago

Please follow to these steps below:

1. Go to Dashboard > Plugins and Install "SQL Executioner" plugin.

2. Navigate to Tools > SQL Executioner, put this SQL in Query Textarea and click on Execute SQL button:


UPDATE `wp_wpforo_topics` t

INNER JOIN `wp_wpforo_forums` f ON f.`forumid` = t.`forumid`

SET t.`tags` = 'electric cars'

WHERE NOT t.`tags`

AND f.`slug` LIKE 'electric-cars'; INSERT IGNORE `wp_wpforo_tags` ( `tag`, `count` )

SELECT 'electric cars', COUNT(*)

FROM `wp_wpforo_topics`

WHERE FIND_IN_SET('electric cars', `tags`);

The red marked value can be changed.

Also please note: the "electric-cars" your forum slug.

The "electric cars" the tag name.

3.Navigate to the Dashboard > Forums > Dashboard admin page click on "Delete all caches" button.
4.Go to the frontend page press CTRL+F(5)twice before checking.

1 Reply
(@mplusplus)
Joined: 5 years ago

Reputable Member
Posts: 126

@alvina Thanks so much 🙂