Remove Spam Contacts from Flamingo (Contact Form 7)
-
Hello,
I have been using Flamingo to store messages and contacts from Contact Form 7 submissions – but we managed to pick up a lot of spam after this was activated as we tested out anti-spam functions to go with.
We now require to go through the messages stored, and mark those as spam. This will be a manual task as many of our clients use personal email addresses or leave the contact field blank on certain forms.
My issue is how do we then remove all the contacts that are linked to the spam messages? Essentially we would need to automatically link a spam contact to messages that were manually marked as spam. I have seen some solutions online to use SQL code around for a process similar to the below:
1. Identify messages marked as spam in Inbound Messages
2. Identify which email addresses in the Address Book are linked to these spam messages
3. Delete spam contacts by email addresses identified
But I hope there is an easier way to do this rather than have to go through the Address Book manually or use SQL commands? Does anyone have an easy solution for this?
My (and my web developer’s) concern with the SQL method is that there isn’t an obvious way to import any backed-up contacts, so if the SQL commands don’t operate correctly we could lose a lot of customer/lead info that I wouldn’t be able to import back into Flamingo. The issue with manually removing spam contacts is the sheer quantity (over 2000 form submissions to cross reference with contacts).
I have a pro license for CF7/Flamingo if that helps – I have also linked a screen recording below which should help clarify the issue (note: it is only internal data visible here so as not to breach any users’ data privacy):
Thanks,
William Louden, Marketing Manager – Innova Drilling & Intervention
The blog I need help with is: (visible only to logged in users)
-
We can’t help with third party plugins as Flamingo. You must take a look in Flamingo documentation or contact their support for advice .
-
As @staartmees mentioned, we are not able to provide support for Flamingo or Contact Form 7 as they are third-party products. We can help make sure they are working on your site and not causing errors but you’ll need to reach out to the developers of these products for help.
The data is likely stored in the database and can likely be cleaned up using SQL. The developers of Flamingo may be able to help you with the queries to run.
We don’t generally recommend editing the database but if needed you can use phpMyAdmin to do this where you can run SQL queries. We have a guide for accessing your site’s database here: https://developer.wordpress.com/docs/developer-tools/database-access/.
-
The developers list WordPress forums as their primary support tool – the link on their website takes you to the ‘Contact Form 7’ section of wordpress.org support forums. However, since our site uses wordpress.com I cannot access this with my credentials.
There must be a way to get support for Contact Form 7 being used on WordPress.com? They have no contact details and advise on their website that if you attempt to use their contact form for a support query that it will be ignored and the user blocked.
-
Hi! When you’re seeking support for a plugin that provides it through WordPress.org’s support forums, the host of your site (in this case, that’s WordPress.com) isn’t relevant – you can create a new account with WordPress.org from here: https://login.wordpress.org/register?locale=en_US and post your question in the corresponding support forum: https://wordpress.org/support/plugin/contact-form-7/ – hope that helps!
-
-
- The topic ‘Remove Spam Contacts from Flamingo (Contact Form 7)’ is closed to new replies.
WordPress.com Forums 