Notifications

Clear all

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

How-to and Troubleshooting

Last Post by Robert 4 years ago

5 Posts

3 Users

0 Reactions

811 Views

RSS

Posts: 126

mplusplus

Topic starter

Oct 13, 2020 8:57 pm

(@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

delete topic

4 Replies

Posts: 10587

Robert

Admin

Oct 16, 2020 12:51 pm

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

Delete All Caches
Update Forum Statistic
Update Topic Statistic
Update User Statistic
Delete All Caches (again)

In case you want to say thank you !)
We'd really appreciate and be thankful if you leave a good review on plugin page. This is the best way to say thank you to this project and support team.

3 Replies

mplusplus

(@mplusplus)

Joined: 5 years ago

Reputable Member

Posts: 126

Oct 16, 2020 7:57 pm

Reply to

Robert

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

Thanks.

Alvina

Moderator

(@alvina)

Joined: 5 years ago

Member

Posts: 1863

Oct 17, 2020 9:07 am

Reply to

mplusplus

@mplusplus,

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

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

In case you want to say thank you !)
We'd really appreciate and be thankful if you leave a good review on plugin page. This is the best way to say thank you to this project and support team.

Robert

Admin

(@robert)

Joined: 9 years ago

Support Team

Posts: 10587

Oct 17, 2020 10:17 am

Reply to

mplusplus

@mplusplus,

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

In case you want to say thank you !)
We'd really appreciate and be thankful if you leave a good review on plugin page. This is the best way to say thank you to this project and support team.