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.
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
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, Action
1 wrapCloseInAction) +1787814 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action
1 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.SqlHelper
1.ExecuteReader(String commandText, IParameter[] parameters) +81[SqlHelperException: Umbraco Exception (DataLayer): SQL helper exception in ExecuteReader] umbraco.DataLayer.SqlHelper
1.ExecuteReader(String commandText, IParameter[] parameters) +201 InfoCaster.Umbraco.UrlTracker.Repositories.UrlTrackerRepository.GetUrlTrackerEntries(Nullable
1 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(IEnumerable
1 items, Action1 action) +141 Umbraco.Core.CoreBootManager.Complete(Action
1 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
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.
Download this: http://our.umbraco.org/FileDownload?id=12095
Install that 2.6.2 version of the package.
After that's done (it should work to upgrade to 2.6.2) -- I upgraded to 3.0.1 with no issues.
Thanks!
Script here to add the missing column & constraint:
https://github.com/kipusoep/UrlTracker/blob/master/SQL/MicrosoftSqlServer/update-table-1.sql
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.