Contact form spammed

Permalink
Hi all,
I have a form block setup on my contact page that have been spammed (with default image captcha enable) last weeks/months.

Then i just intalled reCAPTCHA v3, tho i m not sure i have it running fine.

I added site and secret keys to captcha setup, everything seems to be working, my contact page now display Protected by Recaptcha (see attached file), but there is no action or answer to provide.
Is there anything worng ?

I would have another question about the forms results, i now have 46 pages of forms from spamming, how can i delete them all ?
I cant believe i would have to go through all 400+ forms entries to delete them (each delete means 3 clics).

Any help will be welcome !
thanks

1 Attachment

 
ConcreteOwl replied on at Permalink Reply
ConcreteOwl
To answer your second question, you can run a custom query on the database like this..
TRUNCATE `btFormAnswerSet`;
TRUNCATE `btFormAnswers`;
radeff replied on at Permalink Reply
radeff
The solution of ConcreteOwl is good but quite dangerous!
It will erase ALL the datas collected by ALL your forms (if you have many)
So first maybe have a look at the content of both tables... then you may truncate or delete with some sql criteria
ConcreteOwl replied on at Permalink Reply
ConcreteOwl
The question was and I quote "how can i delete them all ?"
Hence the answer.
radeff replied on at Permalink Reply
radeff
yes sorry of course...
MattPesquet replied on at Permalink Reply
Thanks ConcreteOwl and radeff.

That is maybe some crazy idea of mine, but i think i m not the only one that would take avantage of being able to multi select entries to delete them (for example just a check box row and a delete button at the entry list level), or a select all entries button (if you display 100 results per page you can delete them in one go).

Especially when you want to delete lot of entries but not all of them.

About reCAPTCHA v3, i m still not sure, but i guess this new captcha works just tracking data provided by user in the form and how it interacts with the site to return a "risk" score and filter spam.