Copied to clipboard

Flag this post as spam?

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


  • Damon 217 posts 288 karma points
    Jul 18, 2018 @ 10:48
    Damon
    0

    Error upgrading from 7.2.2 to 7.6

    Hi,

    After running this upgrade getting this error:

    Invalid column name 'typeUniqueId'.

    Does anyone know what is causing this?

    Thanks a lot for any information?

    Here is the log:

    The following columns were found in the database, but are not in the current schema: ContourTest,RecordID,ContourTest,FieldCode,ContourTest,Value,ContourTest,Field,umbracoUserLogins,contextID,umbracoUserLogins,userID,umbracoUserLogins,timeout,UFUserSecurity,User,UFUserSecurity,ManageDataSources,UFUserSecurity,ManagePreValueSources,UFUserSecurity,ManageWorkflows,UFUserSecurity,ManageForms,UFWorkflowsToForms,Workflow,UFWorkflowsToForms,Form,UFSettings,Id,UFSettings,Key,UFSettings,Value,cmsStylesheetProperty,nodeId,cmsStylesheetProperty,stylesheetPropertyEditor,cmsStylesheetProperty,stylesheetPropertyAlias,cmsStylesheetProperty,stylesheetPropertyValue,CarerFeedback,RecordId,CarerFeedback,Recommend,CarerFeedback,Response,CarerFeedback,Comments,CarerFeedback,1Carer,CarerFeedback,2Time,CarerFeedback,3Relationship,CarerFeedback,4Part,CarerFeedback,5Accomodation,CarerFeedback,6Supported,CarerFeedback,7SupportWhere,CarerFeedback,8SupportReceive,CarerFeedback,9SupportNeeds,CarerFeedback,10Opportunity,CarerFeedback,11Contact,CarerFeedback,12ContactDetails,CarerFeedback,13Appropriate,CarerFeedback,14InformationAccess,CarerFeedback,15InformationServices,CarerFeedback,16Dignity,CarerFeedback,17Introduce,CarerFeedback,18Discuss,CarerFeedback,19Listened,CarerFeedback,20Assessment,CarerFeedback,21Decisions,CarerFeedback,22CarePlan,CarerFeedback,23Knowledge,CarerFeedback,24ServiceUsers,CarerFeedback,25Usage,CarerFeedback,1Age,CarerFeedback,2Gender,CarerFeedback,3Sexual,CarerFeedback,4Religion,CarerFeedback,5Ethnicity,CarerFeedback,6Marital,CarerFeedback,7Disability,CarerFeedback,SurveyDate,UFDataSources,Id,UFDataSources,Type,UFDataSources,Name,UFPrevalueSources,Id,UFPrevalueSources,Name,UFPrevalueSources,Type,UFFormStates,State,UFForms,Id,UFForms,Name,UFForms,Created,UFForms,ManualApproval,UFForms,GotoPageOnSubmit,UFForms,MessageOnSubmit,UFForms,DataSource,UFForms,ShowValidationSummary,UFForms,HideFieldValidation,UFForms,RequiredErrorMessage,UFForms,InvalidErrorMessage,UFForms,FieldIndicationType,UFForms,Indicator,UFForms,Archived,UFForms,StoreRecordsLocally,UFForms,DisableDefaultStylesheet,UFForms,Entries,UFForms,Views,UFPrevalueSourceSettings,PrevalueProvider,UFPrevalueSourceSettings,Key,UFPrevalueSourceSettings,Value,cmsTemplate,master,cmsStylesheet,nodeId,cmsStylesheet,filename,cmsStylesheet,content,UFWorkflowExecutionStates,Workflow,UFWorkflowExecutionStates,State,UFWorkflowExecutionStates,Form,UFWorkflows,Id,UFWorkflows,Name,UFWorkflows,Type,UFWorkflows,SortOrder,UFWorkflows,Active,UFWorkflows,Form,UFWorkflows,ExecutesOn,UFUserFormSecurity,User,UFUserFormSecurity,Form,UFUserFormSecurity,HasAccess,UFUserFormSecurity,SecurityType,UFUserFormSecurity,AllowInEditor,UFRecordsXml,id,UFRecordsXml,Form,UFRecordsXml,xml,UFRecordsXml,created,UFRecordsXml,Page,UFRecords,Id,UFRecords,Form,UFRecords,Created,UFRecords,Updated,UFRecords,State,UFRecords,currentPage,UFRecords,umbracoPageId,UFRecords,IP,UFRecords,MemberKey,cmsPropertyTypeGroup,parentGroupId,UFPages,Id,UFPages,Form,UFPages,SortOrder,UFPages,Caption,UFDataSourceMappings,DataSource,UFDataSourceMappings,DataSourceField,UFDataSourceMappings,Form,UFDataSourceMappings,PrevalueTable,UFDataSourceMappings,PrevalueKeyField,UFDataSourceMappings,PrevalueValueField,UFDataSourceMappings,DataType,UFDataSourceMappings,DefaultValue,UFFieldsets,Id,UFFieldsets,Page,UFFieldsets,SortOrder,UFFieldsets,Caption,cmsContentVersion,LanguageLocale,cmsPropertyType,helpText,UFFields,Id,UFFields,Fieldset,UFFields,Fieldtype,UFFields,PreValueProvider,UFFields,RegEx,UFFields,Mandatory,UFFields,SortOrder,UFFields,Caption,UFFields,DataSourceField,UFFields,ToolTip,UFFields,DefaultValue,UFFields,RequiredErrorMessage,UFFields,InvalidErrorMessage,UFPrevalues,Id,UFPrevalues,Field,UFPrevalues,Value,UFPrevalues,SortOrder,UFFieldSettings,Field,UFFieldSettings,Key,UFFieldSettings,Value,UFFieldConditions,Id,UFFieldConditions,Field,UFFieldConditions,Enabled,UFFieldConditions,ActionType,UFFieldConditions,LogicType,UFRecordFields,Key,UFRecordFields,Field,UFRecordFields,Record,UFRecordFields,DataType,UFRecordDataString,Id,UFRecordDataString,Key,UFRecordDataString,Value,UFRecordDataLongString,Id,UFRecordDataLongString,Key,UFRecordDataLongString,Value,UFRecordDataInteger,Id,UFRecordDataInteger,Key,UFRecordDataInteger,Value,UFRecordDataDateTime,Id,UFRecordDataDateTime,Key,UFRecordDataDateTime,Value,UFRecordDataBit,Id,UFRecordDataBit,Key,UFRecordDataBit,Value,UploadedDocuments,id,UploadedDocuments,Title,UploadedDocuments,Path,UploadedDocuments,Category,UploadedDocuments,IsVisible,UploadedDocuments,Timestamp,UFFieldConditionRules,Id,UFFieldConditionRules,FieldCondition,UFFieldConditionRules,Field,UFFieldConditionRules,Operator,UFFieldConditionRules,Value,cmsMacro,uniqueId,cmsMacroProperty,uniquePropertyId,cmsPropertyTypeGroup,uniqueID,cmsPropertyType,UniqueID,cmsPropertyData,dataDecimal,umbracoRelationType,typeUniqueId,umbracoUser,securityStampToken,umbracoUser,failedLoginAttempts,umbracoUser,lastLockoutDate,umbracoUser,lastPasswordChangeDate,umbracoUser,lastLoginDate,umbracoServer,isMaster,umbracoAccess,id,umbracoAccess,nodeId,umbracoAccess,loginNodeId,umbracoAccess,noAccessNodeId,umbracoAccess,createDate,umbracoAccess,updateDate,umbracoAccessRule,id,umbracoAccessRule,accessId,umbracoAccessRule,ruleValue,umbracoAccessRule,ruleType,umbracoAccessRule,createDate,umbracoAccessRule,updateDate,umbracoCacheInstruction,id,umbracoCacheInstruction,utcStamp,umbracoCacheInstruction,jsonInstruction,umbracoCacheInstruction,originated,umbracoExternalLogin,id,umbracoExternalLogin,userId,umbracoExternalLogin,loginProvider,umbracoExternalLogin,providerKey,umbracoExternalLogin,createDate,umbracoMigration,id,umbracoMigration,name,umbracoMigration,createDate,umbracoMigration,version,umbracoRedirectUrl,id,umbracoRedirectUrl,contentKey,umbracoRedirectUrl,createDateUtc,umbracoRedirectUrl,url,umbracoRedirectUrl,urlHash,umbracoLock,id,umbracoLock,value,umbracoLock,name

    The following constraints (Primary Keys, Foreign Keys and Indexes) were found in the database, but are not in the current schema: FKcmsPropertyTypeGroupcmsPropertyTypeGroupid,FKcmsStylesheetumbracoNodeid,FKcmsTemplatecmsTemplate,FKUFDataSourceMappingsUFDataSources,FKUFDataSourceMappingsUFForms,FKUFFieldUFFieldsets,FKUFFieldConditionRulesUFFieldConditions,FKUFFieldConditionRulesUFFields,FKUFFieldConditionsUFFields,FKUFFieldsetsUFPages,FKUFFieldSettingsUFFields,FKUFFormsUFDataSources,FKUFPagesUFForms,FKUFPrevaluesUFFields,FKUFPrevalueSettingsUFPrevalueProviders,FKUFRecordDataBitUFRecordFields,FKUFRecordDataDateTimeUFRecordFields,FKUFRecordDataIntegerUFRecordFields,FKUFRecordDataLongStringUFRecordFields,FKUFRecordDataStringUFRecordFields,FKUFRecordFieldsUFFields,FKUFRecordFieldsUFRecords,FKUFRecordsUFForms,FKUFRecordsXmlUFForms,FKUFUserFormSecurityUFForms,FKUFWorkflowExecutionStatesUFFormStates,FKUFWorkflowsUFForms,FKcmsDictionarycmsDictionaryid,FKcmsLanguageTextumbracoLanguageid,FKumbracoAccessumbracoNodeid,FKumbracoAccessumbracoNodeid1,FKumbracoAccessumbracoNodeid2,FKumbracoAccessRuleumbracoAccessid,FKumbracoRedirectUrlumbracoNodeuniqueID,PKCarerFeedback,PKcmsStylesheet,PKcmsStylesheetProperty,PKUFDataSourceMappings,PKUFDataSources,PKUFField,PKUFFieldConditionRules,PKUFFieldConditions,PKUFFieldsets,PKUFForms,PKUFFormStates,PKUFPages,PKUFPrevalueProviders,PKUFPrevalues,PKUFPrevalueSettings,PKUFRecordDataBit,PKUFRecordDataDateTime,PKUFRecordDataInteger,PKUFRecordDataLongString,PKUFRecordDataString,PKUFRecordFields,PKUFRecords,PKUFRecordsXml,PKUFSettings,PKUFUserFormSecurity,PKUFUserSecurity,PKUFWorkflowExecutionStates,PKUFWorkflows,PKUFWorkflowsToForms,PKUploadedDocuments,PKumbracoAccess,PKumbracoAccessRule,PKumbracoCacheInstruction,PKumbracoExternalLogin,PKumbracoMigration,PKumbracoRedirectUrl,PKumbracoLock,IXumbracoNodeTrashed,IXumbracoNodeParentId,IXumbracoNodePath,IXumbracoNodeUniqueID,IXumbracoNodeObjectType,IXcmsContentType,IXcmsContentTypeicon,IXcmsTemplatenodeId,IXcmsContent,IXcmsContentVersionContentId,IXcmsContentVersionVersionId,IXcmsDocument,IXcmsDocumentpublished,IXcmsDocumentnewest,IXcmsDataTypenodeId,IXcmsDictionaryid,IXumbracoLanguagelanguageISOCode,IXumbracoLog,IXcmsMacroUniqueId,IXcmsMacroPropertyAlias,IXcmsMacroPropertyUniquePropertyId,IXcmsMacroPropertyAlias,IXcmsMemberLoginName,IXcmsPropertyTypeGroupUniqueID,IXcmsPropertyTypeUniqueID,IXcmsPropertyData1,IXcmsPropertyData2,IXcmsPropertyData3,IXumbracoRelationTypeUniqueId,IXumbracoRelationTypename,IXumbracoRelationTypealias,IXumbracoRelationparentChildType,IXcmsTags,IXumbracoUseruserLogin,IXcmsTaskTypealias,IXumbracoUser2NodePermissionnodeId,IXcomputerName,IXumbracoServerisActive,IXumbracoAccessnodeId,IXumbracoAccessRule,IXumbracoMigration,IXumbracoRedirectUrl

    The following indexes were found in the database, but are not in the current schema: IXcmsPropertyData,IXumbracoUserLoginsIndex,IXumbracoNodePath,IXcmsMacroUniqueId,IXcmsMacroPropertyUniquePropertyId,IXcmsMemberLoginName,IXcmsPropertyTypeGroupUniqueID,IXcmsPropertyTypeUniqueID,IXumbracoRelationTypeUniqueId,IXumbracoRelationTypename,IXumbracoRelationTypealias,IXumbracoRelationparentChildType,IXumbracoUser2NodePermissionnodeId,IXumbracoAccessnodeId,IXumbracoAccessRule,IXumbracoMigration,IX_umbracoRedirectUrl

    2018-07-18 11:45:25,902 [P8412/D12/T66] ERROR Umbraco.Web.Install.Controllers.InstallApiController - Installation step DatabaseUpgrade failed. System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> Umbraco.Web.Install.InstallException: The database failed to upgrade. ERROR: The database configuration failed with the following message: Invalid column name 'typeUniqueId'. Please check log file for additional information (can be found in '/AppData/Logs/UmbracoTraceLog.txt') at Umbraco.Web.Install.InstallSteps.DatabaseUpgradeStep.Execute(Object model) --- End of inner exception stack trace --- at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor) at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) at Umbraco.Web.Install.Controllers.InstallApiController.ExecuteStep(InstallSetupStep step, JToken instruction) 2018-07-18 11:45:25,903 [P8412/D12/T66] INFO Umbraco.Web.Install.Controllers.InstallApiController - Step completed (took 224ms) 2018-07-18 11:45:25,903 [P8412/D12/T66] ERROR Umbraco.Web.Install.Controllers.InstallApiController - An error occurred during installation step DatabaseUpgrade System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> Umbraco.Web.Install.InstallException: The database failed to upgrade. ERROR: The database configuration failed with the following message: Invalid column name 'typeUniqueId'. Please check log file for additional information (can be found in '/AppData/Logs/UmbracoTraceLog.txt') at Umbraco.Web.Install.InstallSteps.DatabaseUpgradeStep.Execute(Object model) --- End of inner exception stack trace --- at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor) at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) at Umbraco.Web.Install.Controllers.InstallApiController.ExecuteStep(InstallSetupStep step, JToken instruction) at Umbraco.Web.Install.Controllers.InstallApiController.PostPerformInstall(InstallInstructions installModel)

  • Sérgio 30 posts 171 karma points
    Jul 18, 2018 @ 22:39
    Sérgio
    0

    I would recommend you to do partial updates. 7.2.x -> 7.3.x and so on.

  • 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