Notifications
Clear all

Limited Support

Our team is currently on holiday, so support will be limited during this period. Response times may be slower than usual, and some inquiries may be delayed.
We appreciate your patience and understanding, and we’ll resume our usual support by the end of August.

 

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
917 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: 1861
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: 1861
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 🙂