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?
Email sent with ERR as the body
Re: Email sent with ERR as the body
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.
Lets see what you have going on.
Re: Email sent with ERR as the body
Here is the code:
And the screenshot requested
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;"> </div>
</div>
<div style="Margin-left: 20px;Margin-right: 20px;">
<div style="mso-line-height-rule: exactly;line-height: 8px;font-size: 1px;"> </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. Please ensure you login and change your password. </p><p style="Margin-top: 20px;Margin-bottom: 0;">Do not hesitate to reach out to your techTEAM if you have any questions. We are always here to help. </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;"> </div>
</div>
<div role="contentinfo"><div style="line-height:4px;font-size:4px;" id="footer-top-spacing"> </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>- 2022-06-03 12 53 16.jpg (517.97 KiB) Viewed 36725 times
Re: Email sent with ERR as the body
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.
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 (52.31 KiB) Viewed 36693 times
Re: Email sent with ERR as the body
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
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
Re: Email sent with ERR as the body
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:
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.
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 (91.88 KiB) Viewed 36603 times
Re: Email sent with ERR as the body
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.
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@'))Re: Email sent with ERR as the body
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.
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.
Re: Email sent with ERR as the body
Well ok then! That works for us....