Hi Yiannis!

Thank you for using the package! Lets try to figure out whats wrong.

Have you configured the smtp correctly? Status 4 means completed....

public const Int32 Created = 0;
public const Int32 Paused = 1;
public const Int32 InProgress = 2;
public const Int32 Error = 3;
public const Int32 Completed = 4;

Is there any email tracking items created? (look at the db table ns_EmailTrackingItems), what kind of status do they have?

What does the call to /TestWeb return?

Have a look here as well to try to track down the problem. http://support.newsletterstudio.org/customer/portal/articles/1147738-i-get-an-error-what-is-wrong-

Hello.

Thank you for the list of status codes, quite useful.

Actually, I believe that smtp is set correctly, seeing that sending the newsletter to a test email goes through flawlessly.

On the other hand, I seem to have had a minor change in behaviour:

Now, when I FIRST try to send a new (saved) draft, I get

 "d":"\u003cspan style=\u0027color:red\u0027\u003eAn service-error has occured. The sending was aborted. Please try again.\u003c/span\u003e"}

No email tracking items are created.

I am not seeing anything inside app_data/logs, BUT!

This is in UmbracoLog table:

NsletterStudio, SendNewsletterService: Umbraco Exception (DataLayer): SQL helper exception in ExecuteNonQuery : System.Data.SqlClient.SqlException (0x80131904):

 The INSERT statement conflicted with the FOREIGN KEY constraint "FK_EmailTrackingItemNewsletter1". The conflict occurred in database "LaoudisDB", table "LaoudisDBO.ns_Newsletters", column 'Id'.  The statement has been terminated.     at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)     at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)     at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()     at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)     at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)     at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)     at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)     at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)     at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()     at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters)     at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters)     at umbraco.DataLayer.SqlHelpers.SqlServer.SqlServerHelper.ExecuteNonQuery(String commandText, SqlParameter[] parameters)     at umbraco.DataLayer.SqlHelper`1.ExecuteNonQuery(String commandText, IParameter[] parameters)

 In all subsequent attempts to send the newsletter the response from /testWeb is invariably

{"d":"\u003cdiv class=\"sendoutAjax\"\u003e\u003cp\u003eInitializing sending serivce. May take several minutes.\u003c/p\u003e\u003c/div\u003e"}

without any errors being logged, or email tracking items being creted.

Any insight into this will be greatly appreciated.

Hi!

I see, it looks like there is something wrong with your relations in the db. Is this a clean install or an upgrade? Did you reinstall the package or something?

It looks like its the "FK_EmailTrackingItemNewsletter1" that is creating this issue. 

Is there a "FK_EmailTrackingItemNewsletter"? 

I would recommend you to do a clean install in a new enviroment and compare the dbs.

/ m
 

Hello.

This is a clean install - though I believe it is 1.3.2 or 1.3.3 (if that makes a difference). The FK_EmailTrackingItemNewsletter1 exists and is a foreign key constraint between ns_EmailTrackingItems.NewsletterId (foreign) and ns_Newsletters.Id (primary), with "No Action" in both Delete and Update Action. There is no "FK_EmailTrackingItemNewsletter", only a "FK_EmailTrackingItemNewsletter1" (a query to sys.objects says so, and I have no reason to doubt it :) ).

Regards,

Yiannis

Hi!

Should not matter as this part of the code have not changed. Can you try in another clean install of Umbraco and see if you have the same problem? What db are you using?

/ m

I'm using SQL Server 2008.

A clean install in a different umbraco instance is not really an option at this point.

I would have deleted and re-installed the package on the site - however it seems that the package does not appear in the list of installed packages, so I guess I'll have to delete it by hand. 

If I'm not mistaken, I'll have to

1. remove all tables with the "ns_" prefix from the database,
2. delete the newsletterstudio.dll  from the bin folder
3. delete the entire newsletterstudio folder in umbraco.
4. edit tinyMCE.config, and dashboard.config to remove references to newsletterstudio.

Then I can proceed with a new istallation.

Am I missing something in that list? (apart from the obvious "0. Backup")

Regards
Yiannis 

Hi!

The package, if installed correctly, should show in the list of installed packages and both install/uninstall should work automatic.

Any way... your list of actions looks good. The config-files for TinyMCE is important - but you'll get errors if there is any issue with them.

/ m 

Unfortunately no cigar...

I found references to newsletter studio in a few more configs (application.config, umbracoSettings.config, treeIcons.config), plus two folders in umbraco_client/tinyMCE/plugins, and a few entries in language files. I recycles the application pool to force a config re-read, then tried to install newsletter studio from the package repository, however I'm getting the below error.

It seems that I have a leftover config value somewhere, but I can't for the life of me figure out where.

System.ArgumentException: An item with the same key has already been added.

System.Web.HttpUnhandledException (0x80004005): Exception of type 'System.Web.HttpUnhandledException' was thrown. ---> System.ArgumentException: An item with the same key has already been added.
   at System.ThrowHelper.ThrowArgumentException(ExceptionResource resource)
   at System.Collections.Generic.Dictionary`2.Insert(TKey key, TValue value, Boolean add)
   at umbraco.cms.businesslogic.packager.Installer.LoadConfig(String tempDir)
   at umbraco.presentation.developer.packages.Installer.startInstall(Object sender, EventArgs e)
   at System.Web.UI.WebControls.Button.OnClick(EventArgs e)
   at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)
   at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
   at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
   at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
   at System.Web.UI.Page.HandleError(Exception e)
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
   at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
   at System.Web.UI.Page.ProcessRequest()
   at System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context)
   at System.Web.UI.Page.ProcessRequest(HttpContext context)
   at ASP.umbraco_developer_packages_installer_aspx.ProcessRequest(HttpContext context)
   at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() 

at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) 

Regards,
Yiannis 

Well...

After all this fiddling, I was forced to restore from the backup, because it seems I had broken something in umbraco (media edit would throw a null reference error). However, what I did, was install the database tables manually instead of restoring them from the backup, and then pass in the template (skin) on top. This seems to have done the trick, as I was able to successfully send a newsletter to my (newly created) test list.

Thank you for bearing with me even though I had not yet purchased a license - I will be doing so promptly though.

Regards,
Yiannis 

Hi!

Finally! I'm glad to hear that you found a solution! To bad that we did not find the source to the problems. I guess it had someting to do with the FKs.

No problem Yiannis!

Just let me know if you need any futher assistans!

// Markus

Hello again.

We tried to purchase a license yesterday, but there seems to be an issue with our VAT number, the order form does not accept it as valid, though the official tool by EU at http://ec.europa.eu/taxation_customs/vies/vatResponse.html says it is valid - I've sent an email to support but haven't yet got a reply...

Regards,

Yiannis

Thats the tool that is being used by the web service. Could be an issue with the web shop. I'll anwser you questions from the support-email.

Hi!

Did not get any email, which address are you using?

Hopefully you can understand my reluctance to disclose my email address on the forum. I sent an email to support yesterday around 15:40 EET (i.e. 12:40 UTC).

I wish this forum had a "private message" function...

Hi!

I mean which of our emails? The [email protected]? Please use my email, markus [at sign goes here] enkelmedia.se

// m

is working on a reply...