Copied to clipboard

Flag this post as spam?

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


  • Arjan Woldring 122 posts 229 karma points
    Jan 17, 2014 @ 16:19
    Arjan Woldring
    0

    Umbraco 7 and SQL CE not working

    Hey Stefan,

    Thanks for releasing this package for Umbraco 7! Awesome!

    Unfortunately this package won't install in U7 with Sql ce database. It keeps hanging on 'installing dashboard'. When clicking away the whole umbraco installation isn't working anymore. In the front and backend I have this error. Thanks in advance!

    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)

  • Stefan Kip 1606 posts 4098 karma points c-trib
    Jan 17, 2014 @ 16:51
  • Arjan Woldring 122 posts 229 karma points
    Jan 17, 2014 @ 17:08
    Arjan Woldring
    0

    Thanks for your quick reply. Do you have any idea how and when to fix it?

  • Stefan Kip 1606 posts 4098 karma points c-trib
    Jan 17, 2014 @ 17:14
    Stefan Kip
    0

    No and no...

  • 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