Getting started. Installing and upgrading nopCommerce.

SagarKayasth wrote:
Thanks, in that case reinstalling plugin should auto populate configuration settings e.g. for facebook authentication it should populate app key.

by default, it will delete all records related to that plugin using this code

await _settingService.DeleteSettingAsync<FacebookExternalAuthSettings>();

as this code is written in Uninstall method

 public override async Task UninstallAsync()
        {
            //settings
            await _settingService.DeleteSettingAsync<FacebookExternalAuthSettings>();

            //locales
            await _localizationService.DeleteLocaleResourcesAsync("Plugins.ExternalAuth.Facebook");

            await base.UninstallAsync();
        }

so you need to comment on this section if you do not  need  to delete the configuration from the setting table

//await _settingService.DeleteSettingAsync<FacebookExternalAuthSettings>();

In general, when upgrading (especially when doing an upgrade of the database), you should not "re-install" your plugins.  Rather, you should just get the new versions of the plugin and just manually copy its files to the \Plugins\<ThePluginName> folders.   For "built-in" plugins, there's no need to do that manual copy, because the plugin folders will come with the nopCommerce version.  For 3rd party plugins, you should download their package, (unblock the .zip file ;), manually copy the correct version folder to your \Plugins folder.   Depending on what version you came from and how you set up new site, you probably also need to manually add those plugin names/versions to the "InstalledPlugins" section of the \App_Data\plugins.json file.

For a given 3rd party plugin, if in doubt, contact the vendor and ask then how to do an upgrade :)

So I am sure there is an easy to follow post about how to upgrade from V3.4 to V4.4. In fact, I've followed them and I still have one outstanding issue I need to resolve ASAP.

I has added some fields to the Address table and had made them mandatory in V3.4. Everything worked great.

In 4.4, I see the fields showing up, but even though they are specified as required, the required validation isn't working.

Can someone please point me to a way to take an existing DB filed from a previous version and make sure that the validation rules are corrected? If it can be specific to the Address model that would be awesome!

TIA,
Jon

Hi there
I currently run into the following error when I try to install nopCommerce 4.6 on my linux server.
It seems that nopCommerce tries to just run the migrations for 4.6 instead of creating the Database first. Anyone else ever had this issue? Locally everything works fine. Also nopCommerce created the MigrationHistory table in the new Database but there is no data inside.
Here is my log:

