Email sent with ERR as the body

Post Reply
ptopel
Posts: 4
Joined: Tue May 31, 2022 3:50 pm

Email sent with ERR as the body

Post by ptopel »

I set up Expiry for a few of my clients and confirmed emails were being sent. However, I have received reports from those users that the email just as ERR in the body and nothing else.

Is there some HTML tag(s) that Expiry doesn't support that would be causing this error?

User avatar
Cubert
Posts: 2134
Joined: Tue Dec 29, 2015 7:57 pm
6
Contact:

Re: Email sent with ERR as the body

Post by Cubert »

Can you post the source html of the email here for review and also a screenshot of the Expiry email configure view.

Lets see what you have going on.

ptopel
Posts: 4
Joined: Tue May 31, 2022 3:50 pm

Re: Email sent with ERR as the body

Post by ptopel »

Here is the code:

Code: Select all

<style type="text/css">
</style><meta name="robots" content="noindex,nofollow"></meta>
  <body class="main full-padding" style="margin: 0;padding: 0;-webkit-text-size-adjust: 100%;">
    <table class="wrapper" style="border-collapse: collapse;table-layout: fixed;min-width: 320px;width: 100%;background-color: #f5f6f8;" cellpadding="0" cellspacing="0" role="presentation"><tbody><tr><td>
      <div role="banner">
        <div class="preheader" style="Margin: 0 auto;max-width: 560px;min-width: 280px; width: 280px;width: calc(28000% - 167440px);">
          <div style="border-collapse: collapse;display: table;width: 100%;"> 
            <div class="snippet" style="display: table-cell;Float: left;font-size: 12px;line-height: 19px;max-width: 280px;min-width: 140px; width: 140px;width: calc(14000% - 78120px);padding: 10px 0 5px 0;color: #717a8a;font-family: sans-serif;">
            </div>
            <div class="webversion" style="display: table-cell;Float: left;font-size: 12px;line-height: 19px;max-width: 280px;min-width: 139px; width: 139px;width: calc(14100% - 78680px);padding: 10px 0 5px 0;text-align: right;color: #717a8a;font-family: sans-serif;">
            </div>
          </div>
        </div>
        <div class="header" style="Margin: 0 auto;max-width: 400px;min-width: 220px; width: 220px;width: calc(24000% - 147400px);" id="emb-email-header-container">
          <div class="logo emb-logo-margin-box" style="font-size: 26px;line-height: 16px;Margin-top: 6px;Margin-bottom: 20px;color: #41637e;font-family: Avenir,sans-serif;Margin-left: 20px;Margin-right: 20px;" align="center">
            <div class="logo-center" align="center" id="emb-email-header"><a style="text-decoration: none;transition: opacity 0.1s ease-in;color: #41637e;" href="https://britecity.createsend1.com/t/i-l-cuklyo-l-r/"><img style="display: block;height: auto;width: 100%;border: 0;max-width: 166px;" src="https://i1.createsend1.com/ei/i/48/A77/04E/070050/csfinal/BRITECITYlogotransparentbackground.png" alt="Visit the BRITECITY website" width="166"></a></div>
          </div>
        </div>
      </div>
      <div>
      <div class="layout one-col fixed-width stack" style="Margin: 0 auto;max-width: 600px;min-width: 320px; width: 320px;width: calc(28000% - 167400px);overflow-wrap: break-word;word-wrap: break-word;word-break: break-word;">
        <div class="layout__inner" style="border-collapse: collapse;display: table;width: 100%;background-color: #ffffff;">
          <div class="column" style="text-align: left;color: #717a8a;font-size: 16px;line-height: 24px;font-family: sans-serif;">
            <div style="Margin-left: 20px;Margin-right: 20px;Margin-top: 24px;">
      <div style="mso-line-height-rule: exactly;line-height: 8px;font-size: 1px;">&nbsp;</div>
    </div>
            <div style="Margin-left: 20px;Margin-right: 20px;">
      <div style="mso-line-height-rule: exactly;line-height: 8px;font-size: 1px;">&nbsp;</div>
    </div>
            <div style="Margin-left: 20px;Margin-right: 20px;Margin-bottom: 24px;">
      <div style="mso-line-height-rule: exactly;mso-text-raise: 11px;vertical-align: middle;">
        <h3 style="Margin-top: 0;Margin-bottom: 0;font-style: normal;font-weight: normal;color: #3d3b3d;font-size: 17px;line-height: 26px;">Dear @MYNAME@</h3><h3 style="Margin-top: 12px;Margin-bottom: 0;font-style: normal;font-weight: normal;color: #3d3b3d;font-size: 17px;line-height: 26px;">Your password to login is about to expire</h3><p style="Margin-top: 12px;Margin-bottom: 0;">This is a reminder that your computer password is about to expire in @DAYSLEFT@ days.&nbsp; Please ensure you login and change your password.&nbsp;</p><p style="Margin-top: 20px;Margin-bottom: 0;">Do not hesitate to reach out to your techTEAM if you have any questions.&nbsp; We are always here to help.&nbsp;</p><p style="Margin-top: 20px;Margin-bottom: 0;">*If you are in the Office, then hit Control+Alt+Delete, and hit change password, If you are not in the office, connect to the VPN first, then follow the same steps to reset your password.</p><p style="Margin-top: 
