How to delete thousands of entries?

  • Hi,

    We had unfortunately turned off Captcha for the page where we have Everest forms enabled. There are some 8000+ spam entries.

    Removing in bulk using the checkbox only removes a handful at a time.

    How do we remove all the thousands of spam entries? Where in the database could we remove the records from?

    Thanks, Caesar.

Viewing 1 replies (of 1 total)
  • Plugin Support sanjuacharya77

    (@sanjuacharya77)

    Hi @caesarsamsi,

    The entries data for Everest Forms is stored in the evf_entries table. Over 8,000 spam entries were generated due to Captcha being disabled. To remove them directly from the database, follow these steps:

    1. Access your WordPress database using phpMyAdmin or any other database tool.
    2. 2. Locate the evf_entries table.
    3. Identify spam entries manually or by using SQL queries targeting patterns (e.g., keywords or email domains)
    4. Run an SQL query to delete spam, e.g.:

    DELETE FROM evf_entries WHERE field_values LIKE '%spamKeyword%';

    5. Backup your database before deleting

    Let us know whether it works for you or not and I will get back to you.

    Regards!

Viewing 1 replies (of 1 total)
  • You must be logged in to reply to this topic.