Notifications
Clear all

wpForo 1.x.x SQL to delete Topics (along with posts), where tag is like '%unsafe%'?

5 Posts
3 Users
0 Likes
506 Views
mplusplus
Posts: 124
Topic starter
(@mplusplus)
Estimable Member
Joined: 3 years ago

Hi there

Will it be possible for you to provide SQL to delete Topics (along with posts), where TAG is like '%unsafe%', please?

Thanks.

Topic Tags
4 Replies
Robert
Posts: 9912
Admin
(@robert)
Support Team
Joined: 7 years ago

Hi @mplusplus,

Yes, it's possible. Here is the SQL. Just replace wp_ table prefix if it's different for your WordPress database.

DELETE FROM `wp_wpforo_topics` WHERE `tags` LIKE '%unsafe%'

After executing this SQL, go to Dashboard > Forums > Dashboard admin page and click these buttons:

  1. Delete All Caches
  2. Update Forum Statistic
  3. Update Topic Statistic
  4. Update User Statistic
  5. Delete All Caches (again)
Reply
3 Replies
mplusplus
(@mplusplus)
Joined: 3 years ago

Estimable Member
Posts: 124

@robert Will this delete associated replies/posts as well, please?

Thanks.

Reply
Alvina
Moderator
(@alvina)
Joined: 3 years ago

Member
Posts: 1872

@mplusplus,

Will this delete associated replies/posts as well, please?

Yes, the replies/posts will be deleted as well.

Reply
Robert
Admin
(@robert)
Joined: 7 years ago

Support Team
Posts: 9912

@mplusplus,

The replies will not be available on front-end and in dashboard. But they'll not be removed from the database.

Reply