20px;Margin-bottom: 0;">Your Technology Department,<br>
BRITECITY<br>
<span style="text-decoration: inherit;"><a class="telLinkerInserted" style="text-decoration: underline;transition: opacity 0.1s ease-in;color: #f0561f;" href="https://britecity.createsend1.com/t/i-l-cuklyo-l-y/">949-243-7440</a></span><br>
<u><span style="text-decoration: inherit;color: #f26225;">help@britecity.com</span></u></p>
      </div>
      </div>
      <div style="mso-line-height-rule: exactly;line-height: 20px;font-size: 20px;">&nbsp;</div>
      </div>
      <div role="contentinfo"><div style="line-height:4px;font-size:4px;" id="footer-top-spacing">&nbsp;</div><div class="layout email-flexible-footer email-footer" style="Margin: 0 auto;max-width: 600px;min-width: 320px; width: 320px;width: calc(28000% - 167400px);overflow-wrap: break-word;word-wrap: break-word;word-break: break-word;" id="footer-content">
      <div class="layout__inner left-aligned-footer" style="border-collapse: collapse;display: table;width: 100%;">
          <div class="column" style="text-align: left;font-size: 12px;line-height: 19px;color: #717a8a;font-family: sans-serif;display: none;">
      <div class="footer-logo emb-logo-margin-box" style="font-size: 26px;line-height: 32px;Margin-top: 6px;Margin-bottom: 20px;color: #7b663d;font-family: Roboto,Tahoma,sans-serif;" align="center">
        <div emb-flexible-footer-logo align="center"></div>
      </div>
    </div>
          <div class="column" style="text-align: left;font-size: 12px;line-height: 19px;color: #717a8a;font-family: sans-serif;display: none;">
      <div style="margin-left: 0;margin-right: 0;Margin-top: 10px;Margin-bottom: 10px;">
        <div class="footer__share-button">
        </div>
      </div>
    </div>
          <table style="border-collapse: collapse;table-layout: fixed;display: inline-block;width: 600px;" cellpadding="0" cellspacing="0"><tbody><tr><td><div class="column js-footer-additional-info" style="text-align: left;font-size: 12px;line-height: 19px;color: #717a8a;font-family: sans-serif;width: 600px;">
      <div style="margin-left: 0;margin-right: 0;Margin-top: 10px;Margin-bottom: 10px;"> 
    </td></tr></tbody></table>
  <style type="text/css">
</style>
</body>
</html>
And the screenshot requested
2022-06-03 12 53 16.jpg
2022-06-03 12 53 16.jpg (517.97 KiB) Viewed 2523 times

User avatar
Cubert
Posts: 2134
Joined: Tue Dec 29, 2015 7:57 pm
6
Contact:

Re: Email sent with ERR as the body

Post by Cubert »

Ok lets test the email sending.


