Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Kurt Moskjaer Andersen 40 posts 95 karma points
    Oct 10, 2013 @ 13:22
    Kurt Moskjaer Andersen
    0

    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?

  • Markus Johansson 1936 posts 5864 karma points MVP 2x c-trib
    Oct 10, 2013 @ 15:40
    Markus Johansson
    0

    Hi!

    Hmm... Check the "SubscriptionId" parameter in the macro... does it exsist?

  • Kurt Moskjaer Andersen 40 posts 95 karma points
    Oct 10, 2013 @ 21:22
    Kurt Moskjaer Andersen
    0

    Yes it does and it has also been set.

  • Markus Johansson 1936 posts 5864 karma points MVP 2x c-trib
    Oct 10, 2013 @ 22:41
    Markus Johansson
    0

    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?

  • Kurt Moskjaer Andersen 40 posts 95 karma points
    Oct 14, 2013 @ 11:34
    Kurt Moskjaer Andersen
    0

    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.

  • Markus Johansson 1936 posts 5864 karma points MVP 2x c-trib
    Oct 14, 2013 @ 15:20
    Markus Johansson
    0

    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.

  • Kurt Moskjaer Andersen 40 posts 95 karma points
    Oct 14, 2013 @ 15:26
    Kurt Moskjaer Andersen
    0

    Well, the mailing list is present and has the id = 2, as you can see:

  • Markus Johansson 1936 posts 5864 karma points MVP 2x c-trib
    Oct 14, 2013 @ 15:31
    Markus Johansson
    0

    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

  • Kurt Moskjaer Andersen 40 posts 95 karma points
    Oct 14, 2013 @ 15:40
    Kurt Moskjaer Andersen
    0

    I have sent you the tracelog by mail.

Please Sign in or register to post replies

Write your reply to:

Draft