Copied to clipboard

Flag this post as spam?

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


  • Chris Van Oort 93 posts 351 karma points
    Sep 26, 2014 @ 03:27
    Chris Van Oort
    0

    Issue updating from 2.2.3.0 to 3.0.1

    Any ideas / help for what's happening here?

    SQL Server 2008 r2 Umbraco 7.1.6

    I currently am working on an upgrade from Umbraco 6.1.x to 7.1.6 -- and it's complete minus this plugin. Upon trying to upgrade from 301 URL Tracker version 2.2.3.0 to 3.0.1 I receive this error:

    Server Error in '/' Application.

    Invalid column name 'ForceRedirect'.

    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: System.Data.SqlClient.SqlException: Invalid column name 'ForceRedirect'.

    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:

    [SqlException (0x80131904): Invalid column name 'ForceRedirect'.] System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) +1787814 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) +5341674 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +546 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +1693 System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() +61 System.Data.SqlClient.SqlDataReader.get_MetaData() +90 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +377 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) +1421 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource1 completion, Int32 timeout, Task& task, Boolean asyncWrite) +177 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +53 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +137 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) +81 Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) +146 umbraco.DataLayer.SqlHelpers.SqlServer.SqlServerHelper.ExecuteReader(String commandText, SqlParameter[] parameters) +37 umbraco.DataLayer.SqlHelper1.ExecuteReader(String commandText, IParameter[] parameters) +81

    [SqlHelperException: Umbraco Exception (DataLayer): SQL helper exception in ExecuteReader] umbraco.DataLayer.SqlHelper1.ExecuteReader(String commandText, IParameter[] parameters) +201 InfoCaster.Umbraco.UrlTracker.Repositories.UrlTrackerRepository.GetUrlTrackerEntries(Nullable1 maximumRows, Nullable1 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:200 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:44 Umbraco.Core.ApplicationEventHandler.OnApplicationStarted(UmbracoApplicationBase umbracoApplication, ApplicationContext applicationContext) +37 Umbraco.Core.CoreBootManager.<Complete>b__5(IApplicationEventHandler x) +19 Umbraco.Core.EnumerableExtensions.ForEach(IEnumerable1 items, Action1 action) +141 Umbraco.Core.CoreBootManager.Complete(Action1 afterComplete) +94 Umbraco.Web.WebBootManager.Complete(Action`1 afterComplete) +38 Umbraco.Core.UmbracoApplicationBase.StartApplication(Object sender, EventArgs e) +158 Umbraco.Core.UmbracoApplicationBase.Application_Start(Object sender, EventArgs e) +9

    [HttpException (0x80004005): Umbraco Exception (DataLayer): SQL helper exception in ExecuteReader] System.Web.HttpApplicationFactory.EnsureAppStartCalledForIntegratedMode(HttpContext context, HttpApplication app) +9916673 System.Web.HttpApplication.RegisterEventSubscriptionsWithIIS(IntPtr appContext, HttpContext context, MethodInfo[] handlers) +118 System.Web.HttpApplication.InitSpecial(HttpApplicationState state, MethodInfo[] handlers, IntPtr appContext, HttpContext context) +172 System.Web.HttpApplicationFactory.GetSpecialApplicationInstance(IntPtr appContext, HttpContext context) +336 System.Web.Hosting.PipelineRuntime.InitializeApplication(IntPtr appContext) +296

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

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

  • Chris Van Oort 93 posts 351 karma points
    Sep 26, 2014 @ 03:33
    Chris Van Oort
    100

    If anyone comes upon this, I've solved the issue.

    Not sure why this was happening -- but what I did to solve the issue was to do an intermediate upgrade step.

    1. Download this: http://our.umbraco.org/FileDownload?id=12095

    2. Install that 2.6.2 version of the package.

    3. After that's done (it should work to upgrade to 2.6.2) -- I upgraded to 3.0.1 with no issues.

    Thanks!

  • Simon Dingley 1431 posts 3332 karma points c-trib
    Apr 25, 2018 @ 11:35
    Simon Dingley
    1

    Script here to add the missing column & constraint:

    https://github.com/kipusoep/UrlTracker/blob/master/SQL/MicrosoftSqlServer/update-table-1.sql

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