We have bought Newsletter Studio 1.4 and installed it without any problems.
If we use the supplied macro NewsletterSubscribe, we get the following error:
Error loading Razor Script NewsletterSubscribe.cshtml A foreign key value cannot be inserted because a corresponding primary key value does not exist. [ Foreign key constraint name = FK_SubscribeListSubscriber1 ]
So you are inserting the macro from the Rich text editor right? It says that the subscription id of the mailing list should be 2. If you go to the Newsletter Studio-section and expand the "Maling list"-node. Are you 100% sure that there is a mailing list with the id of 2? What happens if you fo to this url in your solution?
Since the error message is "A foreign key value cannot be inserted because a corresponding primary key value does not exist" I'm quite sure that you've added the macro some time ago and then removed the mailing list from the Newsletter Studio-section.
Hmm... this is extremlly strange. Could you add the ?umbDebugShowTrace to the page url and see the whole error in the trace log? (or if you are on Umbraco 6+) look in the trace log in the /app_data/ folder.
I would like to see the strack trace of the error message...
Error in macro
We have bought Newsletter Studio 1.4 and installed it without any problems.
If we use the supplied macro NewsletterSubscribe, we get the following error:
Error loading Razor Script NewsletterSubscribe.cshtml
A foreign key value cannot be inserted because a corresponding primary key value does not exist. [ Foreign key constraint name = FK_SubscribeListSubscriber1 ]
Any suggestions?
Hi!
Hmm... Check the "SubscriptionId" parameter in the macro... does it exsist?
Yes it does and it has also been set.
And what is the value of the attribute in the macro? Does that list exsist in as a mailing list in the Newsletter Studio-section?
Yes, the list exists in the Newsletter Studio section and the macro is formatted like this:
<div umb_subscriptionid="2" umb_macroalias="Nyhedsmail" ismacro="true" onresizestart="return false;" umbversionid="fdb2c674-50ca-4fd9-b1c2-c481d27059ec" umbpageid="19206" title="This is rendered content from macro" class="umbMacroHolder"><!-- startUmbMacro --><span style="color: green;"><strong>Nyhedsmail</strong><br />No macro content available for WYSIWYG editing</span><!-- endUmbMacro --></div>
This issue occurs when the form has been submitted.
Hi!
So you are inserting the macro from the Rich text editor right? It says that the subscription id of the mailing list should be 2. If you go to the Newsletter Studio-section and expand the "Maling list"-node. Are you 100% sure that there is a mailing list with the id of 2? What happens if you fo to this url in your solution?
yourdomain.com/umbraco/NewsletterStudio/Pages/Subscription.aspx?id=2
?
Since the error message is "A foreign key value cannot be inserted because a corresponding primary key value does not exist" I'm quite sure that you've added the macro some time ago and then removed the mailing list from the Newsletter Studio-section.
Well, the mailing list is present and has the id = 2, as you can see:
Hi!
Hmm... this is extremlly strange. Could you add the ?umbDebugShowTrace to the page url and see the whole error in the trace log? (or if you are on Umbraco 6+) look in the trace log in the /app_data/ folder.
I would like to see the strack trace of the error message...
/ m
I have sent you the tracelog by mail.
is working on a reply...