Copied to clipboard

Flag this post as spam?

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


  • Magnus Engzell 3 posts 23 karma points
    Jan 30, 2014 @ 21:32
    Magnus Engzell
    0

    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

  • Dan 1288 posts 3921 karma points c-trib
    Jan 30, 2014 @ 23:31
    Dan
    0

    Hi Magnus,

    SQLCe isn't supported in the package at the moment unfortunately.

  • Dennis Aaen 4500 posts 18255 karma points admin hq c-trib
    Jan 30, 2014 @ 23:48
    Dennis Aaen
    1

    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

  • Magnus Engzell 3 posts 23 karma points
    Jan 31, 2014 @ 08:47
    Magnus Engzell
    0

    Thanks for quick answers. I will take a look at it and see what I can do.

    // Magnus

Please Sign in or register to post replies

Write your reply to:

Draft