Answers.Body: <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>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-07-20T14:41:37.987Z
Answers.LastActivityDate: 2022-07-20T14:41:37.987Z
Answers.UserDisplayName: user13346
Body: <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>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2022-02-28T09:53:08.467Z
Comments.Text: Are you using a plugin for your forms? If so, which one?
Comments.UserDisplayName: Mats Mikkel Rummelhoff
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2022-03-01T10:21:59.617Z
Comments.Text: 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.
Comments.UserDisplayName: Jeroen Vandekerckhove
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2022-03-01T10:39:15.680Z
Comments.Text: 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
Comments.UserDisplayName: Mats Mikkel Rummelhoff
Tags: <plugin-freeform><spam>
Title: clear all spam form inputs or mark as read
ThreadText: # 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>
  
  
  ---
  
  