Sign in Register
Copied to clipboard

Flag this post as spam?

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


  • Sören Deger 726 posts 2833 karma points c-trib
    Jul 10, 2014 @ 07:56
    Sören Deger
    0

    ExecuteSQL Action on package install not working

    Hi,

    I will create a new relation type on package installation in Umbraco 7.1.4. I use this package action:

    <Action runat="install" undo="false" alias="ExecuteSql"><![CDATA[INSERT INTO umbracoRelationType (dual, parentObjectType, childObjectType, name, alias) VALUES (1, 'c66ba18e-eaf3-4cff-8a22-41b16d66a972', 'c66ba18e-eaf3-4cff-8a22-41b16d66a972', N'myRelation', N'myRelation');]]></Action>

    But after package installation I have now new entry in the databasetable. The sql-statement in this package action works in MS Sql Management Studio. Only If I use this sql statement in in the package action nothing happens.

    Has anyone an idea to solve this?

     

    Best regards

    Sören

    Copy Link
  • Richard Soeteman 3875 posts 12037 karma points MVP
    Jul 10, 2014 @ 09:13
    Richard Soeteman
    100

    Hi Sören,

    The action works on V7.1.4. I'm using it in all my packages check the logfile to see the error and you need the Package action contrib dll http://our.umbraco.org/projects/backoffice-extensions/package-actions-contrib to use this action.

    Hope this helps,

    Richard

    Copy Link
  • Sören Deger 726 posts 2833 karma points c-trib
    Jul 10, 2014 @ 09:34
    Sören Deger
    0

    Hi RIchard,

    thank you! I have forget the Package action contrib dll. Now it works :-)

     

    Sören

    Copy Link

  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies