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 [Closed] SQL to delete Topics (along with posts), where tag is like '%unsafe%'?

5 Posts
3 Users
0 Reactions
973 Views
Posts: 127
Topic starter
(@mplusplus)
Reputable Member
Joined: 6 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: 10616
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: 6 years ago

Reputable Member
Posts: 127

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

Thanks.

Alvina
Moderator
(@alvina)
Joined: 6 years ago

Member
Posts: 1861

@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: 10616

@mplusplus,

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