Notifications
Clear all

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

5 Posts
3 Users
0 Reactions
800 Views
Posts: 126
Topic starter
(@mplusplus)
Reputable Member
Joined: 5 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: 10589
Admin
(@robert)
Support Team
Joined: 9 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)
3 Replies
(@mplusplus)
Joined: 5 years ago

Reputable Member
Posts: 126

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

Thanks.

Alvina
Moderator
(@alvina)
Joined: 5 years ago

Member
Posts: 1863

@mplusplus,

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

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

Robert
Admin
(@robert)
Joined: 9 years ago

Support Team
Posts: 10589

@mplusplus,

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