Hi,

A set of database fields in perplexMailLog is getting Encrypted for security, which is a good thing.
However, the fields alternativeView and attachment are not getting encrypted, leaving the body of the email, including personal data, unencrypted.

Kind regards,

Sander

Great plug-in! But is it possible to validate a checkbox? eg.
{if [#somecheckbox#] = True } Yes {/if}

Client has raised an issue where they are trying to filter the email statistics for errors, but all records are being returned.

The problem seems to be this line in SQL_QUERY_GET_STATISTICS

" (@status = 1 AND result.[exception] IS NOT NULL) "

When an email is logged, if there are no errors, the exception field is set to an empty string, but the statistics query is checking for NULL.

I believe the check should be
" (@status = 1 AND result.[exception] IS NOT NULL AND result.[exception] <> '') "

Can you confirm that my assumption is correct and that it's not something we have done that has broken things?

Thanks

If we send mail from background -> body is empty. I think it happens because we have no umbraco context it this moment. Any assumptions ?

Is it possible to have the email statistics without link tracking? Or configure, per email, which links are tracked?

The link tracking creates strange looking urls e.g.
https://localhost:51137/?i=146&a=click&v=http%3a%2f%2fwww.abcdef.nz

and in some cases e.g. verify email link with token, the link is too long to store in the perplexMailStatistics table as the value field is limited to 255 characters. This causes a string truncation issue when link is clicked - which throws an exception on the site.

We are getting occasional errors when sending emails.

The error is "The statement has been terminated. (logging error) <== String or binary data would be truncated." and occurs at PerplexMail.Email.SendEmail():586

As far as I can tell, the emails are still being sent, however, the details are not being logged.

Looking at the perplexMailLog table, I noticed that the to/from/replyTo/cc/bcc fields are limited to 255 characters. Is it possible for the Security.Encrypt function to return more than 255 characters?

We are getting intermittent email failures with one or other of the following errors:

• The operation has timed out.
• Failure sending mail.; Unable to read data from the transport connection: net_io_connectionclosed.

There doesn't seem to be a pattern of when an email will succeed or fail, and using "Resend" from the Umbraco back-office is successful.

Some suggestions I have found online are:

• SmtpClient should be accessed within a "Using" statement to ensure that "QUIT" is sent to the server to close the connection
• Catch the error and retry

But both of these would require updating the PerplexMail code.

Just wondering if other users have had the same issue, and if you know of a solution.