I'm trying to use the UltraSMTP plugin because I want events to be able to send emails from a couple of different FROM addresses. I'm having 3 problems:
1) is there a way to test each SMTP address I add, for example on the SMTP Profiles page, to make sure the info is correct (port numbers, password, etc.)
2) when I tried to add a second (both Gmail) address, I filled in the fields but when I hit "Create", it says "Unable to add new SMTP account profile due to an unexpected error."
3) when I use "UltraSMTP3 Send an Email" in my Event's action, I don't see where I'd specify the address I want it to use.
what am I doing wrong? Also, I see this in my log:
Dec-23 12:51:35 PM Error Email Queue Id 000001 to @@@ was deferred.
Dec-23 12:50:25 PM Error Email Queue Id 000001 to @@@ was deferred.
Dec-23 12:49:41 PM 1 Error System.Data.SQLite.SQLiteException (0x80004005): constraint failed columns smtp_server, smtp_port are not unique at System.Data.SQLite.SQLite3.Reset(SQLiteStatement stmt) at System.Data.SQLite.SQLite3.Step(SQLiteStatement stmt) at System.Data.SQLite.SQLiteDataReader.NextResult() at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave) at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavi or behavior) at System.Data.SQLite.SQLiteCommand.ExecuteScalar() at HSPI_ULTRASMTP3.hspi_plugin.InsertSmtpProfile(String smtp_server, Int32 smtp_port, Int32 smtp_ssl, String auth_user, String auth_pass, String mail_from)
Dec-23 12:49:41 PM 1 Error System.Data.SQLite.SQLiteException
Dec-23 12:49:28 PM 1 Error System.Data.SQLite.SQLiteException (0x80004005): constraint failed columns smtp_server, smtp_port are not unique at System.Data.SQLite.SQLite3.Reset(SQLiteStatement stmt) at System.Data.SQLite.SQLite3.Step(SQLiteStatement stmt) at System.Data.SQLite.SQLiteDataReader.NextResult() at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave) at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavi or behavior) at System.Data.SQLite.SQLiteCommand.ExecuteScalar() at HSPI_ULTRASMTP3.hspi_plugin.InsertSmtpProfile(String smtp_server, Int32 smtp_port, Int32 smtp_ssl, String auth_user, String auth_pass, String mail_from)
Dec-23 12:49:28 PM 1 Error System.Data.SQLite.SQLiteException
Dec-23 12:49:14 PM Error Email Queue Id 000001 to @@@ was deferred.
Dec-23 12:48:04 PM Error Email Queue Id 000001 to @@@ was deferred.
Dec-23 12:47:37 PM 1 Error System.Data.SQLite.SQLiteException (0x80004005): constraint failed columns smtp_server, smtp_port are not unique at System.Data.SQLite.SQLite3.Reset(SQLiteStatement stmt) at System.Data.SQLite.SQLite3.Step(SQLiteStatement stmt) at System.Data.SQLite.SQLiteDataReader.NextResult() at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave) at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavi or behavior) at System.Data.SQLite.SQLiteCommand.ExecuteScalar() at HSPI_ULTRASMTP3.hspi_plugin.InsertSmtpProfile(String smtp_server, Int32 smtp_port, Int32 smtp_ssl, String auth_user, String auth_pass, String mail_from)
Dec-23 12:47:37 PM 1 Error System.Data.SQLite.SQLiteException
Dec-23 12:46:54 PM Error Email Queue Id 000001 to @@@ was deferred.
Dec-23 12:45:43 PM Error Email Queue Id 000001 to @@@ was deferred.
(I have replaced my email address with "@@@" in the paste of the log text)
1) is there a way to test each SMTP address I add, for example on the SMTP Profiles page, to make sure the info is correct (port numbers, password, etc.)
2) when I tried to add a second (both Gmail) address, I filled in the fields but when I hit "Create", it says "Unable to add new SMTP account profile due to an unexpected error."
3) when I use "UltraSMTP3 Send an Email" in my Event's action, I don't see where I'd specify the address I want it to use.
what am I doing wrong? Also, I see this in my log:
Dec-23 12:51:35 PM Error Email Queue Id 000001 to @@@ was deferred.
Dec-23 12:50:25 PM Error Email Queue Id 000001 to @@@ was deferred.
Dec-23 12:49:41 PM 1 Error System.Data.SQLite.SQLiteException (0x80004005): constraint failed columns smtp_server, smtp_port are not unique at System.Data.SQLite.SQLite3.Reset(SQLiteStatement stmt) at System.Data.SQLite.SQLite3.Step(SQLiteStatement stmt) at System.Data.SQLite.SQLiteDataReader.NextResult() at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave) at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavi or behavior) at System.Data.SQLite.SQLiteCommand.ExecuteScalar() at HSPI_ULTRASMTP3.hspi_plugin.InsertSmtpProfile(String smtp_server, Int32 smtp_port, Int32 smtp_ssl, String auth_user, String auth_pass, String mail_from)
Dec-23 12:49:41 PM 1 Error System.Data.SQLite.SQLiteException
Dec-23 12:49:28 PM 1 Error System.Data.SQLite.SQLiteException (0x80004005): constraint failed columns smtp_server, smtp_port are not unique at System.Data.SQLite.SQLite3.Reset(SQLiteStatement stmt) at System.Data.SQLite.SQLite3.Step(SQLiteStatement stmt) at System.Data.SQLite.SQLiteDataReader.NextResult() at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave) at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavi or behavior) at System.Data.SQLite.SQLiteCommand.ExecuteScalar() at HSPI_ULTRASMTP3.hspi_plugin.InsertSmtpProfile(String smtp_server, Int32 smtp_port, Int32 smtp_ssl, String auth_user, String auth_pass, String mail_from)
Dec-23 12:49:28 PM 1 Error System.Data.SQLite.SQLiteException
Dec-23 12:49:14 PM Error Email Queue Id 000001 to @@@ was deferred.
Dec-23 12:48:04 PM Error Email Queue Id 000001 to @@@ was deferred.
Dec-23 12:47:37 PM 1 Error System.Data.SQLite.SQLiteException (0x80004005): constraint failed columns smtp_server, smtp_port are not unique at System.Data.SQLite.SQLite3.Reset(SQLiteStatement stmt) at System.Data.SQLite.SQLite3.Step(SQLiteStatement stmt) at System.Data.SQLite.SQLiteDataReader.NextResult() at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave) at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavi or behavior) at System.Data.SQLite.SQLiteCommand.ExecuteScalar() at HSPI_ULTRASMTP3.hspi_plugin.InsertSmtpProfile(String smtp_server, Int32 smtp_port, Int32 smtp_ssl, String auth_user, String auth_pass, String mail_from)
Dec-23 12:47:37 PM 1 Error System.Data.SQLite.SQLiteException
Dec-23 12:46:54 PM Error Email Queue Id 000001 to @@@ was deferred.
Dec-23 12:45:43 PM Error Email Queue Id 000001 to @@@ was deferred.
(I have replaced my email address with "@@@" in the paste of the log text)