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.
Oct 13, 2020 8:57 pm
Hi there
Will it be possible for you to provide SQL to delete Topics (along with posts), where TAG is like '%unsafe%', please?
Thanks.
4 Replies
Oct 16, 2020 12:51 pm
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)