<p>Freeform has a purge spam submissions command to run with your terminal. <a href="https://docs.solspace.com/craft/freeform/v3/developer/console-commands.html#purge-commands" rel="nofollow noreferrer">https://docs.solspace.com/craft/freeform/v3/developer/console-commands.html#purge-commands</a></p>

CC BY-SA 4.0
2022-07-20T14:41:37.987Z
2022-07-20T14:41:37.987Z
user13346
<p>Is there somebody who could help with an sql query or a how-to to clean up our spam form inputs in a quick way, there are +/-5900 unread spam messages from last years and i want to clean them up.</p>
<p>We could do it by Forms &gt; Spam and select all (max 100) and do this 60times but it doesn't sound the fastest way.</p>
<p>There are different tables with links to this entries.</p>
<p>Running craftcms version: 3.4.20 on PHP 7 with Mysql</p>

CC BY-SA 4.0
2022-02-28T09:53:08.467Z
Are you using a plugin for your forms? If so, which one?
Mats Mikkel Rummelhoff
CC BY-SA 4.0
2022-03-01T10:21:59.617Z
I don't think so but when i check plugins, there is also freefrom version 3.6.9 in the list. In the database the freeform tables are used also, so yes we are using that plugin.
Jeroen Vandekerckhove
CC BY-SA 4.0
2022-03-01T10:39:15.680Z
Craft doesn't have a "Forms" menu item in the control panel by default, which is why I figured you're using a plugin. I don't know anything about Freeform myself, but I added the `plugin-freeform` tag to your question to increase visibility. You might consider getting in touch with the plugin vendor (Solspace) as well – https://solspace.com/contact-us
Mats Mikkel Rummelhoff
<plugin-freeform><spam>
clear all spam form inputs or mark as read
# clear all spam form inputs or mark as read

(Asked by: username_0 on 2022-02-24)

Is there somebody who could help with an sql query or a how-to to clean up our spam form inputs in a quick way, there are +/-5900 unread spam messages from last years and i want to clean them up.

We could do it by Forms > Spam and select all (max 100) and do this 60times but it doesn't sound the fastest way.

There are different tables with links to this entries.

Running craftcms version: 3.4.20 on PHP 7 with Mysql

**Tags:** plugin-freeform, spam

> **Comments:**
> **username_1**: Are you using a plugin for your forms? If so, which one?  
> **username_0**: I don't think so but when i check plugins, there is also freefrom version 3.6.9 in the list. In the database the freeform tables are used also, so yes we are using that plugin.  
> **username_1**: Craft doesn't have a "Forms" menu item in the control panel by default, which is why I figured you're using a plugin. I don't know anything about Freeform myself, but I added the `plugin-freeform` tag to your question to increase visibility. You might consider getting in touch with the plugin vendor (Solspace) as well – https://solspace.com/contact-us  

---

## 1 answers

### Answer by username_2 on 2022-07-20. Score: 1

Freeform has a purge spam submissions command to run with your terminal. <https://docs.solspace.com/craft/freeform/v3/developer/console-commands.html#purge-commands>


---

