Press Ctrl / CMD + C to copy this to your clipboard.
This post will be reported to the moderators as potential spam to be looked at
on Umbraco 4.7.1 with the SQL Compact Edition database, this package did not create it's database table
I got it to work by changing the create table SQL in package.xml to
CREATE TABLE infocaster301 ( NodeID int NOT NULL, OldUrl nvarchar(400) NOT NULL, IsCustom bit NOT NULL DEFAULT 0, IsRegex bit NOT NULL DEFAULT 0, Message nvarchar(400) NULL, Inserted datetime NOT NULL DEFAULT getdate(), CONSTRAINT PK_infocaster301 PRIMARY KEY ( NodeID ASC, OldUrl))
Thanks for sharing this Robert :D
Just tried this on ce4.0 and it didnt like the ASC in the pimary key.
Removed that and it worked just fine! :)
This package is so nice and it would be ace if this was simply just fixed so one would not need to do the trick above when using CE SQL :)
is working on a reply...
Write your reply to:
Image will be uploaded when post is submitted