Copied to clipboard

Flag this post as spam?

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


  • Paul Kiselis 8 posts 78 karma points
    Jun 28, 2016 @ 14:04
    Paul Kiselis
    0

    Database error when manualy upgrading from umbraco V6 to V7

    I have been fallowing instuctions that are listed bellow: https://our.umbraco.org/documentation/Getting-Started/Setup/Upgrading/upgrading-to-v7

    My upgrade steps where:

    1. I upgraded my project to .NET 4.5.2
    2. I rebuilded XML Catche.
    3. I merged all .Config files.
    4. I copied all the bin, Umbraco, Umbraco_Client from the Upgrade.zip to my project

    After step 4, I recieved a database error listed bellow.

    At the moment I'm stuck. Any help would be appreciated.

    Invalid column name 'uniqueID'.
    Invalid column name 'propertyEditorAlias'.
    Invalid column name 'uniqueID'.
    Invalid column name 'uniqueID'.
    Invalid column name 'propertyEditorAlias'.
    Invalid column name 'uniqueID'.
    
    
    Exception Details: System.Data.SqlClient.SqlException: Invalid column name 'uniqueID'.
    Invalid column name 'propertyEditorAlias'.
    Invalid column name 'uniqueID'.
    Invalid column name 'uniqueID'.
    Invalid column name 'propertyEditorAlias'.
    Invalid column name 'uniqueID'.
    

    [SqlException (0x80131904): Invalid column name 'uniqueID'. Invalid column name 'propertyEditorAlias'. Invalid column name 'uniqueID'. Invalid column name 'uniqueID'. Invalid column name 'propertyEditorAlias'. Invalid column name 'uniqueID'.] System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +3278564

    System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +791
       System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +4927
       System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() +92
       System.Data.SqlClient.SqlDataReader.get_MetaData() +102
       System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +552
       System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds, Boolean describeParameterEncryptionRequest) +3114
       System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) +554
       System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +98
       System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +307
       Umbraco.Core.Persistence.<>c__DisplayClass4.<ExecuteReaderWithRetry>b__3() +175
       Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction(Func`1 func) +385
       Umbraco.Core.Persistence.<Query>d__7`1.MoveNext() +815
       System.Collections.Generic.List`1..ctor(IEnumerable`1 collection) +452
       System.Linq.Enumerable.ToList(IEnumerable`1 source) +70
       Umbraco.Core.Persistence.Repositories.ContentTypeQueryMapper.MapGroupsAndProperties(Int32[] contentTypeIds, Database db, ISqlSyntaxProvider sqlSyntax, IDictionary`2& allPropertyTypeCollection, IDictionary`2& allPropertyGroupCollection) +963
       Umbraco.Core.Persistence.Repositories.ContentTypeQueryMapper.MapContentTypeChildren(IContentTypeComposition[] contentTypes, Database db, ISqlSyntaxProvider sqlSyntax, TRepo contentTypeRepository, IDictionary`2 allParentContentTypeIds) +284
       Umbraco.Core.Persistence.Repositories.ContentTypeQueryMapper.GetContentTypes(Database db, ISqlSyntaxProvider sqlSyntax, TRepo contentTypeRepository, ITemplateRepository templateRepository) +278
       Umbraco.Core.Persistence.Repositories.ContentTypeRepository.PerformGetAll(Int32[] ids) +285
       Umbraco.Core.Cache.FullDataSetRepositoryCachePolicy`2.PerformGetAll(Func`2 getFromRepo) +187
       Umbraco.Core.Cache.FullDataSetRepositoryCachePolicy`2.GetAll(TId[] ids, Func`2 getFromRepo) +110
       Umbraco.Core.Persistence.Repositories.RepositoryBase`2.GetAll(TId[] ids) +298
       Umbraco.Core.Services.ContentTypeService.GetAllContentTypes(Int32[] ids) +91
       Umbraco.Core.Services.ContentTypeService.ValidateLocked(IContentTypeComposition compositionContentType) +188
       Umbraco.Core.Services.ContentTypeService.Save(IContentType contentType, Int32 userId) +300
       umbraco.cms.businesslogic.web.DocumentType.MakeNew(User u, String Text) +293
       Vega.USiteBuilder.DocumentTypeManager.SynchronizeDocumentType(Type typeDocType, Type baseTypeDocType) +215
       Vega.USiteBuilder.DocumentTypeManager.SynchronizeDocumentTypes(Type baseTypeDocType) +116
       Vega.USiteBuilder.DocumentTypeManager.Synchronize() +75
       Vega.USiteBuilder.UmbracoManager.Synchronize() +162
       Vega.USiteBuilder.UmbracoManager.SynchronizeIfNotSynchronized() +120
       Vega.USiteBuilder.uSiteBuilderEventHandler.OnApplicationStarted(UmbracoApplicationBase umbracoApplication, ApplicationContext applicationContext) +18
       Umbraco.Core.CoreBootManager.<Complete>b__a(IApplicationEventHandler x) +434
       Umbraco.Core.EnumerableExtensions.ForEach(IEnumerable`1 items, Action`1 action) +167
       Umbraco.Core.CoreBootManager.Complete(Action`1 afterComplete) +467
       Umbraco.Web.WebBootManager.Complete(Action`1 afterComplete) +167
       Umbraco.Core.UmbracoApplicationBase.StartApplication(Object sender, EventArgs e) +364
    
    [HttpException (0x80004005): Invalid column name 'uniqueID'.
    Invalid column name 'propertyEditorAlias'.
    Invalid column name 'uniqueID'.
    Invalid column name 'uniqueID'.
    Invalid column name 'propertyEditorAlias'.
    Invalid column name 'uniqueID'.]
       System.Web.HttpApplicationFactory.EnsureAppStartCalledForIntegratedMode(HttpContext context, HttpApplication app) +544
       System.Web.HttpApplication.RegisterEventSubscriptionsWithIIS(IntPtr appContext, HttpContext context, MethodInfo[] handlers) +186
       System.Web.HttpApplication.InitSpecial(HttpApplicationState state, MethodInfo[] handlers, IntPtr appContext, HttpContext context) +172
       System.Web.HttpApplicationFactory.GetSpecialApplicationInstance(IntPtr appContext, HttpContext context) +402
       System.Web.Hosting.PipelineRuntime.InitializeApplication(IntPtr appContext) +343
    
    [HttpException (0x80004005): Invalid column name 'uniqueID'.
    Invalid column name 'propertyEditorAlias'.
    Invalid column name 'uniqueID'.
    Invalid column name 'uniqueID'.
    Invalid column name 'propertyEditorAlias'.
    Invalid column name 'uniqueID'.]
       System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +579
       System.Web.HttpRuntime.EnsureFirstRequestInit(HttpContext context) +112
       System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context) +716
    
Please Sign in or register to post replies

Write your reply to:

Draft