Emails cannot be deleted

  • If you delete emails from your Sent & Draft, they will be removed from this table, but they will still exist in the system. You can confirm this by checking a subscriber’s email history. Additionally, these emails will not be deleted from the wp_wpmlemails table, which can accumulate a large amount of data over time.

    How can we delete emails?

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Tribulant Software

    (@contrid)

    Hi Michael,

    This is intentional. It is for the sake of logging and keeping the reports accurate. The email logs are stored under the emails table and must remain as is. You can remove those emails at your own risk, if you are aware of the consequences, but please note that it’s not recommended.

    The table name is the one you mentioned, {prefix}_wpmlemails, and you can remove all of the emails at once using a query, or by emptying the table via phpMyAdmin or per row. But, take a database backup prior to doing so, and note that the statistics will no longer work correctly after that. No bounce, no pending queue, no statistics.

    Thread Starter Michael

    (@michael8888)

    Thanks for the reply.

    The issue is that the wpmlemails table grows significantly over time. I have observed a table with 6,000,000 entries and a size of 2GB. This puts a substantial burden on the database system and slows down the entire system. It doesn’t make sense to retain information on individual newsletter emails that were sent many years ago if this leads to performance problems.

    What about the Email Archiving feature? Isn’t it supposed to clear old entries from wpmlemails? I enabled this feature and set Archive Older Than to 365 days, but much older emails are still in the system and it had no effect on wpmlemails. wp-content/uploads/newsletters-lite/emailarchive.txt wasn’t created. I waited several hours.

    Could you please clarify the purpose of the email archiving feature? Also, when does the archiving process take place?

    Plugin Author Tribulant Software

    (@contrid)

    I believe there’s an issue with the email archiving feature so we’ve been working on fixing it. Thanks for mentioning it here! It may related to using external cron (cPanel, etc.) rather than WP Cron, or it may be something else. We’re almost done with fixing it and it will be ready for the next version release, if everything goes well.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Emails cannot be deleted’ is closed to new replies.