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 :)
/Jan
is working on a reply...
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.
Continue discussion
Database table creation fails in SQL CE 4 - with solution
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 :)
/Jan
is working on a reply...
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.