wow, it’s even worse than I thought.
You can only move 100 at a time to the trash. Then you have to repeat the process 100 at a time to permanently get rid of this spam.
Turns out I had over 5k spams from one ip address in China. The database load of all of these feedbacks neatly tucked away and labelled as “spam” by Askimet is massive. The timing of this spam coincided with a recent database crash of my website. Seeing as how I have to manually move it all to trash, then delete it, it’s three hours of my life I’ll never get back. Please fix this vulnerability and make it easier to delete spam messages.
This really is the worst contact form I’ve ever seen. if you have 10 or 50 spam, then no worries. But when you get hit with 6k and 500 per day going forward, it’s like pissing in the wind trying to delete all of this spam. Worst yet since I keep getting 504 gateway timeouts.
I am afraid it’s currently not possible to “Delete all Spam” like you would do with Comments. That’s a good suggestion though, and I can see how the situation can be frustrating for you right now.
I have passed on your feedback to our developers.
In the meantime, I am afraid the only quick solution would be to delete all Spams directly from your database. You can find them all in the posts table, like so:
SELECT * FROM wp_posts WHERE wp_posts.post_type= ‘feedback’ AND wp_posts.post_status= ‘spam’
Please note that your posts table might have a different name, based on the database prefix you chose when setting up your site.
I have over 14,000 feedbacks I need to delete, how do I do this quickly and easily?
We’re currently working on a solution to this issue. A ticket is also opened in core.trac about the problem: #16031
In the meantime, you can access and delete Spam Feedbacks in your database, as I mentioned above.
Yeah. 20k spam is seriously not fun stuff to deal with and having to go through my database and delete everything is even less fun.
What I don’t get is this; I get HUNDREDS (half a thousand FYI) a day in Feedback… And ZERO comment spam. What gives and why is the Contact Form so vulnerable to spam?
What I don’t get is this; I get HUNDREDS (half a thousand FYI) a day in Feedback… And ZERO comment spam. What gives and why is the Contact Form so vulnerable to spam?
That mostly depends on the spammers who found your site. One single spammer might have found your contact page and keeps submitting forms.
It might be worth trying to change things a bit to try to make things a bit more difficult for that spammer. Try adding an additional required field, maybe?
Also have got a lot of spam.
The SQL command is no good, because the form data still stays in wp post meta table, making that the database grows and grows…
Is there any SQL command for the wp post meta table?
Well, My feedback table was filled with over 11 thousand spams so i deleted it all,
if you want i have wrote the tutorial on my site here :
http://wpden.net/delete-feedback-jetpack/
Because many people are troubled by SPAM feedbacks
I just downloaded Jetpack for WP and haven’t installed it yet. This forum scares the living shit out of me. I am a single user, one site, author, not techie but not stupid. however, I’m now thinking I won’t install. I only wanted to get my WP posts to appear automatically on Tumblr and the plugins I found before Jetpack were outdated.
Ideas? Responses?
I only wanted to get my WP posts to appear automatically on Tumblr and the plugins I found before Jetpack were outdated.
You can install jetpack without using all of its features. If you only plan on using it to automatically publish your posts to Tumblr, you can deactivate all modules but the Publicize module.
You can read more about it here:
http://jetpack.me/support/activate-and-deactivate-modules/
http://jetpack.me/support/publicize/tumblr/
