Umbraco (6.1.6 on SQL CE Edition) crashed when installing '301 URL Tracker'
Hi
I tried to install the '301 URL Tracker' in my Umbraco (6.1.6) running on a SQL CE Edition - and it crashed! The package had to be uninstalled manually.
Anyone know if this package has problems on a SQL CE Edition or should I try again?
I have tried it myself at tonight and I so get an error. But if you gets an error something like this:
Error running NonQuery: SQL Statement: IF EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'icUrlTracker') AND NOT EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'icUrlTracker' AND COLUMN_NAME = 'ForceRedirect') BEGIN ALTER TABLE [icUrlTracker] ADD ForceRedirect bit NOT NULL CONSTRAINT DF_icUrlTracker_ForceRedirect DEFAULT 0 END
Exception: System.Data.SqlServerCe.SqlCeException (0x80004005): There was an error parsing the query. [ Token line number = 1,Token line offset = 1,Token in error = IF ] at System.Data.SqlServerCe.SqlCeCommand.ProcessResults(Int32 hr) at System.Data.SqlServerCe.SqlCeCommand.CompileQueryPlan() at System.Data.SqlServerCe.SqlCeCommand.ExecuteCommand(CommandBehavior behavior, String method, ResultSetOptions options) at System.Data.SqlServerCe.SqlCeCommand.ExecuteNonQuery() at SqlCE4Umbraco.SqlCeApplicationBlock.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlCeParameter[] commandParameters)
Umbraco (6.1.6 on SQL CE Edition) crashed when installing '301 URL Tracker'
Hi
I tried to install the '301 URL Tracker' in my Umbraco (6.1.6) running on a SQL CE Edition - and it crashed! The package had to be uninstalled manually.
Anyone know if this package has problems on a SQL CE Edition or should I try again?
Rgrds Magnus
Hi Magnus,
SQLCe isn't supported in the package at the moment unfortunately.
Hi Magnus,
If you see at the forum for this package there are some others that have some issues with installing the package on SQL CE,http://our.umbraco.org/projects/developer-tools/301-url-tracker/version-2
I have tried it myself at tonight and I so get an error. But if you gets an error something like this:
Error running NonQuery:
SQL Statement:
IF EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'icUrlTracker') AND NOT EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'icUrlTracker' AND COLUMN_NAME = 'ForceRedirect')
BEGIN
ALTER TABLE [icUrlTracker] ADD ForceRedirect bit NOT NULL CONSTRAINT DF_icUrlTracker_ForceRedirect DEFAULT 0
END
Exception:
System.Data.SqlServerCe.SqlCeException (0x80004005): There was an error parsing the query. [ Token line number = 1,Token line offset = 1,Token in error = IF ]
at System.Data.SqlServerCe.SqlCeCommand.ProcessResults(Int32 hr)
at System.Data.SqlServerCe.SqlCeCommand.CompileQueryPlan()
at System.Data.SqlServerCe.SqlCeCommand.ExecuteCommand(CommandBehavior behavior, String method, ResultSetOptions options)
at System.Data.SqlServerCe.SqlCeCommand.ExecuteNonQuery()
at SqlCE4Umbraco.SqlCeApplicationBlock.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlCeParameter[] commandParameters)
You could try to run these SQL scripts: https://github.com/kipusoep/UrlTracker/tree/master/SQL
I get another error, but I just set up the test site, for try to helping you out so no worries about it.
Or you could try to do what Dan says in this thread; http://our.umbraco.org/projects/developer-tools/301-url-tracker/version-2/47330-Error-when-installing-with-SQL-CE
I hope this can help you to a solution.
/Dennis
Thanks for quick answers. I will take a look at it and see what I can do.
// Magnus
is working on a reply...