Version 4.3 to 4.4 Fails with Database Error

Yes, I tried removing all my plugins before converting from 4.2 to 4.3, then went to 4.4 with the same errors.

SkierHiker wrote:
Check the table [MigrationVersionInfo].  Are there records in there?
(The upgrade.sql for 4.30 has 168 of these "INSERT [MigrationVersionInfo] ...  )

Yes, it has the following records:

AppliedOn  Description  Version
2020-03-18 07:23:31.000  Nop.Data base schema  637160666562551771
2020-03-18 07:25:09.000  Tax.FixedOrByCountryStateZip base schema  637163188436455432
2020-04-30 13:53:20.000  AddPCMProductIdExtendedIX  637196977559280389
2020-04-30 13:53:20.000  AddPMMProductIdExtendedIX  637196977559280390
2020-04-30 13:53:20.000  AddPSAMAllowFilteringIX  637196977559280391
2020-04-30 13:53:20.000  AddPSAMSpecificationAttributeOptionIdAllowFilteringIX  637196977559280392
2020-04-30 13:53:20.000  AddQueuedEmailSentOnUtcDontSendBeforeDateUtcExtendedIX  637196977559280393
2020-04-30 13:53:20.000  AddProductVisibleIndividuallyPublishedDeletedExtendedIX  637196977559280394
2020-04-30 13:53:20.000  AddCategoryDeletedExtendedIX  637196977559280395
2020-03-18 07:23:31.000  AddLocaleStringResourceIX  637196889689037677
2020-03-18 07:23:31.000  AddProductPriceDatesEtcIX  637196889689037678
2020-03-18 07:23:31.000  AddCountryDisplayOrderIX  637196889689037679
2020-03-18 07:23:31.000  AddLogCreatedOnUtcIX  637196889689037680
2020-03-18 07:23:31.000  AddCustomerEmailIX  637196889689037681
2020-03-18 07:23:31.000  AddCustomerUsernameIX  637196889689037682
2020-03-18 07:23:31.000  AddCustomerCustomerGuidIX  637196889689037683
2020-03-18 07:23:31.000  AddCustomerSystemNameIX  637196889689037684
2020-03-18 07:23:31.000  AddCustomerCreatedOnUtcIX  637196889689037685
2020-03-18 07:23:31.000  AddGenericAttributeEntityIdKeyGroupIX  637196889689037686
2020-03-18 07:23:31.000  AddQueuedEmailCreatedOnUtcIX  637196889689037687
2020-03-18 07:23:31.000  AddOrderCreatedOnUtcIX  637196889689037688
2020-03-18 07:23:31.000  AddLanguageDisplayOrderIX  637196889689037689
2020-03-18 07:23:31.000  AddNewsletterSubscriptionEmailStoreIdIX  637196889689037690
2020-03-18 07:23:31.000  AddShoppingCartItemShoppingCartTypeIdCustomerIdIX  637196889689037691
2020-03-18 07:23:32.000  AddRelatedProductProductId1IX  637196889689037692
2020-03-18 07:23:32.000  AddProductAttributeValueProductAttributeMappingIdDisplayOrderIX  637196889689037693
2020-03-18 07:23:32.000  AddProductProductAttributeMappingProductIdDisplayOrderIX  637196889689037694
2020-03-18 07:23:32.000  AddManufacturerDisplayOrderIX  637196889689037695
2020-03-18 07:23:32.000  AddCategoryDisplayOrderIX  637196889689037696
2020-03-18 07:23:32.000  AddCategoryParentCategoryIdIX  637196889689037697
2020-03-18 07:23:32.000  AddForumsGroupDisplayOrderIX  637196889689037698
2020-03-18 07:23:32.000  AddForumsForumDisplayOrderIX  637196889689037699
2020-03-18 07:23:32.000  AddForumsSubscriptionForumIdIX  637196889689037700
2020-03-18 07:23:32.000  AddForumsSubscriptionTopicIdIX  637196889689037701
2020-03-18 07:23:32.000  AddProductDeletedPublishedIX  637196889689037702
2020-03-18 07:23:32.000  AddProductPublishedIX  637196889689037703
2020-03-18 07:23:32.000  AddProductShowOnHomepageIX  637196889689037704
2020-03-18 07:23:32.000  AddProductParentGroupedProductIdIX  637196889689037705
2020-03-18 07:23:32.000  AddProductVisibleIndividuallyIX  637196889689037706
2020-03-18 07:23:32.000  AddPCMProductCategoryIX  637196889689037707
2020-03-18 07:23:32.000  AddCurrencyDisplayOrderIX  637196889689037708
2020-03-18 07:23:32.000  AddProductTagNameIX  637196961091647925
2020-03-18 07:23:32.000  AddActivityLogCreatedOnUtcIX  637196961091647926
2020-03-18 07:23:32.000  AddUrlRecordSlugIX  637196961091647927
2020-03-18 07:23:32.000  AddUrlRecordCustom1IX  637196961091647928
2020-03-18 07:23:32.000  AddAclRecordEntityIdEntityNameIX  637196961091647929
2020-03-18 07:23:32.000  AddStoreMappingEntityIdEntityNameIX  637196961091647930
2020-03-18 07:23:32.000  AddCategoryLimitedToStoresIX  637196961091647931
2020-03-18 07:23:32.000  AddManufacturerLimitedToStoresIX  637196961091647932
2020-03-18 07:23:32.000  AddProductLimitedToStoresIX  637196961091647933
2020-03-18 07:23:32.000  AddCategorSubjectToAclIX  637196961091647934
2020-03-18 07:23:32.000  AddManufacturerSubjectToAclIX  637196961091647935
2020-03-18 07:23:32.000  AddProductSubjectToAclIX  637196961091647936
2020-03-18 07:23:32.000  AddProductCategoryMappingIsFeaturedProductIX  637196961091647937
2020-03-18 07:23:32.000  AddProductManufacturerMappingIsFeaturedProductIX  637196961091647938
2020-03-18 07:23:32.000  AddCustomerCustomerRoleMappingCustomerIdIX  637196961091647939
2020-03-18 07:23:32.000  AddProductDeleteIdIX  637196961091647940
2020-03-18 07:23:32.000  AddGetLowStockProductsIX  637196961091647941
2020-03-18 07:23:32.000  AddPMMProductManufacturerIX  637196961091647942
2020-03-18 07:23:32.000  AddOrderRewardPointsHistoryFK  637200411689037680

Yes, that looks like what I have in my 4.30 DB.  (I'm not sure why only the "IX" ones get saved, since the script does also INSERT "FK" ones too.)

Ok, I found the problem. The 4.3 update script created and populated a BlueFire.MigrationVersionInfo instead of populating the dbo.MigrationVersionInfo table. The columns were the same but in a different order. I reordered the columns and copied the rows over to the dbo table and the 4.3 to 4.4 migration worked fine.

Maybe someone from nopCommerce could look into this as it did cause quite a lot of grief.