Sign in Register
Copied to clipboard

Flag this post as spam?

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


  • Wesley Herpoelaert 52 posts 123 karma points
    Jan 08, 2014 @ 17:51
    Wesley Herpoelaert
    0

    Error when installing with SQL CE

    Hello,

    Thanks for the package, I use it in all my websites build with Umbraco.

    But when I install the latest version of this package in Umbraco 6.1.6 with SQL CE, I receive the following error message.

    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)

     

    It appears that SQL CE does not support any procedural extensions at all...

    Thanks,

    Wesley Herpoelaert

    Copy Link
  • Stefan Kip 1606 posts 4098 karma points c-trib
    Jan 08, 2014 @ 22:17
    Stefan Kip
    0

    Hmmm that's nasty...
    Need to have a good look at this, so can't promise anything.

    Copy Link
  • Dan 1250 posts 3747 karma points admin c-trib
    Jan 26, 2014 @ 13:29
    Dan
    0

    Hi Stefan,

    Would you have any pointers as to how to tidy up after encountering this issue, just to make the back office work again? (e.g. DLLs to be removed, config settings to revert etc?)

    Umbraco 7.0.2, urlTracker 2.5.1, sqlCe.

    Thanks

    Copy Link
  • Dan 1250 posts 3747 karma points admin c-trib
    Jan 26, 2014 @ 13:33
    Dan
    0

    Scrap that comment, I removed the DLL and that seems to have sorted it (unless you know of anything else that might cause trouble and should be removed?)

    Copy Link
  • Stefan Kip 1606 posts 4098 karma points c-trib
    Jan 27, 2014 @ 08:58
    Stefan Kip
    0

    Removing the DLL is fixes this issue indeed. Or you could create the icUrlTracker table manually.

    Copy Link
  • Anton Oosthuizen 192 posts 470 karma points
    Aug 11, 2014 @ 11:40
    Anton Oosthuizen
    0

    Have you found a solution to this problem?

    Copy Link
  • Stefan Kip 1606 posts 4098 karma points c-trib
    Aug 12, 2014 @ 10:03
    Stefan Kip
    0

    There is a new PR which should add compatibility with SQL CE, but I still need to review it, accept it and release a new version.

    Copy Link
  • Anders Schmidt 74 posts 205 karma points
    Sep 14, 2014 @ 21:06
    Anders Schmidt
    0

    Hi,

    I am stucked after trying to install package on sql ce. Any fix/sugestion.

    Thanks.

    Copy Link
  • Stefan Kip 1606 posts 4098 karma points c-trib
    Sep 14, 2014 @ 21:08
    Stefan Kip
    0

    Here's a suggestion; read the posts above?!

    Copy Link
  • Anders Schmidt 74 posts 205 karma points
    Sep 14, 2014 @ 21:26
    Anders Schmidt
    0

    Thanks for quick reply. I have been looking at git. But do not quite understand what to do...

    Thanks

    Copy Link

  • 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