Logging fails when email receiver list exceeds 200 characters

  • Resolved conkatinator

    (@conkatinator)


    1 year, 3 months ago

    In the wp_wpml_mails table, the receiver column has a character limit of 200. When sending notification emails about new woocommerce orders to 7 or 8 people with long email addresses, these emails failed to be captured by the log because the list exceeded that character count.

    My team thought the emails were failing to send and spent several days debugging the issue. It turned out, due to the character limit in WP Mail Logging’s table, the emails were just failing to be logged. This affects our ability to accurately asses when and where order notifications are going.

    200 characters is a very small limit for a list of emails. Can this be increased? Or at least not completely fail to log if the list of recipients is too long?

    I noticed that the subject column also has a 200 character limit so it should be increased there as well.

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Support Dake

    (@dakeg)

    Hi @conkatinator

    Thank you for reaching out to us and for sharing this. I have informed our developers and will get back to you as soon as we have more information.

    Plugin Support Victoria Sakal

    (@sakalvictoria)

    Hi, @conkatinator!

    Thanks for your patience!

    Our development team will extend character limits in the next releases.

    In the meantime, you can do it by executing the next SQL query:

    ALTER TABLE wp_wpml_mails
    MODIFY receiver text,
    MODIFY subject text;

    Please, make sure to backup your database before running the command.

    I apologize for the trouble with this and thank you that you’ve pointed it out to us.

    Kind regards.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Logging fails when email receiver list exceeds 200 characters’ is closed to new replies.