Need Sql command to delete Spam Form Submissions

Support has been upgraded!



The Support Forum is closed. Not to worry!  Providing the top quality support you expect and we're known for will continue! We're not ending support, just changing where you submit requests. This will provide you with the best experience possible.

Premium Support

Have you purchased an addon for Connections such as one of our premium templates or extensions with a valid license and you need help?

Please open a Support Ticket in your user account.

Click here to open a support ticket.

Free Support

Are you using the free Connections plugin? Don't worry, you are still very important to us! We are still providing you with the same high quality support that we're known for.

Please open a new support topic in the WordPress support forums for Connections.

Click here to open a support topic.

This topic is: resolved

Tagged: , , ,

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • 06/10/2013 at 4:52 am #262203
    Jenny
    Guest

    Hi there,

    My client’s site got spammed with thousands of spam submissions on cFORM. There are so many spam submissions listed, that even using bulk delete function in admin is going to take forever.

    So, can anyone give me a sql command that will only target “unlisted” entries in connections and bulk delete them?

    06/10/2013 at 12:41 pm #262218
    Steven Zahm
    Keymaster

    @ Jenny

    Really? This is the first report of any spam hitting Form. After a year and a half of my demo being up, I still haven’t received one.

    The query would be:

    DELETE FROM wp_connections WHERE status = "pending"

    A few notes:
    Backup the db first.
    I would test by deleting a single row first, but that’s your call.
    The “wp_” prefix in the SQL may have to be adjusted to match the correct table prefix.
    Lastly, this will delete any valid submissions.

  • Author
    Posts
Viewing 2 posts - 1 through 2 (of 2 total)

You cannot reply to this support topic. Please open your own support topic.