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 1250 posts 3747 karma points admin c-trib
    Jan 30, 2014 @ 23:31
    Dan
    0

    Hi Magnus,

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

  • Dennis Aaen 4457 posts 17970 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

  • 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.

Please Sign in or register to post replies