umbraco / Umbraco.Commerce.Issues

18 stars 2 forks source link

Unable to upgrade Umbraco.Commerce 10.0.5 to 13.1.6 #541

Open Wiggee11 opened 1 month ago

Wiggee11 commented 1 month ago

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

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.

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

mattbrailsford commented 1 month ago

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.

Wiggee11 commented 1 month ago

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.