Jan 25 15:05:20 is-022f43 Nop.Web[1280067]: info: FluentMigrator.Runner.MigrationRunner[1000]
Jan 25 15:05:20 is-022f43 Nop.Web[1280067]:       StoreMigration migrating
Jan 25 15:05:20 is-022f43 Nop.Web[1280067]: info: FluentMigrator.Runner.Processors.SqlServer.SqlServer2016Processor[1004]
Jan 25 15:05:20 is-022f43 Nop.Web[1280067]:       Beginning Transaction
Jan 25 15:05:20 is-022f43 Nop.Web[1280067]: info: FluentMigrator.Runner.Processors.SqlServer.SqlServer2016Processor[1003]
Jan 25 15:05:20 is-022f43 Nop.Web[1280067]:       BEGIN TRANSACTION
Jan 25 15:05:20 is-022f43 Nop.Web[1280067]: info: FluentMigrator.Runner.MigrationRunner[1004]
Jan 25 15:05:20 is-022f43 Nop.Web[1280067]:       AlterTable Store
Jan 25 15:05:20 is-022f43 Nop.Web[1280067]: info: FluentMigrator.Runner.Processors.SqlServer.SqlServer2016Processor[1003]
Jan 25 15:05:20 is-022f43 Nop.Web[1280067]: info: FluentMigrator.Runner.MigrationRunner[1002]
Jan 25 15:05:20 is-022f43 Nop.Web[1280067]:       => 0.000643s
Jan 25 15:05:20 is-022f43 Nop.Web[1280067]: info: FluentMigrator.Runner.MigrationRunner[1004]
Jan 25 15:05:20 is-022f43 Nop.Web[1280067]:       CreateColumn Store Deleted Boolean
Jan 25 15:05:20 is-022f43 Nop.Web[1280067]: info: FluentMigrator.Runner.Processors.SqlServer.SqlServer2016Processor[1003]
Jan 25 15:05:20 is-022f43 Nop.Web[1280067]:       ALTER TABLE [dbo].[Store] ADD [Deleted] BIT NOT NULL CONSTRAINT [DF_Store_Deleted] DEFAULT 0
Jan 25 15:05:20 is-022f43 Nop.Web[1280067]: fail: FluentMigrator.Runner.MigrationRunner[0]
Jan 25 15:05:20 is-022f43 Nop.Web[1280067]:       An error occured executing the following sql:
Jan 25 15:05:20 is-022f43 Nop.Web[1280067]:       ALTER TABLE [dbo].[Store] ADD [Deleted] BIT NOT NULL CONSTRAINT [DF_Store_Deleted] DEFAULT 0
Jan 25 15:05:20 is-022f43 Nop.Web[1280067]:       The error was Cannot find the object "dbo.Store" because it does not exist or you do not have permissions.
Jan 25 15:05:20 is-022f43 Nop.Web[1280067]:
Jan 25 15:05:20 is-022f43 Nop.Web[1280067]:       System.Exception: An error occured executing the following sql:
Jan 25 15:05:20 is-022f43 Nop.Web[1280067]:       ALTER TABLE [dbo].[Store] ADD [Deleted] BIT NOT NULL CONSTRAINT [DF_Store_Deleted] DEFAULT 0
Jan 25 15:05:20 is-022f43 Nop.Web[1280067]:       The error was Cannot find the object "dbo.Store" because it does not exist or you do not have permissions.
Jan 25 15:05:20 is-022f43 Nop.Web[1280067]:
Jan 25 15:05:20 is-022f43 Nop.Web[1280067]:        ---> Microsoft.Data.SqlClient.SqlException (0x80131904): Cannot find the object "dbo.Store" because it does not exist or y                           ou do not have permissions.
Jan 25 15:05:20 is-022f43 Nop.Web[1280067]:          at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInA                           ction)
Jan 25 15:05:20 is-022f43 Nop.Web[1280067]:          at Microsoft.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrap                           CloseInAction)
Jan 25 15:05:20 is-022f43 Nop.Web[1280067]:          at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectio                           nLock, Boolean asyncClose)
Jan 25 15:05:20 is-022f43 Nop.Web[1280067]:          at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, B                           ulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
Jan 25 15:05:20 is-022f43 Nop.Web[1280067]:          at Microsoft.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean isAsync, Int32 timeout, Boolean                            asyncWrite)
Jan 25 15:05:20 is-022f43 Nop.Web[1280067]:          at Microsoft.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, Boolean sendToPipe, In                           t32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry, String methodName)
Jan 25 15:05:20 is-022f43 Nop.Web[1280067]:          at Microsoft.Data.SqlClient.SqlCommand.ExecuteNonQuery()
Jan 25 15:05:20 is-022f43 Nop.Web[1280067]:          at FluentMigrator.Runner.Processors.SqlServer.SqlServerProcessor.ExecuteNonQuery(String sql)
Jan 25 15:05:20 is-022f43 Nop.Web[1280067]:       ClientConnectionId:bdef6909-853b-4b6f-bece-966b74b3203b
Jan 25 15:05:20 is-022f43 Nop.Web[1280067]:       Error Number:4902,State:1,Class:16
Jan 25 15:05:20 is-022f43 Nop.Web[1280067]:          --- End of inner exception stack trace ---
Jan 25 15:05:20 is-022f43 Nop.Web[1280067]:          at FluentMigrator.Runner.Processors.ProcessorBase.ReThrowWithSql(Exception ex, String sql)
Jan 25 15:05:20 is-022f43 Nop.Web[1280067]:          at FluentMigrator.Runner.Processors.SqlServer.SqlServerProcessor.ExecuteNonQuery(String sql)
Jan 25 15:05:20 is-022f43 Nop.Web[1280067]:          at FluentMigrator.Runner.Processors.SqlServer.SqlServerProcessor.Process(String sql)
Jan 25 15:05:20 is-022f43 Nop.Web[1280067]:          at FluentMigrator.Runner.Processors.ProcessorBase.Process(CreateColumnExpression expression)
Jan 25 15:05:20 is-022f43 Nop.Web[1280067]:          at FluentMigrator.Expressions.CreateColumnExpression.ExecuteWith(IMigrationProcessor processor)
Jan 25 15:05:20 is-022f43 Nop.Web[1280067]:          at FluentMigrator.Runner.MigrationRunner.<>c__DisplayClass80_0.<ExecuteExpressions>b__1()
Jan 25 15:05:20 is-022f43 Nop.Web[1280067]:          at FluentMigrator.Runner.StopWatch.Time(Action action)
Jan 25 15:05:20 is-022f43 Nop.Web[1280067]:          at FluentMigrator.Runner.MigrationRunner.AnnounceTime(String message, Action action)
Jan 25 15:05:20 is-022f43 Nop.Web[1280067]:          at FluentMigrator.Runner.MigrationRunner.ExecuteExpressions(ICollection`1 expressions)
Jan 25 15:05:20 is-022f43 Nop.Web[1280067]: info: FluentMigrator.Runner.Processors.SqlServer.SqlServer2016Processor[1004]
Jan 25 15:05:20 is-022f43 Nop.Web[1280067]:       Rolling back transaction
Jan 25 15:05:20 is-022f43 Nop.Web[1280067]: info: FluentMigrator.Runner.Processors.SqlServer.SqlServer2016Processor[1003]
Jan 25 15:05:20 is-022f43 Nop.Web[1280067]:       ROLLBACK TRANSACTION

Intersim wrote:
If you are trying to do an "Install" (rather than an upgrade), then make sure you do not have these files in your \App_Data folder
appsettings.json
plugins.json

Has anyone had any success deploying NopCommerce on Azure App Service "Linux"? The steps provided in the NopCommerce documentation work for Azure App Service "Windows" but not App Service "Linux".

Hi
I have had my web-site clinch-it.co.uk hosted on Winserve for the last couple of years without issue but in December it stopped working.  Winserve Support came back a number of explanations none of which proved to be well founded.  In the end they told me I should upgrade from NopCommerce 4.3 to 4.6.  I tried this in-situ on their servers but this failed for no apparent reason so I took the decision to try installing on my local PC.  I backed up the database and restored it successfully to SQLEXPRESS and downloaded NopCommerce 4.6, I then overwrote the datasettings.json and plugins.json from my original installation.  I then edited the datasettings.json to point at my SQLExpress database.
I then created a new local website under IIS for Windows 10 and pointed it at where I had installed NopCommerce 4.6.  Running up the website I hit problems with my IIS configuration not having the correct modules installed as required in web.config - WebDAV & AspNetCoreModuleV2 - I installed them.
I finally got IIS to start up my locally installed web-site without errors but then when I try to access it via https://localhost:5002, IIS executes the web.config until it reaches the instruction: <aspNetCore requestTimeout="23:00:00" processPath=".\Nop.Web.exe" arguments="" forwardWindowsAuthToken="false" stdoutLogEnabled="false" stdoutLogFile=".\logs\stdout" startupTimeLimit="3600" hostingModel="InProcess"></aspNetCore>
Here is where I have come to a stop, getting the "HTTP Error 500.30 - ASP.NET Core app failed to start".  I found this in the Application Log:
Application '/LM/W3SVC/3/ROOT' with physical root 'C:\Users\howar_000\OneDrive\Documents\ClinchIT\Website\NopCommerce4.6\clinch-it.co.uk\' failed to load coreclr. Exception message:
CLR worker thread exited prematurely
Any help/advise gratefully received.

Have you installed the Hosting Bundle ?
From here https://dotnet.microsoft.com/en-us/download/dotnet/7.0

Also I always start the install and create a fresh database to test that all works OK
Then edit the appSettings later to point to the final proper database

Please check my this reply on a post. It might help you in understanding the issue. 500 status codes are normally due to two reasons, either you haven't installed correct dotnet to run website in IIS or there's permission issue on the website directory.

[email protected] wrote:

Please upvote my answer if it helps :)

Best regards,
Atul