1.5.2 Installation failure in Umbraco 6 with SQL Server CE 4
I ran into an issue installing 1.5.2 version of 301 URL Tracker in Umbraco 6 running on SQL Server CE 4. Installation completes however clicking on Settings/301 URL Tracker node produces an SQL "table not found" error.
Problem
Installation SQL script syntax is not compatible with SQL Server CE 4
Resolution
Replace SQL script in package.xml (ExecuteSQL action) file with the following script:
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, OldUrl))
1.5.2 Installation failure in Umbraco 6 with SQL Server CE 4
I ran into an issue installing 1.5.2 version of 301 URL Tracker in Umbraco 6 running on SQL Server CE 4. Installation completes however clicking on Settings/301 URL Tracker node produces an SQL "table not found" error.
Problem
Installation SQL script syntax is not compatible with SQL Server CE 4
Resolution
Replace SQL script in package.xml (ExecuteSQL action) file with the following script:
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, OldUrl))
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.