AI Search
Classic Search
Notifications
Clear all
Oct 14, 2020 12:57 am
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 4: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)
Oct 16, 2020 11:57 pm
Translate
▼
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
Translate
▼
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
Will this delete associated replies/posts as well, please?
Yes, the replies/posts will be deleted as well.
Oct 17, 2020 2:17 pm
Translate
▼
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
The replies will not be available on front-end and in dashboard. But they'll not be removed from the database.