How To Delete Bulk Spam Questions From PHPmyadmin

Toqeer Abbas
asked 10 years ago

Few Weeks I can not visit my website in meanwhile a large number of spam questions asked.
Now i can not delete these questions from wordpress.
All website is working fine but it is taking too much bandwidth and diskspace.
please help me how to delete all pending questions from cpanel ( phpmyadmin ) or any other way that can help me?
Thanks

4 Answers

Toqeer Abbas
answered 10 years ago

Any Help, It Is Urgent. I Need, Help My Website Is Extra loaded Due to spam.

DominicStaff
answered 10 years ago

Hi,
Deleting bulk spam question directly from Cpanel (phpmyadmin) is not a good idea, so that we don’t encourage and support this method.
The best solution is now to delete them manually as on the following screenshot.
http://prntscr.com/5cd1yk
Of course, we know it is extremely time consuming 🙁 but there is no better choice here.

Hope this helps !

Toqeer Abbas
answered 10 years ago

Dear I Have 17,000 Spam How am I supposed to delete these one by one.

DominicStaff
answered 10 years ago

To resolve this issue, you can do as the following.
Solution 1: If you want to delete all the question 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 IN (‘dwqa-question’, ‘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_author=’id author‘
Note: Change the $table_prefix = your $table_prefix in the wp-config.php file.
See the screenshot: http://prntscr.com/5cptoy
Hope this helps !