Hi
I am upgrading a custom NopCommerce site from version 4.3 to 4.4 , I have download the source code of version 4.4 , made the changes of dataSettings.json and InstalledPlugins.json files and then rebuild the project , where I hoped the database upgrade has been completed automatically as far the instruction.
Please consider, I am Upgrading above 4.3 first time
But my questions are
1. How i would know that database has upgraded after I have rebuild the Source code (V4.4) using the 4.3 database connection string ? rebuild output all succeeded
2. how munch do i need to change the web.config file please?
3. is the any place in database we have got current version record ?
would be much appreciated for your response
Many thanks & Regards
Questions on the process of Upgrade from version from 4.3 to 4.4
MVP
- 11328
- 101032
- 5/22/2011
- United States
You can use a SQL tool (like SSMS) to check the DB:
Near the end, you should see
... nopCommerce version 4.40.0. Update Data
... nopCommerce version 4.40.0. Update Localization
... nopCommerce version 4.40.0. Update Settings
SELECT [Version]
,[AppliedOn]
,[Description]
FROM [MigrationVersionInfo]
ORDER BY [Version]
Near the end, you should see
... nopCommerce version 4.40.0. Update Data
... nopCommerce version 4.40.0. Update Localization
... nopCommerce version 4.40.0. Update Settings
- 111
- 739
- 2/18/2015
- New Zealand
Thanks for your response , my return on this
a bit different from your return ?
Many thanks
SELECT *
FROM [db].[dbo].[MigrationVersionInfo]
ORDER BY [Version]
AppliedOn Description Version
2020-03-18 07:23:31.000 Nop.Data base schema 637160666562551771
2020-03-18 07:25:09.000 Shipping.FixedByWeightByTotal 637163160551687541
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
a bit different from your return ?
Many thanks
Certified Developer
- 17
- 166
- 1/10/2023
- India
prabirchoudhury wrote:
run the following query:
Thanks for your response , my return on this
a bit different from your return ?
Many thanks
SELECT *
FROM [db].[dbo].[MigrationVersionInfo]
ORDER BY [Version]
AppliedOn Description Version
2020-03-18 07:23:31.000 Nop.Data base schema 637160666562551771
2020-03-18 07:25:09.000 Shipping.FixedByWeightByTotal 637163160551687541
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
a bit different from your return ?
Many thanks
run the following query:
SELECT [Version]
,[AppliedOn]
,[Description]
FROM [MigrationVersionInfo]
ORDER BY [Version] desc
- 111
- 739
- 2/18/2015
- New Zealand
This query is not making any difference. output below., how do you find the current NOP version that I am having nop4.4
Many thanks
Version AppliedOn Description
637200411689037680 2020-03-18 07:23:32.000 AddOrderRewardPointsHistoryFK
637196977559280395 2020-04-30 13:53:20.000 AddCategoryDeletedExtendedIX
637196977559280394 2020-04-30 13:53:20.000 AddProductVisibleIndividuallyPublis
637196977559280393 2020-04-30 13:53:20.000 AddQueuedEmailSentOnUtcDontSendB
637196977559280392 2020-04-30 13:53:20.000 AddPSAMSpecificationAttributeOptio
637196977559280391 2020-04-30 13:53:20.000 AddPSAMAllowFilteringIX
637196977559280390 2020-04-30 13:53:20.000 AddPMMProductIdExtendedIX
Many thanks
MVP
Certified Developer
- 3948
- 35247
- 2/8/2010
- Australia
Yes that list is too short
Does the website run ?
I don't think the update has completed
You may need to turn on StdOut Error Logging
See https://selectsystems.com.au/checking-for-errors-on-a-new-installation-of-nopcommerce
Does the website run ?
I don't think the update has completed
You may need to turn on StdOut Error Logging
See https://selectsystems.com.au/checking-for-errors-on-a-new-installation-of-nopcommerce
- 111
- 739
- 2/18/2015
- New Zealand
Thanks for your response.
Still I am having the SDK error, I have installed the MS SDK 6.0
and my project file have got the line below
When I load the project in the Visual Studio 2019 it throws few errors below
https://i.postimg.cc/PJ60wN5X/dipendencies-error.jpg
https://i.postimg.cc/QtCQMMwk/error-list.jpg
Would be great to have any help
Still I am having the SDK error, I have installed the MS SDK 6.0
and my project file have got the line below
<PropertyGroup>
<TargetFramework>net6.0</TargetFramework>
When I load the project in the Visual Studio 2019 it throws few errors below
https://i.postimg.cc/PJ60wN5X/dipendencies-error.jpg
https://i.postimg.cc/QtCQMMwk/error-list.jpg
Would be great to have any help