Is there a maximum mail length to be logged correctly?

  • Resolved falkemediawy

    (@falkemediawy)


    5 months, 2 weeks ago

    Hi there,

    I’ve encountered an issue where mails are sent out fine (using SMTP) and I also receive them. However, they are not displayed in the email log. While trying to figure out the issue I noticed that the mail (an order confirmation) can get quite long (~2000 lines of custom HTML/~145.000 characters/~150 KB when saved as .txt). Leaving out the details of the order in the mail (massively reducing the mail body) resulted in the mail being logged correctly.

    My question now is: Can a large mail body really be the reason for a mail to not be logged? And if it is, is this a limitation of the plugin or can I do something to enable larger emails to be logged as well? (some kind of setting, filter, or database adjustment maybe?) Or alternatively, can I somehow manually save an email to the log leaving out the big mail body (of course not wanting to send the email twice)?

    Plugin version is 1.12.0

    • This topic was modified 5 months, 2 weeks ago by falkemediawy.
Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Support David

    (@dpinson)

    Hi there @falkemediawy,

    Thanks for reaching out. Yes, currently, the way we store email content has a limit of around 65,535 characters.

    I’ll reach out to our team to see if there is a way around the limitation. I’ll get back to you once I have more information.

    In the meantime, if you have any questions, just let us know!

    Thanks!

    Thread Starter falkemediawy

    (@falkemediawy)

    Thank you, David! Apart from this issue I’m fine and have been using the plugin for years now with no problems ?? Thank you for your great work! I’m looking forward to your response!

    Plugin Support Darshana

    (@darshanaw)

    Hi @falkemediawy,

    Thank you for your patience! Based on our discussion with our developers, it is possible to change the data type of the stored email content to allow for a larger data storage capacity.

    In your WP Mail Logging table, named?_wpml_mails?(without the WP table prefix that is usually?wp, but it can be something random as well), you need to edit the DB structure of the?message?column, by changing its?type?from?text? to?longtext.

    In case it helps, you could consider reaching out to your hosting support for assistance in making these changes. They should be able to help you with the necessary modifications.

    If you encounter any performance issues after making the changes, it is recommended to revert back to the previous state.

    I hope this helps. Thanks!

    Thread Starter falkemediawy

    (@falkemediawy)

    Hi @darshanaw, changing the DB structure worked like a charm, thank you! The long emails are now visible in the log, and I don’t notice any significant performance issues.

    The DB structure isn’t altered during plugin updates, correct? Or do I need to keep an eye on the right column type in the future? I suppose if I deactivate the plugin and reactivate it, that’s when I’ll need to change the data type again?

    Plugin Support Darshana

    (@darshanaw)

    Hi @falkemediawy,

    Thanks for the confirmation & we’re glad to hear that.

    As I have checked with our developers, we currently do not change the database structure during plugin updates.

    I hope this helps. Thanks!

    Thread Starter falkemediawy

    (@falkemediawy)

    Thank you @darshanaw and @dpinson for figuring out a solution so quickly for me! Have a nice day!

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