Sign in Register
Go to solution
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 733 posts 2844 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 4046 posts 12899 karma points MVP 2x
    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 733 posts 2844 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
Please Sign in or register to post replies

Write your reply to:

Draft