I have just upgraded a test/stage environment running Newsletter 2.0
to the new 2.1 version.
Before installing the update package (2.1), I have modified the existing table (from 2.0) ns_EmailTrackingItems and added the column CustomData with nvarchar(max) - noticed this is the new column introduced in 2.1 which collects the member properties name/value pair as json.
After this installed the updated 2.1 package, its completed without errors.
Noticed it also retained the customsubscriptionprovider that I installed at 2.0, so i assumed its all ok.
However, when I do a test email which contains [unsubscribe] and/or [readonline] merge-fields, in the email received the unsubscription URL shows like this:
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.InvalidOperationException: Sequence contains no elements
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
[EDIT]:
To further clarify, the above case is when i send email to built-in mailing list, where i can see the entry in ns_Newsletters SubscriptionAlias column value as NewsletterStudioSubscriptionProvider_3
So its nothing to do with customsubscription provider, just to be sure disabled that in newsletter.config and tried again with the same result as above.
Would appreciate if you can shed some light on what might be the issue.
The error that you are talking about here indicates that the newsletter was deleted from the database? Is that error from you "read onlin" link? Are you getting the same error when clicking the unsubscribe-link?
I might be some room for bugfixes here - but it's important to know if the newsletter was deleted from the db or not?
Thats the error from unsubscribe link. read online just shows empty, blank page.
I did delete a previous newsletter entry from the db, while testing custom subscr. provider - but i thought i did delete the reference from tracking table too.
The above case is when i create a new newsletter under draft, send out and click the unsub or readonline link. If you think the manual editing of previous entry is the cause, how can I go about fixing it?
I've tracked this down now. The issues has to do with Papercut.
For some reasone, Papercut will not redirect to the whole URL when clicking the links. If you view the source of the email and copy/paste the links in the browser it will work. I've also tested this by sending a real email to my inbox and click the link which works.
I'll also post a bug-report for this in the papercut-forums. So I'll set this issue as fixed from now.
Thanks for the update. It might be coincidence of findinf out readonly link not working due to papercut.
So i have removed papercut from the equation.
The issue seems to be a wider problem, the Preview button, on NS-section, is returning empty when I compose a new mail and click Preview. Emptied cached etc.
Could this be related to a database check? I can send test blast emails, see analytics. But when I create a new email, insert template, edit contents then click Preview nothing shows anymore.
Is this potentially related with manually editing the database?
While troubleshooting blast-send (papercut errors etc.) and custom subsc. provider, as mentioned above, I did delete a previous test newsletter entry from the db, but i did delete the reference from tracking table too.
What are the possible causes for Preview not working (not rendering the page)?
Would appreciate if you can shed some light on this.
It's hard to say why this don't work but if I understand you right the actual email send out works? What if you send a "test email" to someone? Would that work?
Do you see any errors in the browser (use developer tools to check the ajax requests going on while loading the preview) or in the Umbraco log?
Upgrading from 2.0 to 2.1
Hi there
I have just upgraded a test/stage environment running Newsletter 2.0 to the new 2.1 version.
Before installing the update package (2.1), I have modified the existing table (from 2.0) ns_EmailTrackingItems and added the column CustomData with nvarchar(max) - noticed this is the new column introduced in 2.1 which collects the member properties name/value pair as json.
After this installed the updated 2.1 package, its completed without errors. Noticed it also retained the customsubscriptionprovider that I installed at 2.0, so i assumed its all ok.
However, when I do a test email which contains [unsubscribe] and/or [readonline] merge-fields, in the email received the unsubscription URL shows like this:
http://staging.local/app_plugins/newsletterstudio/pages/tracking/unsubscribe.aspx?e=217173132145038194019171099944025069090197238102175012135240199010063231041097128123033166093245
and the error message:
Sequence contains no elements
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.InvalidOperationException: Sequence contains no elements
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[InvalidOperationException: Sequence contains no elements] System.Linq.Enumerable.First(IEnumerable`1 source) +514 NewsletterStudio.Infrastucture.Data.PPDatabaseAdaptor.First(String sql, Object[] parameters) +103 NewsletterStudio.Infrastucture.Data.NewsletterRepository.GetById(Int32 id) +114 NewsletterStudio.AppPlugins.NewsletterStudio.Pages.Tracking.Unsubscribe.PageLoad(Object sender, EventArgs e) +159 System.Web.UI.Control.LoadRecursive() +71 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3178
Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.34249
I am not sure what might be the issue...
Similarly when I click on the readonline link i get a URL like;
http://staging.local/app_plugins/newsletterstudio/pages/rendernewsletter.aspx?nid=209174247083994125198147101002058075190188156019
with empty contents (i.e. blank page).
[EDIT]: To further clarify, the above case is when i send email to built-in mailing list, where i can see the entry in ns_Newsletters SubscriptionAlias column value as
NewsletterStudioSubscriptionProvider_3So its nothing to do with customsubscription provider, just to be sure disabled that in newsletter.config and tried again with the same result as above.
Would appreciate if you can shed some light on what might be the issue.
Thank you
Hi!
Sorry to hear that you have issues!
The error that you are talking about here indicates that the newsletter was deleted from the database? Is that error from you "read onlin" link? Are you getting the same error when clicking the unsubscribe-link?
I might be some room for bugfixes here - but it's important to know if the newsletter was deleted from the db or not?
// m
Hi again
Thats the error from unsubscribe link. read online just shows empty, blank page.
I did delete a previous newsletter entry from the db, while testing custom subscr. provider - but i thought i did delete the reference from tracking table too.
The above case is when i create a new newsletter under draft, send out and click the unsub or readonline link. If you think the manual editing of previous entry is the cause, how can I go about fixing it?
Hi!
So you are getting this error when the newsletter is not deleted as well?
We need to research and try to reproduce this to se if you can do something or if we need to create a patch for this issue.
/ m
Hi again Markus
Yes, when a new draft created, and dispatched where body contains [unsubscribe] or readonline placeholders.
Upon clicking the unsubscribe link thats the error i receive. From creation of new draft to sending there is no deletion etc. in the db.
I have moved the other inquiry to separate thread:
https://our.umbraco.org/projects/backoffice-extensions/newsletter-studio/comments//71145-invalid-attempt-to-call-read-when-reader-is-closed
To get back on the topic, if I dont fiddle with the ns_ tables, from the NS section create a new newsletter under drafts which includes [unsubscribe]
on the recipient it renders the unsubscribe url but when clicked shows the error
any help would be much appreciated
I've managed to reproduce this issue and we're looking at a fix right now.
Hi!
I've tracked this down now. The issues has to do with Papercut.
For some reasone, Papercut will not redirect to the whole URL when clicking the links. If you view the source of the email and copy/paste the links in the browser it will work. I've also tested this by sending a real email to my inbox and click the link which works.
I'll also post a bug-report for this in the papercut-forums. So I'll set this issue as fixed from now.
// m
Hi Markus
Thanks for the update. It might be coincidence of findinf out readonly link not working due to papercut.
So i have removed papercut from the equation.
The issue seems to be a wider problem, the Preview button, on NS-section, is returning empty when I compose a new mail and click Preview. Emptied cached etc.
Could this be related to a database check? I can send test blast emails, see analytics. But when I create a new email, insert template, edit contents then click Preview nothing shows anymore.
Is this potentially related with manually editing the database? While troubleshooting blast-send (papercut errors etc.) and custom subsc. provider, as mentioned above, I did delete a previous test newsletter entry from the db, but i did delete the reference from tracking table too.
What are the possible causes for Preview not working (not rendering the page)?
Would appreciate if you can shed some light on this.
Hi!
It's hard to say why this don't work but if I understand you right the actual email send out works? What if you send a "test email" to someone? Would that work?
Do you see any errors in the browser (use developer tools to check the ajax requests going on while loading the preview) or in the Umbraco log?
// m
is working on a reply...