Installation on Windows 2019 Server Version 4.50 HTTP Error 500.30

Hi,
i tried to configure Nopcommerce 4.50 source compiled in Visual Studio 2022.
In localhost is ok but on server i retrieve:
HTTP Error 500.30

Unhandled exception. Autofac.Core.DependencyResolutionException: An exception was thrown while activating ?:Nop.Core.Domain.Common.CommonSettings.
---> System.Exception: No store could be loaded
   at Nop.Web.Framework.WebStoreContext.GetCurrentStore() in C:\\\\xxxxxxxxsrc\Presentation\Nop.Web.Framework\WebStoreContext.cs:line 104
   at Nop.Web.Framework.Infrastructure.NopStartup.<>c__DisplayClass0_0.<ConfigureServices>b__2(IServiceProvider serviceProvider) in C:\\\\xxxxxxxxsrc\Presentation\Nop.Web.Framework\Infrastructure\NopStartup.cs:line 244
   at Autofac.Extensions.DependencyInjection.AutofacRegistration.<>c__DisplayClass3_0.<Register>b__0(IComponentContext context, IEnumerable`1 parameters)
   at Autofac.Core.Activators.Delegate.DelegateActivator.ActivateInstance(IComponentContext context, IEnumerable`1 parameters)
   at Autofac.Core.Activators.Delegate.DelegateActivator.<ConfigurePipeline>b__2_0(ResolveRequestContext ctxt, Action`1 next)
   at Autofac.Core.Resolving.Middleware.DelegateMiddleware.Execute(ResolveRequestContext context, Action`1 next)
   at Autofac.Core.Resolving.Pipeline.ResolvePipelineBuilder.<>c__DisplayClass14_0.<BuildPipeline>b__1(ResolveRequestContext ctxt)
   at Autofac.Core.Resolving.Middleware.DisposalTrackingMiddleware.Execute(ResolveRequestContext context, Action`1 next)
   at Autofac.Core.Resolving.Pipeline.ResolvePipelineBuilder.<>c__DisplayClass14_0.<BuildPipeline>b__1(ResolveRequestContext ctxt)
   at Autofac.Core.Resolving.Middleware.ActivatorErrorHandlingMiddleware.Execute(ResolveRequestContext context, Action`1 next)
   --- End of inner exception stack trace ---
   at Autofac.Core.Resolving.Middleware.ActivatorErrorHandlingMiddleware.Execute(ResolveRequestContext context, Action`1 next)
   at Autofac.Core.Resolving.Pipeline.ResolvePipelineBuilder.<>c__DisplayClass14_0.<BuildPipeline>b__1(ResolveRequestContext ctxt)
   at Autofac.Core.Pipeline.ResolvePipeline.Invoke(ResolveRequestContext ctxt)
   at Autofac.Core.Resolving.Middleware.RegistrationPipelineInvokeMiddleware.Execute(ResolveRequestContext context, Action`1 next)
   at Autofac.Core.Resolving.Pipeline.ResolvePipelineBuilder.<>c__DisplayClass14_0.<BuildPipeline>b__1(ResolveRequestContext ctxt)
   at Autofac.Core.Resolving.Middleware.SharingMiddleware.<>c__DisplayClass5_0.<Execute>b__0()
   at Autofac.Core.Lifetime.LifetimeScope.CreateSharedInstance(Guid id, Func`1 creator)
   at Autofac.Core.Lifetime.LifetimeScope.CreateSharedInstance(Guid primaryId, Nullable`1 qualifyingId, Func`1 creator)
   at Autofac.Core.Resolving.Middleware.SharingMiddleware.Execute(ResolveRequestContext context, Action`1 next)
   at Autofac.Core.Resolving.Pipeline.ResolvePipelineBuilder.<>c__DisplayClass14_0.<BuildPipeline>b__1(ResolveRequestContext ctxt)
   at Autofac.Core.Resolving.Pipeline.ResolvePipelineBuilder.<>c__DisplayClass14_0.<BuildPipeline>b__1(ResolveRequestContext ctxt)
   at Autofac.Core.Resolving.Middleware.CircularDependencyDetectorMiddleware.Execute(ResolveRequestContext context, Action`1 next)
   at Autofac.Core.Resolving.Pipeline.ResolvePipelineBuilder.<>c__DisplayClass14_0.<BuildPipeline>b__1(ResolveRequestContext ctxt)
   at Autofac.Core.Pipeline.ResolvePipeline.Invoke(ResolveRequestContext ctxt)
   at Autofac.Core.Resolving.ResolveOperation.GetOrCreateInstance(ISharingLifetimeScope currentOperationScope, ResolveRequest request)
   at Autofac.Core.Resolving.ResolveOperation.ExecuteOperation(ResolveRequest request)
   at Autofac.Core.Resolving.ResolveOperation.Execute(ResolveRequest request)
   at Autofac.Core.Lifetime.LifetimeScope.ResolveComponent(ResolveRequest request)
   at Autofac.Core.Container.ResolveComponent(ResolveRequest request)
   at Autofac.ResolutionExtensions.TryResolveService(IComponentContext context, Service service, IEnumerable`1 parameters, Object& instance)
   at Autofac.ResolutionExtensions.ResolveOptionalService(IComponentContext context, Service service, IEnumerable`1 parameters)
   at Autofac.ResolutionExtensions.ResolveOptional(IComponentContext context, Type serviceType, IEnumerable`1 parameters)
   at Autofac.ResolutionExtensions.ResolveOptional(IComponentContext context, Type serviceType)
   at Autofac.Extensions.DependencyInjection.AutofacServiceProvider.GetService(Type serviceType)
   at Nop.Core.Infrastructure.NopEngine.Resolve(Type type, IServiceScope scope) in C:\\\\xxxxxxxxsrc\Libraries\Nop.Core\Infrastructure\NopEngine.cs:line 177
   at Nop.Core.Infrastructure.NopEngine.Resolve[T](IServiceScope scope) in C:\\\\xxxxxxxxsrc\Libraries\Nop.Core\Infrastructure\NopEngine.cs:line 166
   at Nop.Web.Framework.Infrastructure.Extensions.ApplicationBuilderExtensions.UseNopResponseCompression(IApplicationBuilder application) in C:\\\\xxxxxxxxsrc\Presentation\Nop.Web.Framework\Infrastructure\Extensions\ApplicationBuilderExtensions.cs:line 209
   at Nop.Web.Framework.Infrastructure.NopStaticFilesStartup.Configure(IApplicationBuilder application) in C:\\\\xxxxxxxxsrc\Presentation\Nop.Web.Framework\Infrastructure\NopStaticFilesStartup.cs:line 35
   at Nop.Core.Infrastructure.NopEngine.ConfigureRequestPipeline(IApplicationBuilder application) in C:\\\\xxxxxxxxsrc\Libraries\Nop.Core\Infrastructure\NopEngine.cs:line 154
   at Nop.Web.Framework.Infrastructure.Extensions.ApplicationBuilderExtensions.ConfigureRequestPipeline(IApplicationBuilder application) in C:\\\\xxxxxxxxsrc\Presentation\Nop.Web.Framework\Infrastructure\Extensions\ApplicationBuilderExtensions.cs:line 50
   at Program.<Main>$(String[] args) in C:\\\\xxxxxxxxsrc\Presentation\Nop.Web\Program.cs:line 19

