Network Error (tcp_error) when sending emails using Universal Email

A client just sent out a large mailing, and received the following error:
Network Error (tcp_error)
A communication error occurred:
The Web Server may be down, too busy, or experiencing other problems preventing it from responding to requests. You may wish to try again at a later time.

Now, we're not sure which emails were sent out and which ones were not. Is there any way of telling, and how can we circumvent this error in the future? It's currently set up to send a maximum of 200 emails per 1 minute. Does this help?

Thank you.

That error could be caused by any number of things such as:
- a bad email address in the to
- exceeding the SMTP Server limits
- the SMTP server timing out
- PHP server timing out

and numerous others.

Most common would be the bad to address, or exceeding the SMTP server limits. You should check with your host to determine what the maximum number of email you can send out in a given time period are.

If the host has a limit of 1000 emails in a 24 hour period, you can easily exceed that by leaving the limit as 200 / second (you would hit the limit in 5 minutes)


in universal email there is a logging section which can be used to record which email addresses have been sent to, if you did not set up the logging, there isn't a way to tell who received the email.

In universal email there is a logging section which can be used to record which email addresses have been sent to, if you did not set up the logging, there isn't a way to tell who received the email.

Where is this log located? Thanks!

In the UE Server behavior, click the toolbar icon with the check mark and circle strike through to enter the logging settings screen.

When I select "On Failure Only" and "Create the Log Table for me." it won't let me save the UE interface. At that screen, I click finish and it takes me back to the main UE screen. On the main screen, when I click Finish, it does nothing. It will not close out the dialog box. the only way I can close it is if I click Cancel.

you will want to record both success and failure.

since your script is timing out, it is not getting to all addresses, you want to know which addresses it has been able to get to, those will be stored by the success and failure, emails not in the log are the addresses that the script did not get to before the time out.

The inability to save is a bug when using the Create Table for me option. you can use the following SQL to create the table:

CREATE TABLE `email_log` (
  `EmailID` int(11) NOT NULL AUTO_INCREMENT,
  `EmailTo` varchar(250) DEFAULT NULL,
  `EmailFrom` varchar(250) DEFAULT NULL,
  `EmailSubject` varchar(250) DEFAULT NULL,
  `EmailBody` text,
  `EmailHeader` text,
  `EmailError` text,
  `EmailStatus` varchar(50) DEFAULT NULL,
  `EmailDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`EmailID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1

then use the current email bindings in the log to set the logging settings.

This is the error I'm getting when I try to create the table on the server:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TABLE `email_log` ( `EmailID` int( 11 ) NOT NULL
AUTO_INCREMENT , `EmailT' at line 4

I had to create the table locally first, export it, and then run that script on the server. Now, the table has been created. However, I'm not sure what you mean by this: then use the current email bindings in the log to set the logging settings.

Thanks!

In the logging settings, set the response to insert record.

Select the Email Log table. For each column except the EmailID click the lightning bolt icon next to value, and use the Current email binding group.

Okay - done. For Event, should I choose On Success or Failure? What would make the most sense.

Both, you want to record both success an failure, those are the emails that it tried to send, the ones not recorded will be the ones that did not try to send when the script timed out.