Delete bulk comments

If you are unfortunate enough to get spammed, you may be pounded by thousands of spam comments. Please consult your own IT professional for advice, but I have found this tip works perfectly. To remove unapproved comments manually could take hours (20 at a time from within WordPress Dashboard/Comments). To remove thousands of comments in seconds, I logged in to my hosting account (cpanel), navigated to “phpMyAdmin”, selected the database from list on left (corresponds to domain username), then chose the “SQL” tab, and added the following:

DELETE FROM wp_comments WHERE comment_approved = '0'

Then hit “Go” to run the SQL query, and spam gone.

Community Announcement

For anyone in Western Australia particularly, please sign this Change.org Hazard reduction burn petition.
We need to get it out there and get as many signatures as possible, so if you can, please share on your Facebook pages also.






Server Outages

Server outage details
Status: Resolved
Start: approx 3.20pm WST 21.7.2015
End: Resolved
Server: Sydney

More detail...



newsletter

Sign up for our free newsletter!
Use real names, names with gobblygook/random spelling will be removed from the mail list.
You can leave the list at any time. Removal instructions are included in each message.

Powered by WPNewsman



Made in Australia