You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Describe the bug
I am trying to upgrade an Umbraco 10 project to Umbraco 13, which includes Umbraco.Commerce. I have been able to upgrade the solution and packages and the solution builds, but the migration fails, with a Database configuration failed error. By turning off unattendedUpgrade I have been able to get more detailed logs.
Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid column name 'defaultLocationId'.
Invalid column name 'measurementSystem'.
at Umbraco.Commerce.Infrastructure.Resiliency.PollyExecutionStrategyBase.Execute[TResult](Func`1 operation, Func`1 verifySucceeded)
at Umbraco.Commerce.Core.UmbracoCommerceUnitOfWorkProvider.Execute[T](IUnitOfWorkOptions options, Func`2 action)
at Umbraco.Commerce.Core.UmbracoCommerceUnitOfWorkProvider.Execute[T](Boolean autoComplete, Func`2 action)
at Umbraco.Commerce.Core.Services.StoreService.PerformGetAllStates(Guid[] ids)
at Umbraco.Commerce.Core.Cache.FullDataSetEntityStatePolicyCache`2.DoGetAll(Func`2 performGetAll)
at Umbraco.Commerce.Core.Cache.FullDataSetEntityStatePolicyCache`2.Get(TId id, Func`2 performGet, Func`2 performGetAll)
at Umbraco.Commerce.Core.Services.StoreService.GetStoreState(Guid id)
at Umbraco.Commerce.Core.Services.StoreService.GetStore(Guid id)
at Umbraco.Commerce.Cms.ValueConverters.StorePickerValueConverter.ConvertIntermediateToObject(IPublishedElement owner, IPublishedPropertyType propertyType, PropertyCacheLevel cacheLevel, Object source, Boolean preview)
at Umbraco.Cms.Core.Models.PublishedContent.PublishedPropertyType.ConvertInterToObject(IPublishedElement owner, PropertyCacheLevel referenceCacheLevel, Object inter, Boolean preview)
at Umbraco.Cms.Infrastructure.PublishedCache.Property.GetValue(String culture, String segment)
at Umbraco.Extensions.PublishedPropertyExtension.Value[T](IPublishedProperty property, IPublishedValueFallback publishedValueFallback, String culture, String segment, Fallback fallback, T defaultValue)
at Umbraco.Cms.Core.Models.PublishedContent.PublishedValueFallback.TryGetValueWithAncestorsFallback[T](IPublishedContent content, String alias, String culture, String segment, T& value, IPublishedProperty& noValueProperty)
at Umbraco.Cms.Core.Models.PublishedContent.PublishedValueFallback.TryGetValue[T](IPublishedContent content, String alias, String culture, String segment, Fallback fallback, T defaultValue, T& value, IPublishedProperty& noValueProperty)
at Umbraco.Extensions.PublishedContentExtensions.Value[T](IPublishedContent content, IPublishedValueFallback publishedValueFallback, String alias, String culture, String segment, Fallback fallback, T defaultValue)
at Umbraco.Extensions.FriendlyPublishedContentExtensions.Value[T](IPublishedContent content, String alias, String culture, String segment, Fallback fallback, T defaultValue)
at Umbraco.Commerce.Checkout.Events.SyncZeroValuePaymentProviderContinueUrl.DoSyncZeroValuePaymentProviderContinueUrl(IPublishedContent confirmationNode)
at Umbraco.Commerce.Checkout.Events.SyncZeroValuePaymentProviderContinueUrl.Handle(Object messageObject, MessageType messageType)
at Umbraco.Commerce.Checkout.Events.SyncZeroValuePaymentProviderContinueUrl.Handle(ContentCacheRefresherNotification notification)
at Umbraco.Cms.Core.Events.INotificationHandler`1.Handle(IEnumerable`1 notifications)
at Umbraco.Cms.Core.Events.NotificationHandlerWrapperImpl`1.<>c__DisplayClass0_0`2.<Handle>b__2(IEnumerable`1 handlerNotifications)
at Umbraco.Cms.Core.Events.EventAggregator.PublishCore[TNotification](IEnumerable`1 allHandlers, IEnumerable`1 notifications)
at Umbraco.Cms.Core.Events.NotificationHandlerWrapperImpl`1.Handle[TNotification,TNotificationHandler](IEnumerable`1 notifications, ServiceFactory serviceFactory, Action`2 publish)
at Umbraco.Cms.Core.Events.EventAggregator.PublishNotifications[TNotification,TNotificationHandler](IEnumerable`1 notifications)
at Umbraco.Cms.Core.Events.EventAggregator.Publish[TNotification,TNotificationHandler](IEnumerable`1 notifications)
at Umbraco.Cms.Core.Events.EventAggregator.Publish[TNotification](TNotification notification)
at Umbraco.Cms.Core.Cache.CacheRefresherBase`1.OnCacheUpdated(CacheRefresherNotification notification)
at Umbraco.Cms.Core.Cache.PayloadCacheRefresherBase`2.Refresh(TPayload[] payloads)
at Umbraco.Cms.Core.Cache.ContentCacheRefresher.Refresh(JsonPayload[] payloads)
at Umbraco.Cms.Infrastructure.Sync.ServerMessengerBase.DeliverLocal[TPayload](ICacheRefresher refresher, TPayload[] payload)
at Umbraco.Cms.Infrastructure.Sync.ServerMessengerBase.Deliver[TPayload](ICacheRefresher refresher, TPayload[] payload)
at Umbraco.Cms.Infrastructure.Sync.ServerMessengerBase.QueueRefresh[TPayload](ICacheRefresher refresher, TPayload[] payload)
at Umbraco.Cms.Core.Cache.DistributedCache.RefreshByPayload[TPayload](Guid refresherGuid, TPayload[] payload)
at Umbraco.Extensions.DistributedCacheExtensions.RefreshAllContentCache(DistributedCache dc)
at Umbraco.Extensions.DistributedCacheExtensions.RefreshAllPublishedSnapshot(DistributedCache dc)
at Umbraco.Cms.Infrastructure.Migrations.MigrationPlanExecutor.RebuildCache()
at Umbraco.Cms.Infrastructure.Migrations.MigrationPlanExecutor.ExecutePlan(MigrationPlan plan, String fromState)
at Umbraco.Cms.Infrastructure.Migrations.Upgrade.Upgrader.Execute(IMigrationPlanExecutor migrationPlanExecutor, ICoreScopeProvider scopeProvider, IKeyValueService keyValueService)
at Umbraco.Cms.Infrastructure.Migrations.Install.DatabaseBuilder.UpgradeSchemaAndData(UmbracoPlan plan)
ClientConnectionId:6c839025-f692-427c-b3d8-fac143150086
Error Number:207,State:1,Class:16
System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation.
---> Umbraco.Cms.Core.Install.InstallException: The database failed to upgrade. ERROR: The database configuration failed with the following message: Invalid column name 'defaultLocationId'.
Invalid column name 'measurementSystem'.
Please check log file for additional information (can be found in 'LoggingSettings.Directory')
at Umbraco.Cms.Infrastructure.Install.InstallSteps.DatabaseUpgradeStep.ExecuteAsync(Object model)
at InvokeStub_InstallSetupStep`1.ExecuteAsync(Object, Span`1)
at System.Reflection.MethodBaseInvoker.InvokeWithOneArg(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
--- End of inner exception stack trace ---
at System.Reflection.MethodBaseInvoker.InvokeWithOneArg(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at System.Reflection.MethodBase.Invoke(Object obj, Object[] parameters)
at Umbraco.Cms.Web.BackOffice.Install.InstallApiController.ExecuteStepAsync(InstallSetupStep step, Object instruction)
at Umbraco.Cms.Web.BackOffice.Install.InstallApiController.PostPerformInstall(InstallInstructions installModel)
I also get info logs about database schema validation errors:
The following tables were found in the database, but are not in the current schema:
umbracoCommerceTranslatedValue,umbracoCommerceProductAttributePreset,umbracoCommerceDiscountCode,umbracoCommerceProductAttributePresetAllowedAttribute,umbracoCommerceOrder,UFRecordWorkflowAudit,umbracoCommerceOrderLineAttribute,SkybrudRedirects,pursuitImportType,umbracoCommercePrintTemplate,pursuitImport,umbracoCommerceExportTemplate,umbracoCommerceStore,umbracoCommerceStoreEntityTag,pursuitExport,umbracoCommerceOrderProperty,umbracoCommerceCurrency,umbracoCommerceOrderLine,umbracoCommerceTaxClass,__EFMigrationsHistory,umbracoCommerceStock,umbracoCommerceOrderStatus,umbracoCommerceOrderLineProperty,umbracoCommerceEmailTemplate,umbracoCommercePaymentMethod,umbracoCommerceGiftCard,umbracoCommerceOrderAppliedDiscountCode,umbracoCommerceShippingMethod,umbracoCommerceOrderAppliedGiftCard,umbracoCommerceCountry,umbracoCommerceMigrations,UFRecords,umbracoCommerceRegion,UFRecordFields,umbracoOpenIddictApplications,umbracoCommerceStoreAllowedUserRole,umbracoOpenIddictScopes,UFRecordDataString,umbracoOpenIddictAuthorizations,umbracoCommerceStoreAllowedUser,UFRecordDataLongString,umbracoCommerceCurrencyAllowedCountry,umbracoOpenIddictTokens,UFRecordDataInteger,umbracoCommerceFrozenPrice,umbracoCommercePaymentMethodAllowedCountryRegion,UFRecordDataBit,UFRecordDataDateTime,umbracoCommercePaymentMethodCountryRegionPrice,UFRecordAudit,umbracoProductLicenseValidationStatus,UFFolders,umbracoCommerceGiftCardProperty,UFForms,umbracoCommercePaymentMethodPaymentProviderSetting,UFWorkflows,umbracoCommerceActivityLog,umbracoCommerceShippingMethodAllowedCountryRegion,UFPrevalueSource,UFDataSource,umbracoCommerceOrderPriceAdjustment,UFUserSecurity,umbracoCommerceShippingMethodCountryRegionPrice,UFUserFormSecurity,umbracoCommerceOrderAmountAdjustment,UFUserGroupSecurity,umbracoCommerceProductAttribute,umbracoCommerceTaxClassCountryRegionTaxRate,UFUserGroupFormSecurity,UFUserStartFolders,umbracoCommerceProductAttributeValue,umbracoCommerceDiscount,UFUserGroupStartFolders
The following columns were found in the database, but are not in the current schema:
umbracoCommerceTranslatedValue,id,umbracoCommerceTranslatedValue,entityId,umbracoCommerceTranslatedValue,entityType,umbracoCommerceTranslatedValue,key,umbracoCommerceTranslatedValue,languageIsoCode,umbracoCommerceTranslatedValue,value,umbracoCommerceProductAttributePreset,id,umbracoCommerceProductAttributePreset,storeId,umbracoCommerceProductAttributePreset,alias,umbracoCommerceProductAttributePreset,name,umbracoCommerceProductAttributePreset,icon,umbracoCommerceProductAttributePreset,description,umbracoCommerceProductAttributePreset,sortOrder,umbracoCommerceProductAttributePreset,deletedTimestamp,umbracoCommerceProductAttributePreset,version,umbracoCommerceDiscountCode,id,umbracoCommerceDiscountCode,storeId,umbracoCommerceDiscountCode,discountId,umbracoCommerceDiscountCode,code,umbracoCommerceDiscountCode,usageLimit,umbracoCommerceDiscountCode,usageCount,umbracoCommerceDiscountCode,deletedTimestamp,umbracoCommerceDiscountCode,isUnlimited,umbracoCommerceProductAttributePresetAllowedAttribute,id,umbracoCommerceProductAttributePresetAllowedAttribute,productAttributePresetId,umbracoCommerceProductAttributePresetAllowedAttribute,productAttributeAlias,umbracoCommerceProductAttributePresetAllowedAttribute,allowedValueAliases,umbracoCommerceOrder,id,umbracoCommerceOrder,storeId,umbracoCommerceOrder,currencyId,umbracoCommerceOrder,taxClassId,umbracoCommerceOrder,languageIsoCode,umbracoCommerceOrder,orderStatusId,umbracoCommerceOrder,orderStatusCode,umbracoCommerceOrder,cartNumber,umbracoCommerceOrder,orderNumber,umbracoCommerceOrder,customerReference,umbracoCommerceOrder,customerFirstName,umbracoCommerceOrder,customerLastName,umbracoCommerceOrder,customerEmail,umbracoCommerceOrder,createDate,umbracoCommerceOrder,updateDate,umbracoCommerceOrder,finalizedDate,umbracoCommerceOrder,paymentCountryId,umbracoCommerceOrder,paymentRegionId,umbracoCommerceOrder,paymentMethodId,umbracoCommerceOrder,paymentTaxRate,umbracoCommerceOrder,paymentTotalPrice,umbracoCommerceOrder,paymentTotalPriceTax,umbracoCommerceOrder,shippingCountryId,umbracoCommerceOrder,shippingRegionId,umbracoCommerceOrder,shippingMethodId,umbracoCommerceOrder,shippingTaxRate,umbracoCommerceOrder,shippingTotalPrice,umbracoCommerceOrder,shippingTotalPriceTax,umbracoCommerceOrder,transactionId,umbracoCommerceOrder,transactionFee,umbracoCommerceOrder,paymentStatus,umbracoCommerceOrder,amountAuthorized,umbracoCommerceOrder,taxRate,umbracoCommerceOrder,inconsistentPayment,umbracoCommerceOrder,copiedFromOrderId,umbracoCommerceOrder,sortOrder,umbracoCommerceOrder,deletedTimestamp,umbracoCommerceOrder,baseCurrencyExchangeRate,umbracoCommerceOrder,version,UFRecordWorkflowAudit,Id,UFRecordWorkflowAudit,RecordUniqueId,UFRecordWorkflowAudit,WorkflowKey,UFRecordWorkflowAudit,WorkflowName,UFRecordWorkflowAudit,WorkflowTypeId,UFRecordWorkflowAudit,WorkflowTypeName,UFRecordWorkflowAudit,ExecutedOn,UFRecordWorkflowAudit,ExecutionStage,UFRecordWorkflowAudit,ExecutionStatus,umbracoCommerceOrderLineAttribute,id,umbracoCommerceOrderLineAttribute,orderId,umbracoCommerceOrderLineAttribute,orderLineId,umbracoCommerceOrderLineAttribute,nameAlias,umbracoCommerceOrderLineAttribute,nameName,umbracoCommerceOrderLineAttribute,valueAlias,umbracoCommerceOrderLineAttribute,valueName,umbracoCommerceOrderLineAttribute,sortOrder,SkybrudRedirects,Id,SkybrudRedirects,Key,SkybrudRedirects,RootKey,SkybrudRedirects,Url,SkybrudRedirects,QueryString,SkybrudRedirects,DestinationType,SkybrudRedirects,DestinationId,SkybrudRedirects,DestinationKey,SkybrudRedirects,DestinationUrl,SkybrudRedirects,Created,SkybrudRedirects,Updated,SkybrudRedirects,IsPermanent,SkybrudRedirects,ForwardQueryString,SkybrudRedirects,DestinationQuery,SkybrudRedirects,DestinationFragment,pursuitImportType,ImportTypeId,pursuitImportType,ImportTypeName,umbracoCommercePrintTemplate,id,umbracoCommercePrintTemplate,storeId,umbracoCommercePrintTemplate,alias,umbracoCommercePrintTemplate,name,umbracoCommercePrintTemplate,category,umbracoCommercePrintTemplate,templateView,umbracoCommercePrintTemplate,sortOrder,umbracoCommercePrintTemplate,deletedTimestamp,umbracoCommercePrintTemplate,version,pursuitImport,ImportId,pursuitImport,ImportTypeId,pursuitImport,ImportFilenames,pursuitImport,Date,pursuitImport,Failed,pursuitImport,FailureReasons,umbracoCommerceExportTemplate,id,umbracoCommerceExportTemplate,storeId,umbracoCommerceExportTemplate,alias,umbracoCommerceExportTemplate,name,umbracoCommerceExportTemplate,category,umbracoCommerceExportTemplate,fileMimeType,umbracoCommerceExportTemplate,fileExtension,umbracoCommerceExportTemplate,exportStrategy,umbracoCommerceExportTemplate,templateView,umbracoCommerceExportTemplate,sortOrder,umbracoCommerceExportTemplate,deletedTimestamp,umbracoCommerceExportTemplate,version,umbracoCommerceStore,id,umbracoCommerceStore,alias,umbracoCommerceStore,name,umbracoCommerceStore,pricesIncludeTax,umbracoCommerceStore,cookieTimeoutInMinutes,umbracoCommerceStore,cartNumberTemplate,umbracoCommerceStore,orderNumberTemplate,umbracoCommerceStore,orderRoundingMethod,umbracoCommerceStore,productPropertyAliases,umbracoCommerceStore,productUniquenessPropertyAliases,umbracoCommerceStore,shareStockFromStoreId,umbracoCommerceStore,giftCardCodeTemplate,umbracoCommerceStore,giftCardCodeLength,umbracoCommerceStore,giftCardDaysValid,umbracoCommerceStore,orderEditorConfig,umbracoCommerceStore,sortOrder,umbracoCommerceStore,deletedTimestamp,umbracoCommerceStore,defaultCountryId,umbracoCommerceStore,defaultTaxClassId,umbracoCommerceStore,defaultOrderStatusId,umbracoCommerceStore,errorOrderStatusId,umbracoCommerceStore,confirmationEmailTemplateId,umbracoCommerceStore,errorEmailTemplateId,umbracoCommerceStore,giftCardActivationMethod,umbracoCommerceStore,giftCardActivationOrderStatusId,umbracoCommerceStore,defaultGiftCardEmailTemplateId,umbracoCommerceStore,giftCardPropertyAliases,umbracoCommerceStore,baseCurrencyId,umbracoCommerceStore,version,umbracoCommerceStoreEntityTag,storeId,umbracoCommerceStoreEntityTag,entityId,umbracoCommerceStoreEntityTag,entityType,umbracoCommerceStoreEntityTag,tag,pursuitExport,ExportId,pursuitExport,DateStarted,pursuitExport,DateCompleted,pursuitExport,Failed,pursuitExport,FailureReasons,umbracoCommerceOrderProperty,id,umbracoCommerceOrderProperty,orderId,umbracoCommerceOrderProperty,alias,umbracoCommerceOrderProperty,value,umbracoCommerceOrderProperty,isServerSideOnly,umbracoCommerceOrderProperty,isReadOnly,umbracoCommerceCurrency,id,umbracoCommerceCurrency,storeId,umbracoCommerceCurrency,name,umbracoCommerceCurrency,code,umbracoCommerceCurrency,cultureName,umbracoCommerceCurrency,formatTemplate,umbracoCommerceCurrency,sortOrder,umbracoCommerceCurrency,deletedTimestamp,umbracoCommerceCurrency,version,umbracoCommerceOrderLine,id,umbracoCommerceOrderLine,orderId,umbracoCommerceOrderLine,parentOrderLineId,umbracoCommerceOrderLine,taxClassId,umbracoCommerceOrderLine,sku,umbracoCommerceOrderLine,name,umbracoCommerceOrderLine,productReference,umbracoCommerceOrderLine,productVariantReference,umbracoCommerceOrderLine,quantity,umbracoCommerceOrderLine,unitPriceBase,umbracoCommerceOrderLine,unitPriceBaseTax,umbracoCommerceOrderLine,unitPrice,umbracoCommerceOrderLine,unitPriceTax,umbracoCommerceOrderLine,taxRate,umbracoCommerceOrderLine,bundleId,umbracoCommerceOrderLine,copiedFromOrderLineId,umbracoCommerceTaxClass,id,umbracoCommerceTaxClass,storeId,umbracoCommerceTaxClass,alias,umbracoCommerceTaxClass,name,umbracoCommerceTaxClass,defaultTaxRate,umbracoCommerceTaxClass,sortOrder,umbracoCommerceTaxClass,deletedTimestamp,umbracoCommerceTaxClass,version,__EFMigrationsHistory,MigrationId,__EFMigrationsHistory,ProductVersion,umbracoCommerceStock,productReference,umbracoCommerceStock,productVariantReference,umbracoCommerceStock,stock,umbracoCommerceOrderStatus,id,umbracoCommerceOrderStatus,storeId,umbracoCommerceOrderStatus,alias,umbracoCommerceOrderStatus,name,umbracoCommerceOrderStatus,color,umbracoCommerceOrderStatus,sortOrder,umbracoCommerceOrderStatus,deletedTimestamp,umbracoCommerceOrderStatus,version,umbracoCommerceOrderLineProperty,id,umbracoCommerceOrderLineProperty,orderId,umbracoCommerceOrderLineProperty,orderLineId,umbracoCommerceOrderLineProperty,alias,umbracoCommerceOrderLineProperty,value,umbracoCommerceOrderLineProperty,isServerSideOnly,umbracoCommerceOrderLineProperty,isReadOnly,umbracoCommerceEmailTemplate,id,umbracoCommerceEmailTemplate,storeId,umbracoCommerceEmailTemplate,alias,umbracoCommerceEmailTemplate,name,umbracoCommerceEmailTemplate,category,umbracoCommerceEmailTemplate,sendToCustomer,umbracoCommerceEmailTemplate,subject,umbracoCommerceEmailTemplate,senderName,umbracoCommerceEmailTemplate,senderAddress,umbracoCommerceEmailTemplate,replyToAddresses,umbracoCommerceEmailTemplate,toAddresses,umbracoCommerceEmailTemplate,ccAddresses,umbracoCommerceEmailTemplate,bccAddresses,umbracoCommerceEmailTemplate,templateView,umbracoCommerceEmailTemplate,sortOrder,umbracoCommerceEmailTemplate,deletedTimestamp,umbracoCommerceEmailTemplate,version,umbracoCommercePaymentMethod,id,umbracoCommercePaymentMethod,storeId,umbracoCommercePaymentMethod,alias,umbracoCommercePaymentMethod,name,umbracoCommercePaymentMethod,sku,umbracoCommercePaymentMethod,taxClassId,umbracoCommercePaymentMethod,imageId,umbracoCommercePaymentMethod,paymentProviderAlias,umbracoCommercePaymentMethod,canFetchPaymentStatuses,umbracoCommercePaymentMethod,canCapturePayments,umbracoCommercePaymentMethod,canRefundPayments,umbracoCommercePaymentMethod,canCancelPayments,umbracoCommercePaymentMethod,sortOrder,umbracoCommercePaymentMethod,deletedTimestamp,umbracoCommercePaymentMethod,version,umbracoCommerceGiftCard,id,umbracoCommerceGiftCard,storeId,umbracoCommerceGiftCard,orderId,umbracoCommerceGiftCard,code,umbracoCommerceGiftCard,currencyId,umbracoCommerceGiftCard,originalAmount,umbracoCommerceGiftCard,remainingAmount,umbracoCommerceGiftCard,expiryDate,umbracoCommerceGiftCard,createDate,umbracoCommerceGiftCard,isActive,umbracoCommerceGiftCard,deletedTimestamp,umbracoCommerceGiftCard,version,umbracoCommerceOrderAppliedDiscountCode,id,umbracoCommerceOrderAppliedDiscountCode,orderId,umbracoCommerceOrderAppliedDiscountCode,discountId,umbracoCommerceOrderAppliedDiscountCode,code,umbracoCommerceOrderAppliedDiscountCode,isFulfilled,umbracoCommerceShippingMethod,id,umbracoCommerceShippingMethod,storeId,umbracoCommerceShippingMethod,alias,umbracoCommerceShippingMethod,name,umbracoCommerceShippingMethod,sku,umbracoCommerceShippingMethod,taxClassId,umbracoCommerceShippingMethod,imageId,umbracoCommerceShippingMethod,sortOrder,umbracoCommerceShippingMethod,deletedTimestamp,umbracoCommerceShippingMethod,version,umbracoCommerceOrderAppliedGiftCard,id,umbracoCommerceOrderAppliedGiftCard,orderId,umbracoCommerceOrderAppliedGiftCard,giftCardId,umbracoCommerceOrderAppliedGiftCard,code,umbracoCommerceCountry,id,umbracoCommerceCountry,storeId,umbracoCommerceCountry,name,umbracoCommerceCountry,code,umbracoCommerceCountry,defaultCurrencyId,umbracoCommerceCountry,defaultShippingMethodId,umbracoCommerceCountry,defaultPaymentMethodId,umbracoCommerceCountry,sortOrder,umbracoCommerceCountry,deletedTimestamp,umbracoCommerceCountry,version,umbracoCommerceMigrations,id,umbracoCommerceMigrations,migration,umbracoCommerceMigrations,applied,UFRecords,Id,UFRecords,Form,UFRecords,Created,UFRecords,Updated,UFRecords,CurrentPage,UFRecords,UmbracoPageId,UFRecords,IP,UFRecords,MemberKey,UFRecords,UniqueId,UFRecords,State,UFRecords,RecordData,UFRecords,Culture,umbracoCommerceRegion,id,umbracoCommerceRegion,storeId,umbracoCommerceRegion,countryId,umbracoCommerceRegion,name,umbracoCommerceRegion,code,umbracoCommerceRegion,defaultShippingMethodId,umbracoCommerceRegion,defaultPaymentMethodId,umbracoCommerceRegion,sortOrder,umbracoCommerceRegion,deletedTimestamp,umbracoCommerceRegion,version,UFRecordFields,Key,UFRecordFields,FieldId,UFRecordFields,Record,UFRecordFields,Alias,UFRecordFields,DataType,umbracoOpenIddictApplications,Id,umbracoOpenIddictApplications,ClientId,umbracoOpenIddictApplications,ClientSecret,umbracoOpenIddictApplications,ConcurrencyToken,umbracoOpenIddictApplications,ConsentType,umbracoOpenIddictApplications,DisplayName,umbracoOpenIddictApplications,DisplayNames,umbracoOpenIddictApplications,Permissions,umbracoOpenIddictApplications,PostLogoutRedirectUris,umbracoOpenIddictApplications,Properties,umbracoOpenIddictApplications,RedirectUris,umbracoOpenIddictApplications,Requirements,umbracoOpenIddictApplications,Type,umbracoCommerceStoreAllowedUserRole,id,umbracoCommerceStoreAllowedUserRole,storeId,umbracoCommerceStoreAllowedUserRole,role,umbracoOpenIddictScopes,Id,umbracoOpenIddictScopes,ConcurrencyToken,umbracoOpenIddictScopes,Description,umbracoOpenIddictScopes,Descriptions,umbracoOpenIddictScopes,DisplayName,umbracoOpenIddictScopes,DisplayNames,umbracoOpenIddictScopes,Name,umbracoOpenIddictScopes,Properties,umbracoOpenIddictScopes,Resources,UFRecordDataString,Id,UFRecordDataString,Key,UFRecordDataString,Value,umbracoOpenIddictAuthorizations,Id,umbracoOpenIddictAuthorizations,ApplicationId,umbracoOpenIddictAuthorizations,ConcurrencyToken,umbracoOpenIddictAuthorizations,CreationDate,umbracoOpenIddictAuthorizations,Properties,umbracoOpenIddictAuthorizations,Scopes,umbracoOpenIddictAuthorizations,Status,umbracoOpenIddictAuthorizations,Subject,umbracoOpenIddictAuthorizations,Type,umbracoCommerceStoreAllowedUser,id,umbracoCommerceStoreAllowedUser,storeId,umbracoCommerceStoreAllowedUser,userId,UFRecordDataLongString,Id,UFRecordDataLongString,Key,UFRecordDataLongString,Value,umbracoCommerceCurrencyAllowedCountry,id,umbracoCommerceCurrencyAllowedCountry,currencyId,umbracoCommerceCurrencyAllowedCountry,countryId,umbracoOpenIddictTokens,Id,umbracoOpenIddictTokens,ApplicationId,umbracoOpenIddictTokens,AuthorizationId,umbracoOpenIddictTokens,ConcurrencyToken,umbracoOpenIddictTokens,CreationDate,umbracoOpenIddictTokens,ExpirationDate,umbracoOpenIddictTokens,Payload,umbracoOpenIddictTokens,Properties,umbracoOpenIddictTokens,RedemptionDate,umbracoOpenIddictTokens,ReferenceId,umbracoOpenIddictTokens,Status,umbracoOpenIddictTokens,Subject,umbracoOpenIddictTokens,Type,UFRecordDataInteger,Id,UFRecordDataInteger,Key,UFRecordDataInteger,Value,umbracoCommerceFrozenPrice,id,umbracoCommerceFrozenPrice,orderId,umbracoCommerceFrozenPrice,key,umbracoCommerceFrozenPrice,currencyId,umbracoCommerceFrozenPrice,countryId,umbracoCommerceFrozenPrice,regionId,umbracoCommerceFrozenPrice,value,umbracoCommerceFrozenPrice,createDate,umbracoCommercePaymentMethodAllowedCountryRegion,id,umbracoCommercePaymentMethodAllowedCountryRegion,paymentMethodId,umbracoCommercePaymentMethodAllowedCountryRegion,countryId,umbracoCommercePaymentMethodAllowedCountryRegion,regionId,UFRecordDataBit,Id,UFRecordDataBit,Key,UFRecordDataBit,Value,UFRecordDataDateTime,Id,UFRecordDataDateTime,Key,UFRecordDataDateTime,Value,umbracoCommercePaymentMethodCountryRegionPrice,id,umbracoCommercePaymentMethodCountryRegionPrice,paymentMethodId,umbracoCommercePaymentMethodCountryRegionPrice,countryId,umbracoCommercePaymentMethodCountryRegionPrice,regionId,umbracoCommercePaymentMethodCountryRegionPrice,currencyId,umbracoCommercePaymentMethodCountryRegionPrice,price,UFRecordAudit,Id,UFRecordAudit,Record,UFRecordAudit,UpdatedOn,UFRecordAudit,UpdatedBy,umbracoProductLicenseValidationStatus,ProductId,umbracoProductLicenseValidationStatus,LicenseKey,umbracoProductLicenseValidationStatus,LastResult,umbracoProductLicenseValidationStatus,LastValidatedOn,umbracoProductLicenseValidationStatus,Domains,umbracoProductLicenseValidationStatus,ExpiresOn,umbracoProductLicenseValidationStatus,Features,umbracoProductLicenseValidationStatus,LastSuccessfullyValidatedOn,umbracoProductLicenseValidationStatus,SignatureSignedHash,umbracoProductLicenseValidationStatus,SignatureVersion,UFFolders,ParentKey,UFFolders,Id,UFFolders,Key,UFFolders,Name,UFFolders,Definition,UFFolders,Created,UFFolders,Updated,umbracoCommerceGiftCardProperty,id,umbracoCommerceGiftCardProperty,giftCardId,umbracoCommerceGiftCardProperty,alias,umbracoCommerceGiftCardProperty,value,umbracoCommerceGiftCardProperty,isServerSideOnly,umbracoCommerceGiftCardProperty,isReadOnly,UFForms,FolderKey,UFForms,Id,UFForms,Key,UFForms,Name,UFForms,Definition,UFForms,Created,UFForms,Updated,umbracoCommercePaymentMethodPaymentProviderSetting,id,umbracoCommercePaymentMethodPaymentProviderSetting,paymentMethodId,umbracoCommercePaymentMethodPaymentProviderSetting,key,umbracoCommercePaymentMethodPaymentProviderSetting,value,UFWorkflows,FormId,UFWorkflows,Id,UFWorkflows,Key,UFWorkflows,Name,UFWorkflows,Definition,UFWorkflows,Created,UFWorkflows,Updated,umbracoCommerceActivityLog,id,umbracoCommerceActivityLog,storeId,umbracoCommerceActivityLog,entityId,umbracoCommerceActivityLog,entityType,umbracoCommerceActivityLog,entitySummary,umbracoCommerceActivityLog,eventType,umbracoCommerceActivityLog,eventSummary,umbracoCommerceActivityLog,eventDateUtc,umbracoCommerceActivityLog,userId,umbracoCommerceShippingMethodAllowedCountryRegion,id,umbracoCommerceShippingMethodAllowedCountryRegion,shippingMethodId,umbracoCommerceShippingMethodAllowedCountryRegion,countryId,umbracoCommerceShippingMethodAllowedCountryRegion,regionId,UFPrevalueSource,Id,UFPrevalueSource,Key,UFPrevalueSource,Name,UFPrevalueSource,Definition,UFPrevalueSource,Created,UFPrevalueSource,Updated,UFDataSource,Id,UFDataSource,Key,UFDataSource,Name,UFDataSource,Definition,UFDataSource,Created,UFDataSource,Updated,umbracoCommerceOrderPriceAdjustment,id,umbracoCommerceOrderPriceAdjustment,orderId,umbracoCommerceOrderPriceAdjustment,orderLineId,umbracoCommerceOrderPriceAdjustment,priceType,umbracoCommerceOrderPriceAdjustment,type,umbracoCommerceOrderPriceAdjustment,name,umbracoCommerceOrderPriceAdjustment,originalValue,umbracoCommerceOrderPriceAdjustment,originalTax,umbracoCommerceOrderPriceAdjustment,value,umbracoCommerceOrderPriceAdjustment,tax,umbracoCommerceOrderPriceAdjustment,metaData,UFUserSecurity,User,UFUserSecurity,ManageDataSources,UFUserSecurity,ManagePreValueSources,UFUserSecurity,ManageWorkflows,UFUserSecurity,ManageForms,UFUserSecurity,ViewEntries,UFUserSecurity,EditEntries,umbracoCommerceShippingMethodCountryRegionPrice,id,umbracoCommerceShippingMethodCountryRegionPrice,shippingMethodId,umbracoCommerceShippingMethodCountryRegionPrice,countryId,umbracoCommerceShippingMethodCountryRegionPrice,regionId,umbracoCommerceShippingMethodCountryRegionPrice,currencyId,umbracoCommerceShippingMethodCountryRegionPrice,price,UFUserFormSecurity,Id,UFUserFormSecurity,User,UFUserFormSecurity,Form,UFUserFormSecurity,HasAccess,UFUserFormSecurity,AllowInEditor,UFUserFormSecurity,SecurityType,umbracoCommerceOrderAmountAdjustment,id,umbracoCommerceOrderAmountAdjustment,orderId,umbracoCommerceOrderAmountAdjustment,amountType,umbracoCommerceOrderAmountAdjustment,type,umbracoCommerceOrderAmountAdjustment,name,umbracoCommerceOrderAmountAdjustment,originalValue,umbracoCommerceOrderAmountAdjustment,value,umbracoCommerceOrderAmountAdjustment,metaData,UFUserGroupSecurity,UserGroupId,UFUserGroupSecurity,ManageDataSources,UFUserGroupSecurity,ManagePreValueSources,UFUserGroupSecurity,ManageWorkflows,UFUserGroupSecurity,ManageForms,UFUserGroupSecurity,ViewEntries,UFUserGroupSecurity,EditEntries,umbracoCommerceProductAttribute,id,umbracoCommerceProductAttribute,storeId,umbracoCommerceProductAttribute,alias,umbracoCommerceProductAttribute,name,umbracoCommerceProductAttribute,sortOrder,umbracoCommerceProductAttribute,deletedTimestamp,umbracoCommerceProductAttribute,version,umbracoCommerceTaxClassCountryRegionTaxRate,id,umbracoCommerceTaxClassCountryRegionTaxRate,taxClassId,umbracoCommerceTaxClassCountryRegionTaxRate,countryId,umbracoCommerceTaxClassCountryRegionTaxRate,regionId,umbracoCommerceTaxClassCountryRegionTaxRate,taxRate,UFUserGroupFormSecurity,Id,UFUserGroupFormSecurity,UserGroupId,UFUserGroupFormSecurity,Form,UFUserGroupFormSecurity,HasAccess,UFUserGroupFormSecurity,AllowInEditor,UFUserGroupFormSecurity,SecurityType,UFUserStartFolders,UserId,UFUserStartFolders,FolderKey,umbracoCommerceProductAttributeValue,id,umbracoCommerceProductAttributeValue,productAttributeId,umbracoCommerceProductAttributeValue,alias,umbracoCommerceProductAttributeValue,name,umbracoCommerceProductAttributeValue,sortOrder,umbracoCommerceDiscount,id,umbracoCommerceDiscount,storeId,umbracoCommerceDiscount,alias,umbracoCommerceDiscount,name,umbracoCommerceDiscount,type,umbracoCommerceDiscount,startDate,umbracoCommerceDiscount,expiryDate,umbracoCommerceDiscount,blockFurtherDiscounts,umbracoCommerceDiscount,blockIfPreviousDiscounts,umbracoCommerceDiscount,isActive,umbracoCommerceDiscount,sortOrder,umbracoCommerceDiscount,deletedTimestamp,umbracoCommerceDiscount,rules,umbracoCommerceDiscount,rewards,umbracoCommerceDiscount,version,UFUserGroupStartFolders,UserGroupId,UFUserGroupStartFolders,FolderKey
The following constraints (Primary Keys, Foreign Keys and Indexes) were found in the database, but are not in the current schema:
FK_Import_ImportTypeId,FK_UFFolders_UFFolders_Key,FK_UFFolders_UFFolders_ParentKey,FK_UFForms_UFFolders_FolderKey,FK_UFForms_UFFolders_Key,FK_UFRecordAudit_UFRecords_Id,FK_UFRecordDataBit_UFRecordFields_Key,FK_UFRecordDataDateTime_UFRecordFields_Key,FK_UFRecordDataInteger_UFRecordFields_Key,FK_UFRecordDataLongString_UFRecordFields_Key,FK_UFRecordDataString_UFRecordFields_Key,FK_UFRecordFields_UFRecords_Id,FK_UFRecordFields_UFRecords_Record,FK_UFUserFormSecurity_UFForms_Key,FK_UFUserGroupFormSecurity_UFForms_Key,FK_UFUserGroupStartFolders_UFFolders_FolderKey,FK_UFUserGroupStartFolders_UFFolders_Key,FK_UFUserStartFolders_UFFolders_FolderKey,FK_UFUserStartFolders_UFFolders_Key,FK_umbracoCommerceStore_umbracoCommerceCountry_defaultCountry,FK_umbracoCommerceStore_umbracoCommerceCurrency_baseCurrency,FK_umbracoCommerceStore_umbracoCommerceEmailTemplate_confirmationEmailTemplate,FK_umbracoCommerceStore_umbracoCommerceEmailTemplate_defaultGiftCardEmailTemplate,FK_umbracoCommerceStore_umbracoCommerceEmailTemplate_errorEmailTemplate,FK_umbracoCommerceStore_umbracoCommerceOrderStatus_defaultOrderStatus,FK_umbracoCommerceStore_umbracoCommerceOrderStatus_errorOrderStatus,FK_umbracoCommerceStore_umbracoCommerceOrderStatus_giftCardActivationOrderStatus,FK_umbracoCommerceStore_umbracoCommerceTaxClass_defaultTaxClass,FK_umbracoOpenIddictAuthorizations_umbracoOpenIddictApplications_ApplicationId,FK_umbracoOpenIddictTokens_umbracoOpenIddictApplications_ApplicationId,FK_umbracoOpenIddictTokens_umbracoOpenIddictAuthorizations_AuthorizationId,FK_vendrActivityLog_vendrStore,FK_vendrCountry_vendrCurrency,FK_vendrCountry_vendrPaymentMethod,FK_vendrCountry_vendrShippingMethod,FK_vendrCountry_vendrStore,FK_vendrCurrency_vendrStore,FK_vendrCurrencyAllowedCountry_vendrCountry,FK_vendrCurrencyAllowedCountry_vendrCurrency,FK_vendrDiscount_vendrStore,FK_vendrDiscountCode_vendrDiscount,FK_vendrDiscountCode_vendrStore,FK_vendrEmailTemplate_vendrStore,FK_vendrExportTemplate_vendrStore,FK_vendrFrozenPrice_vendrCountry,FK_vendrFrozenPrice_vendrCurrency,FK_vendrFrozenPrice_vendrOrder,FK_vendrFrozenPrice_vendrRegion,FK_vendrGiftCard_vendrCurrency,FK_vendrGiftCard_vendrOrder,FK_vendrGiftCard_vendrStore,FK_vendrGiftCardProperty_vendrGiftCard,FK_vendrOrder_vendrCountry_paymentCountry,FK_vendrOrder_vendrCountry_shippingCountry,FK_vendrOrder_vendrCurrency,FK_vendrOrder_vendrOrder_copiedFrom,FK_vendrOrder_vendrOrderStatus,FK_vendrOrder_vendrPaymentMethod,FK_vendrOrder_vendrRegion_paymentRegion,FK_vendrOrder_vendrRegion_shippingRegion,FK_vendrOrder_vendrShippingMethod,FK_vendrOrder_vendrStore,FK_vendrOrder_vendrTaxClass,FK_vendrOrderAmountAdjustment_vendrOrder,FK_vendrOrderAppliedDiscountCode_vendrDiscount,FK_vendrOrderAppliedDiscountCode_vendrOrder,FK_vendrOrderAppliedGiftCard_vendrGiftCard,FK_vendrOrderAppliedGiftCard_vendrOrder,FK_vendrOrderLine_vendrOrder,FK_vendrOrderLine_vendrOrderLine,FK_vendrOrderLine_vendrOrderLine_copiedFrom,FK_vendrOrderLine_vendrTaxClass,FK_vendrOrderLineAttribute_vendrOrder,FK_vendrOrderLineAttribute_vendrOrderLine,FK_vendrOrderLineProperty_vendrOrder,FK_vendrOrderLineProperty_vendrOrderLine,FK_vendrOrderPriceAdjustment_vendrOrder,FK_vendrOrderPriceAdjustment_vendrOrderLine,FK_vendrOrderProperty_vendrOrder,FK_vendrOrderStatus_vendrStore,FK_vendrPaymentMethod_vendrStore,FK_vendrPaymentMethod_vendrTaxClass,FK_vendrPaymentMethodAllowedCountryRegion_vendrCountry,FK_vendrPaymentMethodAllowedCountryRegion_vendrPaymentMethod,FK_vendrPaymentMethodAllowedCountryRegion_vendrRegion,FK_vendrPaymentMethodCountryRegionPrice_vendrCountry,FK_vendrPaymentMethodCountryRegionPrice_vendrCurrency,FK_vendrPaymentMethodCountryRegionPrice_vendrPaymentMethod,FK_vendrPaymentMethodCountryRegionPrice_vendrRegion,FK_vendrPaymentMethodPaymentProviderSetting_vendrPaymentMethod,FK_vendrPrintTemplate_vendrStore,FK_vendrProductAttribute_vendrStore,FK_vendrProductAttributePreset_vendrStore,FK_vendrProductAttributePresetAllowedAttribute_vendrProductAttributePreset,FK_vendrProductAttributeValue_vendrProductAttribute,FK_vendrRegion_vendrCountry,FK_vendrRegion_vendrPaymentMethod,FK_vendrRegion_vendrShippingMethod,FK_vendrRegion_vendrStore,FK_vendrShippingMethod_vendrStore,FK_vendrShippingMethod_vendrTaxClass,FK_vendrShippingMethodAllowedCountryRegion_vendrCountry,FK_vendrShippingMethodAllowedCountryRegion_vendrRegion,FK_vendrShippingMethodAllowedCountryRegion_vendrShippingMethod,FK_vendrShippingMethodCountryRegionPrice_vendrCountry,FK_vendrShippingMethodCountryRegionPrice_vendrCurrency,FK_vendrShippingMethodCountryRegionPrice_vendrRegion,FK_vendrShippingMethodCountryRegionPrice_vendrShippingMethod,FK_vendrStore_vendrCountry_defaultCountry,FK_vendrStore_vendrEmailTemplate_confirmationEmailTemplate,FK_vendrStore_vendrEmailTemplate_defaultGiftCardEmailTemplate,FK_vendrStore_vendrEmailTemplate_errorEmailTemplate,FK_vendrStore_vendrOrderStatus_defaultOrderStatus,FK_vendrStore_vendrOrderStatus_errorOrderStatus,FK_vendrStore_vendrOrderStatus_giftCardActivationOrderStatus,FK_vendrStore_vendrStore_stockSharing,FK_vendrStore_vendrTaxClass_defaultTaxClass,FK_vendrStoreAllowedUser_vendrStore,FK_vendrStoreAllowedUserRole_vendrStore,FK_vendrStoreEntityTag_vendrStore,FK_vendrTaxClass_vendrStore,FK_vendrTaxClassCountryRegionTaxRate_vendrCountry,FK_vendrTaxClassCountryRegionTaxRate_vendrRegion,FK_vendrTaxClassCountryRegionTaxRate_vendrTaxClass,PK___EFMigrationsHistory,PK_pursuitExport,PK_pursuitImport,PK_pursuitImportType,PK_SkybrudRedirects,PK_UFDataSource,PK_UFFolders,PK_UFForms,PK_UFPrevalueSource,PK_UFRecordAudit,PK_UFRecordDataBit,PK_UFRecordDataDateTime,PK_UFRecordDataInteger,PK_UFRecordDataLongString,PK_UFRecordDataString,PK_UFRecordFields,PK_UFRecords,PK_UFRecordWorkflowAudit,PK_UFUserGroupStartFolders,PK_UFUserSecurity,PK_UFUserStartFolders,PK_UFWorkflows,PK_umbracoCommerceMigrations_Id,PK_umbracoOpenIddictApplications,PK_umbracoOpenIddictAuthorizations,PK_umbracoOpenIddictScopes,PK_umbracoOpenIddictTokens,PK_umbracoProductLicenseValidationStatus,PK_UserGroupFormSecurity,PK_UserGroupSecurity,PK_vendrActivityLog,PK_vendrCountry,PK_vendrCurrency,PK_vendrCurrencyAllowedCountry,PK_vendrDiscount,PK_vendrDiscountCode,PK_vendrEmailTemplate,PK_vendrExportTemplate,PK_vendrFrozenPrice,PK_vendrGiftCard,PK_vendrGiftCardProperty,PK_vendrOrder,PK_vendrOrderAmountAdjustment,PK_vendrOrderAppliedDiscountCode,PK_vendrOrderAppliedGiftCard,PK_vendrOrderLine,PK_vendrOrderLineAttribute,PK_vendrOrderLineProperty,PK_vendrOrderPriceAdjustment,PK_vendrOrderProperty,PK_vendrOrderStatus,PK_vendrPaymentMethod,PK_vendrPaymentMethodAllowedCountryRegion,PK_vendrPaymentMethodCountryRegionPrice,PK_vendrPaymentMethodPaymentProviderSetting,PK_vendrPrintTemplate,PK_vendrProductAttribute,PK_vendrProductAttributePreset,PK_vendrProductAttributePresetAllowedAttribute,PK_vendrProductAttributeValue,PK_vendrRegion,PK_vendrShippingMethod,PK_vendrShippingMethodAllowedCountryRegion,PK_vendrShippingMethodCountryRegionPrice,PK_vendrStore,PK_vendrStoreAllowedUser,PK_vendrStoreAllowedUserRole,PK_vendrTaxClass,PK_vendrTaxClassCountryRegionTaxRate,PK_vendrTranslatedValue
The following indexes were found in the database, but are not in the current schema:
IX_UFDataSource_Key,UK_UFDataSource_Key,IX_UFFolders_Key,UK_UFFolders_Key,IX_UFForms_Key,UK_UFForms_Key,IX_UFPrevalueSource_Key,UK_UFPrevalueSource_Key,IX_Record_RecordAudit,IX_Record_UpdatedBy,IX_databit_recordfield,IX_datadatetime_recordfield,IX_datainteger_recordfield,IX_datalongstring_recordfield,IX_datastring_recordfield,IX_record_recordfield,IX_RecordUniqueId_RecordWorkflowAudit,IX_WorkflowKey_RecordWorkflowAudit,IX_UserFormSecurity_Form,IX_UserFormSecurity_User,UK_UFUserFormSecurity_User_Form,IX_UserGroupFormSecurity_Form,IX_UserGroupFormSecurity_UserGroupId,UK_UFUserGroupFormSecurity_UserGroupId_Form,IX_UserGroupStartFolder_FolderKey,IX_UserGroupStartFolder_UserGroupId,IX_UserStartFolder_FolderKey,IX_UserStartFolder_UserId,IX_UFWorkflows_FormId,IX_UFWorkflows_Key,UK_UFWorkflows_Key,IX_umbracoCommerceActivityLog_storeId,IX_umbracoCommerceCountry_storeId,IX_vendrCountry_code,IX_umbracoCommerceCurrency_storeId,IX_vendrCurrency_code,IX_vendrCurrencyAllowedCountry_compositeId,IX_umbracoCommerceDiscount_storeId,IX_vendrDiscount_alias,IX_umbracoCommerceDiscountCode_storeId,IX_vendrDiscountCode_code,IX_umbracoCommerceEmailTemplate_storeId,IX_vendrEmailTemplate_alias,IX_umbracoCommerceExportTemplate_storeId,IX_vendrExportTemplate_alias,IX_umbracoCommerceFrozenPrice_orderId,IX_vendrFrozenPrice_compositeId,IX_umbracoCommerceGiftCard_orderId,IX_umbracoCommerceGiftCard_storeId,IX_vendrGiftCard_code,IX_vendrGiftCardProperty_compositeId,IX_umbracoCommerceOrder_storeId,IX_umbracoCommerceOrderAmountAdjustment_orderId,IX_umbracoCommerceOrderAppliedDiscountCode_orderId,IX_vendrOrderAppliedDiscountCode_compositeId,IX_umbracoCommerceOrderAppliedGiftCard_orderId,IX_vendrOrderAppliedGiftCard_compositeId,IX_umbracoCommerceOrderLine_orderId,IX_umbracoCommerceOrderLineAttribute_orderId,IX_vendrOrderLineAttribute_compositeId,IX_umbracoCommerceOrderLineProperty_orderId,IX_vendrOrderLineProperty_compositeId,IX_umbracoCommerceOrderPriceAdjustment_orderId,IX_umbracoCommerceOrderProperty_orderId,IX_vendrOrderProperty_compositeId,IX_umbracoCommerceOrderStatus_storeId,IX_vendrOrderStatus_alias,IX_umbracoCommercePaymentMethod_storeId,IX_vendrPaymentMethod_alias,IX_vendrPaymentMethod_sku,IX_vendrPaymentMethodAllowedCountryRegion_compositeId,IX_vendrPaymentMethodCountryRegionPrice_compositeId,IX_vendrPaymentMethodPaymentProviderSetting_compositeId,IX_umbracoCommercePrintTemplate_storeId,IX_vendrPrintTemplate_alias,IX_umbracoCommerceProductAttribute_storeId,IX_vendrProductAttribute_alias,IX_umbracoCommerceProductAttributePreset_storeId,IX_vendrProductAttributePreset_alias,IX_vendrProductAttributePresetAllowedAttribute_alias,IX_vendrProductAttributeValue_alias,IX_umbracoCommerceRegion_storeId,IX_vendrRegion_code,IX_umbracoCommerceShippingMethod_storeId,IX_vendrShippingMethod_alias,IX_vendrShippingMethod_sku,IX_vendrShippingMethodAllowedCountryRegion_compositeId,IX_vendrShippingMethodCountryRegionPrice_compositeId,IX_vendrStock_ref,IX_vendrStore_alias,IX_umbracoCommerceStoreAllowedUser_storeId,IX_vendrStoreAllowedUser_compositeId,IX_umbracoCommerceStoreAllowedUserRole_storeId,IX_vendrStoreAllowedUserRole_compositeId,IX_umbracoCommerceStoreEntityTag_storeId,IX_vendrStoreEntityTag_tag,IX_umbracoCommerceTaxClass_storeId,IX_vendrTaxClass_alias,IX_vendrTaxClassCountryRegionTaxRate_compositeId,IX_vendrTranslatedValue_value,IX_umbracoOpenIddictApplications_ClientId,IX_umbracoOpenIddictAuthorizations_ApplicationId_Status_Subject_Type,IX_umbracoOpenIddictScopes_Name,IX_umbracoOpenIddictTokens_ApplicationId_Status_Subject_Type,IX_umbracoOpenIddictTokens_AuthorizationId,IX_umbracoOpenIddictTokens_ReferenceId
The following unknown constraints (Primary Keys, Foreign Keys and Indexes) were found in the database, but are not in the current schema:
Id,UK_UFDataSource_Key,UK_UFFolders_Key,UK_UFForms_Key,UK_UFPrevalueSource_Key,UK_UFUserFormSecurity_User_Form,UK_UFUserGroupFormSecurity_UserGroupId_Form,UK_UFWorkflows_Key
I have installed a clean Umbraco 10 solution with a few packages (Contentment, Skybrud.Redirects, Umbraco Forms) and Umbraco.Commerce 10, and been able to upgrade that DB to Umbraco 13. Pointing this clean upgraded solution to a backup of my v10 database and it upgrades, builds and runs fine.
I don't know whether this is a problem with custom code/something with the DB as I am able to upgrade a clean solution.
It definitely sounds like the migrations have failed to run. Maybe try clearing the umbracoCommerceMigrations table to get the migrations to re-run. They should all be written defensively so it should be fine for them to run again.
Unfortunately that hasn't done anything. Still get the database configuration failed error.
Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid column name 'defaultLocationId'.
Invalid column name 'measurementSystem'.
The umbracoCommerceMigrations table remains empty so no migrations completed.
It looks like the first v13 migration to be run is Umbraco.Commerce.Persistence.SqlServer.Migrations.Implement.v13_01_00.M20231031105000_CreateLocationTable.sql which seems to tie in with the failed defaultLocationId column.
Describe the bug
I am trying to upgrade an Umbraco 10 project to Umbraco 13, which includes Umbraco.Commerce. I have been able to upgrade the solution and packages and the solution builds, but the migration fails, with a
Database configuration failed
error. By turning off unattendedUpgrade I have been able to get more detailed logs.Database configuration failed
SourceContext = Umbraco.Cms.Infrastructure.Migrations.Install.DatabaseBuilder
I also get info logs about database schema validation errors:
I have installed a clean Umbraco 10 solution with a few packages (Contentment, Skybrud.Redirects, Umbraco Forms) and Umbraco.Commerce 10, and been able to upgrade that DB to Umbraco 13. Pointing this clean upgraded solution to a backup of my v10 database and it upgrades, builds and runs fine.
I don't know whether this is a problem with custom code/something with the DB as I am able to upgrade a clean solution.
Umbraco Commerce version:
Umbraco.CMS 10.8.3 -> 13.4.0
Umbraco.Commerce 10.0.5 -> 13.1.6
Umbraco.Commerce.Checkout 10.0.0 -> 13.1.1
Umbraco.Commerce.PaymentProviders.Klarna 10.0.1 -> 13.1.0
Umbraco.Commerce.PaymentProviders.PayPal 10.0.0 -> 13.1.1
The text was updated successfully, but these errors were encountered: