Server Error in '/' Application after installing

We recently attempted to install 301 URL Tracker on an Umbraco 7.14 installation and now get the following error. We can't access the Umbraco admin to remove the package either. Can you please help us either fix the 301 URL installation or remove it so we can get our Umbraco instance functioning again?

Win Server 2008
SQL Server 2008 R2
IIS 7
.NET 4.5

Server Error in '/' Application.

Error running Reader:
SQL Statement:
SELECT * FROM icUrlTracker WHERE Is404 = @is404 AND RedirectHttpCode != @redirectHttpCode AND ForceRedirect = 1

Exception:
System.Data.SqlServerCe.SqlCeException (0x80004005): The column name is not valid. [ Node name (if any) = ,Column name = ForceRedirect ]
  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 SqlCE4Umbraco.SqlCeApplicationBlock.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlCeParameter[] commandParameters)

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: SqlCE4Umbraco.SqlCeProviderException: Error running Reader:
SQL Statement:
SELECT * FROM icUrlTracker WHERE Is404 = @is404 AND RedirectHttpCode != @redirectHttpCode AND ForceRedirect = 1

Exception:
System.Data.SqlServerCe.SqlCeException (0x80004005): The column name is not valid. [ Node name (if any) = ,Column name = ForceRedirect ]
  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 SqlCE4Umbraco.SqlCeApplicationBlock.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlCeParameter[] commandParameters)

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:


[SqlCeProviderException: Error running Reader: 
SQL Statement:
SELECT * FROM icUrlTracker WHERE Is404 = @is404 AND RedirectHttpCode != @redirectHttpCode AND ForceRedirect = 1

Exception:
System.Data.SqlServerCe.SqlCeException (0x80004005): The column name is not valid. [ Node name (if any) = ,Column name = ForceRedirect ]
   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 SqlCE4Umbraco.SqlCeApplicationBlock.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlCeParameter[] commandParameters)]
   SqlCE4Umbraco.SqlCeApplicationBlock.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlCeParameter[] commandParameters) +417
   SqlCE4Umbraco.SqlCEHelper.ExecuteReader(String commandText, SqlCeParameter[] parameters) +26
   umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters) +161

[SqlHelperException: Umbraco Exception (DataLayer): SQL helper exception in ExecuteReader]
   umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters) +361
   InfoCaster.Umbraco.UrlTracker.Repositories.UrlTrackerRepository.GetUrlTrackerEntries(Nullable`1 maximumRows, Nullable`1 startRowIndex, String sortExpression, Boolean _404, Boolean include410Gone, Boolean showAutoEntries, Boolean showCustomEntries, Boolean showRegexEntries, String keyword, Boolean onlyForcedRedirects) in c:\Users\kipusoep\Documents\GitHub\UrlTracker\Repositories\UrlTrackerRepository.cs:202
   InfoCaster.Umbraco.UrlTracker.Repositories.UrlTrackerRepository.ReloadForcedRedirectsCache() in c:\Users\kipusoep\Documents\GitHub\UrlTracker\Repositories\UrlTrackerRepository.cs:532
   InfoCaster.Umbraco.UrlTracker.UrlTrackerApplicationEventHandler.ApplicationStarted(UmbracoApplicationBase umbracoApplication, ApplicationContext applicationContext) in c:\Users\kipusoep\Documents\GitHub\UrlTracker\UrlTrackerApplicationEventHandler.cs:46
   Umbraco.Core.EnumerableExtensions.ForEach(IEnumerable`1 items, Action`1 action) +148
   Umbraco.Core.CoreBootManager.Complete(Action`1 afterComplete) +116
   Umbraco.Web.WebBootManager.Complete(Action`1 afterComplete) +49
   Umbraco.Core.UmbracoApplicationBase.StartApplication(Object sender, EventArgs e) +243

[HttpException (0x80004005): Umbraco Exception (DataLayer): SQL helper exception in ExecuteReader]
   System.Web.HttpApplicationFactory.EnsureAppStartCalledForIntegratedMode(HttpContext context, HttpApplication app) +12949749
   System.Web.HttpApplication.RegisterEventSubscriptionsWithIIS(IntPtr appContext, HttpContext context, MethodInfo[] handlers) +175
   System.Web.HttpApplication.InitSpecial(HttpApplicationState state, MethodInfo[] handlers, IntPtr appContext, HttpContext context) +304
   System.Web.HttpApplicationFactory.GetSpecialApplicationInstance(IntPtr appContext, HttpContext context) +404
   System.Web.Hosting.PipelineRuntime.InitializeApplication(IntPtr appContext) +475

[HttpException (0x80004005): Umbraco Exception (DataLayer): SQL helper exception in ExecuteReader]
   System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +12966756
   System.Web.HttpRuntime.EnsureFirstRequestInit(HttpContext context) +159
   System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context) +12806561

Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.18408

Copy Link

Stefan Kip 1606 posts 4098 karma points c-trib

Sep 08, 2014 @ 08:24

You're using SQL CE, which isn't supported yet.
There is a PR on Github, but I haven't had the time to look into it yet.

Copy Link

Greg Mattison 40 posts 60 karma points

Sep 08, 2014 @ 15:50

Thanks, how can I removed the package entirely to get back to our functioning Umbraco instance?

Copy Link

Mike 6 posts 52 karma points

Nov 06, 2014 @ 23:44

This happened to me as well. Greg, how did you resolve?

Copy Link

is working on a reply...

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.

Flag this post as spam?

Server Error in '/' Application after installing

Server Error in '/' Application.