Jump to content
  • 0

Unsent test emails under mail logs with unsent status, how to prevent them from sending


Chris van der Westhuizen

Question

Hi Team.  We changed our smtp mail settings to a false URL to prevent them from being emailed while we are testing.

Currently we have over 4000 emails (support/invoices/etc) with status Unsent.  What will happen if we correctly enter the smtp address?

We would like to cancel them all to prevent them from sending out if they still are to be sent.

Kind Regars, Chris

Link to comment
Share on other sites

4 answers to this question

Recommended Posts

  • 0
39 minutes ago, Chris van der Westhuizen said:

Hi Team.  We changed our smtp mail settings to a false URL to prevent them from being emailed while we are testing.

Currently we have over 4000 emails (support/invoices/etc) with status Unsent.  What will happen if we correctly enter the smtp address?

We would like to cancel them all to prevent them from sending out if they still are to be sent.

Kind Regars, Chris

Emails are stored in the log_emails table. You can empty this table out if it makes you feel better

Link to comment
Share on other sites

  • 0
20 hours ago, GosuHost said:

Emails are stored in the log_emails table. You can empty this table out if it makes you feel better

Okey, thanks.

I'm always feeling excellent! :-)

Just to make sure I understand correctly...

My assumption and not factual: Mails created and processed gets saved in log_emails.  I can leave or delete the emails records there with status as unsent, whatever I decide, and it will not have any effect.  Thus, mails will not be queued in Blesta to be sent later in case the SMTP server can momentarily not be reached for what ever reason, and the mails will only be added to the logs with status "unsent", which I can leave there, or delete if it will make me feel better, thus have no effect if I leave them there?

Thus I cannot rely on Blesta to make sure mails gets delivered later in case of a network or SMTP problem, like I caused intentionally for testing purposes.?  Thus it will occur that clients will not receive their invoices sometimes?

Excuse me if I might sound rude, I am really not and very humble.

Link to comment
Share on other sites

  • 0

The mail log is just a log of what was sent. If there are invoices that upon edit have the email box checked, they will be sent at the first opportunity. The solution to having these all go out, is to mark all invoices in the system as sent. I think this query will do it for you, but be sure to backup your database first!

UPDATE `invoice_delivery` SET date_sent="2018-03-12 00:00:00" WHERE date_sent=NULL AND method="email";

Query will set a sent date for all invoices that have not been sent and are queued for email delivery.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...