Notifications
Clear all

Limited Support

Our support team is currently on holiday from December 25, 2025 to January 7, 2026, and replies may be delayed during this period.

We appreciate your patience and understanding while our team is away. Thank you for being part of the wpForo community!

Merry Christmas and Happy Holidays! 🎄

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
1,206 Views
Posts: 127
Topic starter
(@mplusplus)
Reputable Member
Joined: 6 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: 1860
Moderator
(@alvina)
Member
Joined: 6 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: 1860
Moderator
(@alvina)
Member
Joined: 6 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: 6 years ago

Reputable Member
Posts: 127

@alvina Thanks so much 🙂