executesql not executing on package install

Press Ctrl / CMD + C to copy this to your clipboard.

Copied to clipboard

Flag this post as spam?

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

Nigel Wilson 945 posts 2077 karma points

Sep 30, 2011 @ 22:01
0

ExecuteSQL not executing on Package Install
Hi there

I have just tried creating my first package which is meant to:
1. Copy some files
2. Add a macro
3. Create a custom table in the database
However when running the install the custom table is not being created in the database.

My action is
```
<Action runat="install" undo="true" alias="ExecuteSql">
<![CDATA[CREATE TABLE [dbo].[likes] ([id] [int] NOT NULL,[likes] [int] NOT NULL,PRIMARY KEY (id))]]>
</Action>
```
I have manually executed the SQL in SQL Server Management studio and it creates the table.

I have checked installedPackages.config and the SQL is showing up there as an action.

The database user account in my web.config (sa) is the database owner so the problem should not be a database permissions issue.

Can anyone provide any suggestions as to where this might be failing.

Thanks

Nigel
Copy Link
Nigel Wilson 945 posts 2077 karma points

Oct 01, 2011 @ 20:00

0

Hey

An update which I hope sheds some light and may generate some feedback.

The site I tried a test install of the package was version 4.7.1 - the Execute SQL statements are in the config but the tables never get created.

I have just tested the same package on a 4.7.0 site and it worked perfectly.

Here is the package - is anyone able to try installing this on a 4.7.1 site and provide feedback on the outcome ?

If you try it please advise if a dB table called pageLikes is created.

If similar results by other users then I will log it as a bug.

Thanks

Nigel

Copy Link
trfletch 598 posts 604 karma points

Apr 27, 2012 @ 18:34

0

Hi Nigel,

I know this is an old post but I wondered if you or anyone else has managed to resolve this issue? I am having the same problem with a clean install of Umbraco 4.7.2. The rest of the package seems to install fine but the tables do not get created in the database. If I run the script within SQL Management Studio then the tables get created without any problems.

I have looked in the Umbraco log table but this does not seem to have any log of an error.

Anyone have any ideas?

Many Thanks

Tony

Copy Link
is working on a reply...

Please Sign in or register to post replies

Flag this post as spam?