Take your email code and paste it in to the body of a single line Automate script function to email someone. This is what we use to send the email so we save what you have to the database then write it out to the body of the email function in the automate script engine to send out.

So assuming that plugin saves work, (you are able to see the text when reopening the expiry plugin?) it should copy that data to the email body and sends.

Send yourself a test email and see if it is messed up when received? If so then the code you are using is not compatible with this email function. I can't see why it would be a problem.


Screenshot 2022-06-06 083906.png
Screenshot 2022-06-06 083906.png (52.31 KiB) Viewed 2491 times

ptopel
Posts: 4
Joined: Tue May 31, 2022 3:50 pm

Re: Email sent with ERR as the body

Post by ptopel »

Hi,

I did the single line Automate script like you suggested and the email was correctly formated looked like it does in the Email viewer. I turned on the Plugin for one of my clients, made sure the HTML was the same as I have listed in this topic but the users received an email that says "command line too long"

Please advise

User avatar
Cubert
Posts: 2134
Joined: Tue Dec 29, 2015 7:57 pm
6
Contact:

Re: Email sent with ERR as the body

Post by Cubert »

Ok what happens if you clear the email body out and just use a very simple set of tags as a test.

Maybe a <H1> and a <P> and send a test email. Make sure to give your self a few <br> in there as well.


Send a email test and see if the client email gets the same response.


When I google email that says "command line too long" to see where that error would be generated from I get a lot of stuff about server side SMTP protocol issues but nothing that really points at an email that is received with that in it. The errors they reference would show in some SMTP log not in a email that I am aware of. So I do not think that is the path for the answer currently.


This test will narrow down if it is the client as a whole (any email from plugin) or just the current email template.

If we find it to be the template then what I will need next is:
  • The original template- the one you originally copy from
  • The current copy and paste from the email body viewer.
  • If possible grab the SQL query below, change the 123 to the client ID your working with and send us the results.

Code: Select all

Select EmailBody FROM plugin_sw_expiry_configure WHERE ClientID = 123 

Either you or I can then compare the 3 different outputs to make sure they remained equal.

We then can add a new "ScriptLog" line to the script here to print out the decrypted "@EMAILBODY@" we get from line 24-26 in the Expiry script located in the "Scripts/maintenance/" folder of automate.

Screenshot 2022-06-14 140552.png
Screenshot 2022-06-14 140552.png (91.88 KiB) Viewed 2401 times

User avatar
Cubert
Posts: 2134
Joined: Tue Dec 29, 2015 7:57 pm
6
Contact:

Re: Email sent with ERR as the body

Post by Cubert »

The idea between all the tests is to see if email template remains consistent, no added or removed characters and that the script is correctly decrypting email body from database.


I suspect this is where the issue will really lie. The query you get from the SQL statement will be in Base64 encoded data.

In script we use powershell to decode this string. It may be that that powersehll request is returning that error and then we just place that error into email body. And thus how the email has said error in it.

To test this theory:
Copy and paste the SQL return data from the SQL query given above and paste that return into the shell command below replacing @EMAILBODYENCODED@ with the base64 encoded data received from SQL query. Then copy the entire command and paste into a shell of any Windows box with Powershell 2.0 or higher. Output should be the same as the original email template.

Code: Select all

@powershell -NoProfile -ExecutionPolicy unrestricted -Command [System.Text.Encoding]::Unicode.GetString([System.Convert]::FromBase64String('@EMAILBODYENCODED@'))

ptopel
Posts: 4
Joined: Tue May 31, 2022 3:50 pm

Re: Email sent with ERR as the body

Post by ptopel »

Hi,

Thank you for the response. We recreated the email body using a different tool. The tool made the code must simpler and smaller in size. We then tested the new HTML and it functioned as expected with no erros.

Thank you again for your assistance.

User avatar
Cubert
Posts: 2134
Joined: Tue Dec 29, 2015 7:57 pm
6
Contact:

Re: Email sent with ERR as the body

Post by Cubert »

Well ok then! That works for us....

Post Reply

Return to “Expiry Domain Password Expiration Plugin”