Claude Rhay Torre
asked 9 years ago

Spams are everywhere. I was wondering how can I mass delete these spam answers I have. I have over about 12,000 spam answers. I can only delete it one by one which takes forever! Is there any way where I can delete these spams collectively?

Hoping for a quick response! Thanks!

1 Answers
DominicStaff
answered 9 years ago

Hi,
To resolve this issue, you can try the following solution:
Solution 1: If you want to delete all the answer from Q&A plugin on the site, you can go to the phpmyadmin > Tab SQL then add the line SQL following:
DELETE FROM $table_prefix_posts WHERE post_type='dwqa-answer'
Solution 2: You can remove the question from an author. To do it, you can add the line SQL following:
DELETE FROM $table_prefix_posts WHERE post_type='dwqa-answer' AND post_author='id author'
Note: Change the $table_prefix = your $table_prefix in the wp-config.php file.
See the screenshot: http://prntscr.com/5cptoy
Solution3: you can log in to Dashboard > User > Find the user, then delete the user that you choose and select the all content from user.
Hope this helps !

Dominic Staff
replied 7 years ago

I have answered your question in the question that you submitted. Please check your question. We will discuss about your question.

Powered by DW Question & Answer Pro