Assuming you have a Store table in the database
- Are you using 4.50.1 ?
- What is the function you are trying to do when the error happens ?
- Did you do any customisation ?

Check your store table. Data may not inserted.
Check this post https://www.nopcommerce.com/en/boards/topic/31407/trouble-with-changing-the-database

Rashed Khan wrote:

Thank You Data is not inserted.

Hi,

check the web.config
Remove the dots if you don't use WebDav.
Bold in the text.

     <modules>
       <!-- Remove WebDAV module so that we can make DELETE requests -->
       <remove name="WebDAVModule" />
     </modules>
     <handlers>
       <!-- Remove WebDAV module so that we can make DELETE requests -->
       <remove name="WebDAV" />
       <add name="aspNetCore" path="*" verb="*" modules="AspNetCoreModuleV2" resourceType="Unspecified" />
     </handlers>

Best regards

I had a similar error

Unhandled exception. Autofac.Core.DependencyResolutionException: An exception was thrown while activating ?:Nop.Core.Domain.Common.CommonSettings.
---> Microsoft.Data.SqlClient.SqlException (0x80131904): A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.)
---> System.ComponentModel.Win32Exception (0x80090325): The certificate chain was issued by an authority that is not trusted.

I followed this post https://www.nopcommerce.com/en/boards/topic/93049/nopcommerce-450-is-released

Upgrade instructions. If you're upgrading nopCommerce to version 4.50 from one of the previous versions, please ensure that your connection string contains one of the following parameters: "Encrypt=false" or "TrustServerCertificate=True" (depending on your server requirements). You can manually add these parameters to your connection string in the \App_Data\appsettings.json file. This step is caused by the "Microsoft.Data.SqlClient" library that changed the default value of the "Encrypt" option from "false" to "true".

Which worked.

P.S. make sure there are no records in the ShoppingCartItem Table which caused this error
Unhandled exception. System.AggregateException: One or more errors occurred. (The value '0' is not a valid value for the enum 'ShippingSortingEnum'.)

Had to delete all the records for the table