I have 4.3 running, now I want to upgrade to 4.7

10 months ago
I learnt that from 4.4, nopcommerce is using ef migrations, so based on 4.3 database, there is already no upgrade scripts, I run the install directly and pointing to current 4.3 database, but the installation failed with error,  no column IsDeleted,
is there any script that I am missing,
10 months ago
Was you database customised ?
Turn on Stdout logs to get more information on the error
https://www.selectsystems.com.au/checking-for-errors-on-a-new-installation-of-nopcommerce
10 months ago
no, the database was created on 4.3 setup, it was not customized, but since I have run the new installation and failed in the middle, I'm not sure if the current table schemas have changed on the 4.3 database or it has rolled back, currently I'm hosting on Linux other than on a windows server, I set the configs in appsettings, is this logging config still the same?
10 months ago
The error stack trace,
8|nop4.7  | Unhandled exception.
8|nop4.7  | Autofac.Core.DependencyResolutionException: An exception was thrown while activating λ:Nop.Core.Domain.Common.CommonSettings.
8|nop4.7  |  ---> MySqlConnector.MySqlException (0x80004005): Unknown column 'entry_1.Deleted' in 'field list'
8|nop4.7  |    at MySqlConnector.Core.ResultSet.ReadResultSetHeaderAsync(IOBehavior ioBehavior) in /_/src/MySqlConnector/Core/ResultSet.cs:line 43
8|nop4.7  |    at MySqlConnector.MySqlDataReader.ActivateResultSet(CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 130
8|nop4.7  |    at MySqlConnector.MySqlDataReader.CreateAsync(CommandListPosition commandListPosition, ICommandPayloadCreator payloadCreator, IDictionary`2 cachedProcedures, IMySqlCommand command, CommandBehavior behavior, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 468
8|nop4.7  |    at MySqlConnector.Core.CommandExecutor.ExecuteReaderAsync(IReadOnlyList`1 commands, ICommandPayloadCreator payloadCreator, CommandBehavior behavior, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/CommandExecutor.cs:line 56
8|nop4.7  |    at MySqlConnector.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlCommand.cs:line 344
8|nop4.7  |    at MySqlConnector.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior) in /_/src/MySqlConnector/MySqlCommand.cs:line 278
8|nop4.7  |    at LinqToDB.Data.DataConnection.ExecuteReader(CommandBehavior commandBehavior)
8|nop4.7  |    at LinqToDB.Data.DataConnection.ExecuteDataReader(CommandBehavior commandBehavior)
8|nop4.7  |    at LinqToDB.Data.DataConnection.ExecuteReader()
8|nop4.7  |    at LinqToDB.Data.DataConnection.QueryRunner.ExecuteReader()
8|nop4.7  |    at LinqToDB.DataContext.QueryRunner.ExecuteReader()
8|nop4.7  |    at LinqToDB.Linq.QueryRunner.ExecuteQuery[T](Query query, IDataContext dataContext, Mapper`1 mapper, Expression expression, Object[] ps, Object[] preambles, Int32 queryNumber)+MoveNext()
8|nop4.7  |    at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
8|nop4.7  |    at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
8|nop4.7  |    at Nop.Data.EntityRepository`1.<>c__DisplayClass14_0.<GetAll>g__getAll|0() in /Users/shuntaochen/source/nopCommerce/src/Libraries/Nop.Data/EntityRepository.cs:line 282
8|nop4.7  |    at Nop.Core.Caching.MemoryCacheManager.<>c__DisplayClass10_0`1.<GetAsync>b__0() in /Users/shuntaochen/source/nopCommerce/src/Libraries/Nop.Core/Caching/MemoryCacheManager.cs:line 182
8|nop4.7  |    at System.Lazy`1.ViaFactory(LazyThreadSafetyMode mode)
8|nop4.7  |    at System.Lazy`1.ExecutionAndPublication(LazyHelper executionAndPublication, Boolean useDefaultConstructor)
8|nop4.7  |    at System.Lazy`1.CreateValue()
8|nop4.7  |    at Nop.Core.Caching.MemoryCacheManager.GetAsync[T](CacheKey key, Func`1 acquire) in /Users/shuntaochen/source/nopCommerce/src/Libraries/Nop.Core/Caching/MemoryCacheManager.cs:line 132
8|nop4.7  |    at Nop.Core.Caching.MemoryCacheManager.GetAsync[T](CacheKey key, Func`1 acquire) in /Users/shuntaochen/source/nopCommerce/src/Libraries/Nop.Core/Caching/MemoryCacheManager.cs:line 139
8|nop4.7  |    at Nop.Core.Caching.MemoryCacheManager.GetAsync[T](CacheKey key, Func`1 acquire) in /Users/shuntaochen/source/nopCommerce/src/Libraries/Nop.Core/Caching/MemoryCacheManager.cs:line 182
8|nop4.7  |    at Nop.Core.Caching.CachingExtensions.Get[T](IStaticCacheManager cacheManager, CacheKey key, Func`1 acquire) in /Users/shuntaochen/source/nopCommerce/src/Libraries/Nop.Core/Caching/CachingExtensions.cs:line 16
8|nop4.7  |    at Nop.Data.EntityRepository`1.GetEntities(Func`1 getAll, Func`2 getCacheKey) in /Users/shuntaochen/source/nopCommerce/src/Libraries/Nop.Data/EntityRepository.cs:line 74
8|nop4.7  |    at Nop.Data.EntityRepository`1.GetAll(Func`2 func, Func`2 getCacheKey, Boolean includeDeleted) in /Users/shuntaochen/source/nopCommerce/src/Libraries/Nop.Data/EntityRepository.cs:line 285
8|nop4.7  |    at Nop.Web.Framework.WebStoreContext.GetCurrentStore() in /Users/shuntaochen/source/nopCommerce/src/Presentation/Nop.Web.Framework/WebStoreContext.cs:line 90
8|nop4.7  |    at Nop.Web.Framework.Infrastructure.NopStartup.<>c__DisplayClass0_0.<ConfigureServices>b__0(IServiceProvider serviceProvider) in /Users/shuntaochen/source/nopCommerce/src/Presentation/Nop.Web.Framework/Infrastructure/NopStartup.cs:line 261
8|nop4.7  |    at Autofac.Extensions.DependencyInjection.AutofacRegistration.<>c__DisplayClass3_0.<Register>b__0(IComponentContext context, IEnumerable`1 parameters)
8|nop4.7  |    at Autofac.Core.Activators.Delegate.DelegateActivator.ActivateInstance(IComponentContext context, IEnumerable`1 parameters)
8|nop4.7  |    at Autofac.Core.Activators.Delegate.DelegateActivator.<ConfigurePipeline>b__2_0(ResolveRequestContext ctxt, Action`1 next)
8|nop4.7  |    at Autofac.Core.Resolving.Middleware.DelegateMiddleware.Execute(ResolveRequestContext context, Action`1 next)
8|nop4.7  |    at Autofac.Core.Resolving.Pipeline.ResolvePipelineBuilder.<>c__DisplayClass14_0.<BuildPipeline>b__1(ResolveRequestContext ctxt)
8|nop4.7  |    at Autofac.Core.Resolving.Middleware.DisposalTrackingMiddleware.Execute(ResolveRequestContext context, Action`1 next)
8|nop4.7  |    at Autofac.Core.Resolving.Pipeline.ResolvePipelineBuilder.<>c__DisplayClass14_0.<BuildPipeline>b__1(ResolveRequestContext ctxt)
8|nop4.7  |    at Autofac.Core.Resolving.Middleware.ActivatorErrorHandlingMiddleware.Execute(ResolveRequestContext context, Action`1 next)
8|nop4.7  |    --- End of inner exception stack trace ---
8|nop4.7  |    at Autofac.Core.Resolving.Middleware.ActivatorErrorHandlingMiddleware.Execute(ResolveRequestContext context, Action`1 next)
8|nop4.7  |    at Autofac.Core.Resolving.Pipeline.ResolvePipelineBuilder.<>c__DisplayClass14_0.<BuildPipeline>b__1(ResolveRequestContext ctxt)
8|nop4.7  |    at Autofac.Core.Pipeline.ResolvePipeline.Invoke(ResolveRequestContext ctxt)
8|nop4.7  |    at Autofac.Core.Resolving.Middleware.RegistrationPipelineInvokeMiddleware.Execute(ResolveRequestContext context, Action`1 next)
8|nop4.7  |    at Autofac.Core.Resolving.Pipeline.ResolvePipelineBuilder.<>c__DisplayClass14_0.<BuildPipeline>b__1(ResolveRequestContext ctxt)
8|nop4.7  |    at Autofac.Core.Resolving.Middleware.SharingMiddleware.<>c__DisplayClass5_0.<Execute>b__0()
8|nop4.7  |    at Autofac.Core.Lifetime.LifetimeScope.CreateSharedInstance(Guid id, Func`1 creator)
8|nop4.7  |    at Autofac.Core.Lifetime.LifetimeScope.CreateSharedInstance(Guid primaryId, Nullable`1 qualifyingId, Func`1 creator)
8|nop4.7  |    at Autofac.Core.Resolving.Middleware.SharingMiddleware.Execute(ResolveRequestContext context, Action`1 next)
8|nop4.7  |    at Autofac.Core.Resolving.Pipeline.ResolvePipelineBuilder.<>c__DisplayClass14_0.<BuildPipeline>b__1(ResolveRequestContext ctxt)
8|nop4.7  |    at Autofac.Core.Resolving.Pipeline.ResolvePipelineBuilder.<>c__DisplayClass14_0.<BuildPipeline>b__1(ResolveRequestContext ctxt)
8|nop4.7  |    at Autofac.Core.Resolving.Middleware.CircularDependencyDetectorMiddleware.Execute(ResolveRequestContext context, Action`1 next)
8|nop4.7  |    at Autofac.Core.Resolving.Pipeline.ResolvePipelineBuilder.<>c__DisplayClass14_0.<BuildPipeline>b__1(ResolveRequestContext ctxt)
8|nop4.7  |    at Autofac.Core.Pipeline.ResolvePipeline.Invoke(ResolveRequestContext ctxt)
8|nop4.7  |    at Autofac.Core.Resolving.ResolveOperation.GetOrCreateInstance(ISharingLifetimeScope currentOperationScope, ResolveRequest request)
8|nop4.7  |    at Autofac.Core.Resolving.ResolveOperation.ExecuteOperation(ResolveRequest request)
8|nop4.7  |    at Autofac.Core.Resolving.ResolveOperation.Execute(ResolveRequest request)
8|nop4.7  |    at Autofac.Core.Lifetime.LifetimeScope.ResolveComponent(ResolveRequest request)
8|nop4.7  |    at Autofac.Core.Container.ResolveComponent(ResolveRequest request)
8|nop4.7  |    at Autofac.ResolutionExtensions.TryResolveService(IComponentContext context, Service service, IEnumerable`1 parameters, Object& instance)
8|nop4.7  |    at Autofac.ResolutionExtensions.ResolveOptionalService(IComponentContext context, Service service, IEnumerable`1 parameters)
8|nop4.7  |    at Autofac.ResolutionExtensions.ResolveOptional(IComponentContext context, Type serviceType, IEnumerable`1 parameters)
8|nop4.7  |    at Autofac.ResolutionExtensions.ResolveOptional(IComponentContext context, Type serviceType)
8|nop4.7  |    at Autofac.Extensions.DependencyInjection.AutofacServiceProvider.GetService(Type serviceType)
8|nop4.7  |    at Nop.Core.Infrastructure.NopEngine.Resolve(Type type, IServiceScope scope) in /Users/shuntaochen/source/nopCommerce/src/Libraries/Nop.Core/Infrastructure/NopEngine.cs:line 174
8|nop4.7  |    at Nop.Core.Infrastructure.NopEngine.Resolve[T](IServiceScope scope) in /Users/shuntaochen/source/nopCommerce/src/Libraries/Nop.Core/Infrastructure/NopEngine.cs:line 163
8|nop4.7  |    at Nop.Web.Framework.Infrastructure.Extensions.ApplicationBuilderExtensions.UseNopResponseCompression(IApplicationBuilder application) in /Users/shuntaochen/source/nopCommerce/src/Presentation/Nop.Web.Framework/Infrastructure/Extensions/ApplicationBuilderExtensions.cs:line 210
8|nop4.7  |    at Nop.Web.Framework.Infrastructure.NopStaticFilesStartup.Configure(IApplicationBuilder application) in /Users/shuntaochen/source/nopCommerce/src/Presentation/Nop.Web.Framework/Infrastructure/NopStaticFilesStartup.cs:line 35
8|nop4.7  |    at Nop.Core.Infrastructure.NopEngine.ConfigureRequestPipeline(IApplicationBuilder application) in /Users/shuntaochen/source/nopCommerce/src/Libraries/Nop.Core/Infrastructure/NopEngine.cs:line 152
8|nop4.7  |    at Nop.Web.Framework.Infrastructure.Extensions.ApplicationBuilderExtensions.ConfigureRequestPipeline(IApplicationBuilder application) in /Users/shuntaochen/source/nopCommerce/src/Presentation/Nop.Web.Framework/Infrastructure/Extensions/ApplicationBuilderExtensions.cs:line 51
8|nop4.7  |    at Nop.Web.Program.Main(String[] args) in /Users/shuntaochen/source/nopCommerce/src/Presentation/Nop.Web/Program.cs:line 45
8|nop4.7  |    at Nop.Web.Program.<Main>(String[] args)
8|nop4.7  | Unhandled exception.
8|nop4.7  | Autofac.Core.DependencyResolutionException: An exception was thrown while activating λ:Nop.Core.Domain.Common.CommonSettings.
8|nop4.7  |  ---> MySqlConnector.MySqlException (0x80004005): Unknown column 'entry_1.Deleted' in 'field list'
8|nop4.7  |    at MySqlConnector.Core.ResultSet.ReadResultSetHeaderAsync(IOBehavior ioBehavior) in /_/src/MySqlConnector/Core/ResultSet.cs:line 43
8|nop4.7  |    at MySqlConnector.MySqlDataReader.ActivateResultSet(CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 130
8|nop4.7  |    at MySqlConnector.MySqlDataReader.CreateAsync(CommandListPosition commandListPosition, ICommandPayloadCreator payloadCreator, IDictionary`2 cachedProcedures, IMySqlCommand command, CommandBehavior behavior, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 468
8|nop4.7  |    at MySqlConnector.Core.CommandExecutor.ExecuteReaderAsync(IReadOnlyList`1 commands, ICommandPayloadCreator payloadCreator, CommandBehavior behavior, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/CommandExecutor.cs:line 56
8|nop4.7  |    at MySqlConnector.MySqlCommand.ExecuteReaderAsync(CommandBehavior behavior, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlCommand.cs:line 344
8|nop4.7  |    at MySqlConnector.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior) in /_/src/MySqlConnector/MySqlCommand.cs:line 278
8|nop4.7  |    at LinqToDB.Data.DataConnection.ExecuteReader(CommandBehavior commandBehavior)
8|nop4.7  |    at LinqToDB.Data.DataConnection.ExecuteDataReader(CommandBehavior commandBehavior)
8|nop4.7  |    at LinqToDB.Data.DataConnection.ExecuteReader()
8|nop4.7  |    at LinqToDB.Data.DataConnection.QueryRunner.ExecuteReader()
8|nop4.7  |    at LinqToDB.DataContext.QueryRunner.ExecuteReader()
8|nop4.7  |    at LinqToDB.Linq.QueryRunner.ExecuteQuery[T](Query query, IDataContext dataContext, Mapper`1 mapper, Expression expression, Object[] ps, Object[] preambles, Int32 queryNumber)+MoveNext()
8|nop4.7  |    at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
8|nop4.7  |    at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
8|nop4.7  |    at Nop.Data.EntityRepository`1.<>c__DisplayClass14_0.<GetAll>g__getAll|0() in /Users/shuntaochen/source/nopCommerce/src/Libraries/Nop.Data/EntityRepository.cs:line 282
8|nop4.7  |    at Nop.Core.Caching.MemoryCacheManager.<>c__DisplayClass10_0`1.<GetAsync>b__0() in /Users/shuntaochen/source/nopCommerce/src/Libraries/Nop.Core/Caching/MemoryCacheManager.cs:line 182
8|nop4.7  |    at System.Lazy`1.ViaFactory(LazyThreadSafetyMode mode)
8|nop4.7  |    at System.Lazy`1.ExecutionAndPublication(LazyHelper executionAndPublication, Boolean useDefaultConstructor)
8|nop4.7  |    at System.Lazy`1.CreateValue()
8|nop4.7  |    at Nop.Core.Caching.MemoryCacheManager.GetAsync[T](CacheKey key, Func`1 acquire) in /Users/shuntaochen/source/nopCommerce/src/Libraries/Nop.Core/Caching/MemoryCacheManager.cs:line 132
8|nop4.7  |    at Nop.Core.Caching.MemoryCacheManager.GetAsync[T](CacheKey key, Func`1 acquire) in /Users/shuntaochen/source/nopCommerce/src/Libraries/Nop.Core/Caching/MemoryCacheManager.cs:line 139
8|nop4.7  |    at Nop.Core.Caching.MemoryCacheManager.GetAsync[T](CacheKey key, Func`1 acquire) in /Users/shuntaochen/source/nopCommerce/src/Libraries/Nop.Core/Caching/MemoryCacheManager.cs:line 182
8|nop4.7  |    at Nop.Core.Caching.CachingExtensions.Get[T](IStaticCacheManager cacheManager, CacheKey key, Func`1 acquire) in /Users/shuntaochen/source/nopCommerce/src/Libraries/Nop.Core/Caching/CachingExtensions.cs:line 16
8|nop4.7  |    at Nop.Data.EntityRepository`1.GetEntities(Func`1 getAll, Func`2 getCacheKey) in /Users/shuntaochen/source/nopCommerce/src/Libraries/Nop.Data/EntityRepository.cs:line 74
8|nop4.7  |    at Nop.Data.EntityRepository`1.GetAll(Func`2 func, Func`2 getCacheKey, Boolean includeDeleted) in /Users/shuntaochen/source/nopCommerce/src/Libraries/Nop.Data/EntityRepository.cs:line 285
8|nop4.7  |    at Nop.Web.Framework.WebStoreContext.GetCurrentStore() in /Users/shuntaochen/source/nopCommerce/src/Presentation/Nop.Web.Framework/WebStoreContext.cs:line 90
8|nop4.7  |    at Nop.Web.Framework.Infrastructure.NopStartup.<>c__DisplayClass0_0.<ConfigureServices>b__0(IServiceProvider serviceProvider) in /Users/shuntaochen/source/nopCommerce/src/Presentation/Nop.Web.Framework/Infrastructure/NopStartup.cs:line 261
8|nop4.7  |    at Autofac.Extensions.DependencyInjection.AutofacRegistration.<>c__DisplayClass3_0.<Register>b__0(IComponentContext context, IEnumerable`1 parameters)
8|nop4.7  |    at Autofac.Core.Activators.Delegate.DelegateActivator.ActivateInstance(IComponentContext context, IEnumerable`1 parameters)
8|nop4.7  |    at Autofac.Core.Activators.Delegate.DelegateActivator.<ConfigurePipeline>b__2_0(ResolveRequestContext ctxt, Action`1 next)
8|nop4.7  |    at Autofac.Core.Resolving.Middleware.DelegateMiddleware.Execute(ResolveRequestContext context, Action`1 next)
8|nop4.7  |    at Autofac.Core.Resolving.Pipeline.ResolvePipelineBuilder.<>c__DisplayClass14_0.<BuildPipeline>b__1(ResolveRequestContext ctxt)
8|nop4.7  |    at Autofac.Core.Resolving.Middleware.DisposalTrackingMiddleware.Execute(ResolveRequestContext context, Action`1 next)
8|nop4.7  |    at Autofac.Core.Resolving.Pipeline.ResolvePipelineBuilder.<>c__DisplayClass14_0.<BuildPipeline>b__1(ResolveRequestContext ctxt)
8|nop4.7  |    at Autofac.Core.Resolving.Middleware.ActivatorErrorHandlingMiddleware.Execute(ResolveRequestContext context, Action`1 next)
8|nop4.7  |    --- End of inner exception stack trace ---
8|nop4.7  |    at Autofac.Core.Resolving.Middleware.ActivatorErrorHandlingMiddleware.Execute(ResolveRequestContext context, Action`1 next)
8|nop4.7  |    at Autofac.Core.Resolving.Pipeline.ResolvePipelineBuilder.<>c__DisplayClass14_0.<BuildPipeline>b__1(ResolveRequestContext ctxt)
8|nop4.7  |    at Autofac.Core.Pipeline.ResolvePipeline.Invoke(ResolveRequestContext ctxt)
8|nop4.7  |    at Autofac.Core.Resolving.Middleware.RegistrationPipelineInvokeMiddleware.Execute(ResolveRequestContext context, Action`1 next)
8|nop4.7  |    at Autofac.Core.Resolving.Pipeline.ResolvePipelineBuilder.<>c__DisplayClass14_0.<BuildPipeline>b__1(ResolveRequestContext ctxt)
8|nop4.7  |    at Autofac.Core.Resolving.Middleware.SharingMiddleware.<>c__DisplayClass5_0.<Execute>b__0()
8|nop4.7  |    at Autofac.Core.Lifetime.LifetimeScope.CreateSharedInstance(Guid id, Func`1 creator)
8|nop4.7  |    at Autofac.Core.Lifetime.LifetimeScope.CreateSharedInstance(Guid primaryId, Nullable`1 qualifyingId, Func`1 creator)
8|nop4.7  |    at Autofac.Core.Resolving.Middleware.SharingMiddleware.Execute(ResolveRequestContext context, Action`1 next)
8|nop4.7  |    at Autofac.Core.Resolving.Pipeline.ResolvePipelineBuilder.<>c__DisplayClass14_0.<BuildPipeline>b__1(ResolveRequestContext ctxt)
8|nop4.7  |    at Autofac.Core.Resolving.Pipeline.ResolvePipelineBuilder.<>c__DisplayClass14_0.<BuildPipeline>b__1(ResolveRequestContext ctxt)
8|nop4.7  |    at Autofac.Core.Resolving.Middleware.CircularDependencyDetectorMiddleware.Execute(ResolveRequestContext context, Action`1 next)
8|nop4.7  |    at Autofac.Core.Resolving.Pipeline.ResolvePipelineBuilder.<>c__DisplayClass14_0.<BuildPipeline>b__1(ResolveRequestContext ctxt)
8|nop4.7  |    at Autofac.Core.Pipeline.ResolvePipeline.Invoke(ResolveRequestContext ctxt)
8|nop4.7  |    at Autofac.Core.Resolving.ResolveOperation.GetOrCreateInstance(ISharingLifetimeScope currentOperationScope, ResolveRequest request)
8|nop4.7  |    at Autofac.Core.Resolving.ResolveOperation.ExecuteOperation(ResolveRequest request)
8|nop4.7  |    at Autofac.Core.Resolving.ResolveOperation.Execute(ResolveRequest request)
8|nop4.7  |    at Autofac.Core.Lifetime.LifetimeScope.ResolveComponent(ResolveRequest request)
8|nop4.7  |    at Autofac.Core.Container.ResolveComponent(ResolveRequest request)
8|nop4.7  |    at Autofac.ResolutionExtensions.TryResolveService(IComponentContext context, Service service, IEnumerable`1 parameters, Object& instance)
8|nop4.7  |    at Autofac.ResolutionExtensions.ResolveOptionalService(IComponentContext context, Service service, IEnumerable`1 parameters)
8|nop4.7  |    at Autofac.ResolutionExtensions.ResolveOptional(IComponentContext context, Type serviceType, IEnumerable`1 parameters)
8|nop4.7  |    at Autofac.ResolutionExtensions.ResolveOptional(IComponentContext context, Type serviceType)
8|nop4.7  |    at Autofac.Extensions.DependencyInjection.AutofacServiceProvider.GetService(Type serviceType)
8|nop4.7  |    at Nop.Core.Infrastructure.NopEngine.Resolve(Type type, IServiceScope scope) in /Users/shuntaochen/source/nopCommerce/src/Libraries/Nop.Core/Infrastructure/NopEngine.cs:line 174
8|nop4.7  |    at Nop.Core.Infrastructure.NopEngine.Resolve[T](IServiceScope scope) in /Users/shuntaochen/source/nopCommerce/src/Libraries/Nop.Core/Infrastructure/NopEngine.cs:line 163
8|nop4.7  |    at Nop.Web.Framework.Infrastructure.Extensions.ApplicationBuilderExtensions.UseNopResponseCompression(IApplicationBuilder application) in /Users/shuntaochen/source/nopCommerce/src/Presentation/Nop.Web.Framework/Infrastructure/Extensions/ApplicationBuilderExtensions.cs:line 210
8|nop4.7  |    at Nop.Web.Framework.Infrastructure.NopStaticFilesStartup.Configure(IApplicationBuilder application) in /Users/shuntaochen/source/nopCommerce/src/Presentation/Nop.Web.Framework/Infrastructure/NopStaticFilesStartup.cs:line 35
8|nop4.7  |    at Nop.Core.Infrastructure.NopEngine.ConfigureRequestPipeline(IApplicationBuilder application) in /Users/shuntaochen/source/nopCommerce/src/Libraries/Nop.Core/Infrastructure/NopEngine.cs:line 152
8|nop4.7  |    at Nop.Web.Framework.Infrastructure.Extensions.ApplicationBuilderExtensions.ConfigureRequestPipeline(IApplicationBuilder application) in /Users/shuntaochen/source/nopCommerce/src/Presentation/Nop.Web.Framework/Infrastructure/Extensions/ApplicationBuilderExtensions.cs:line 51
8|nop4.7  |    at Nop.Web.Program.Main(String[] args) in /Users/shuntaochen/source/nopCommerce/src/Presentation/Nop.Web/Program.cs:line 45
8|nop4.7  |    at Nop.Web.Program.<Main>(String[] args)
10 months ago
Is there any reason you are running v4.7 ?
v4.7 is in development so up until the point it is released there is no guarantee that it will work correctly or it will be compatible with previous versions.

v4.7 should be only used in development and I certainly would not be using it to update a production version if that is what you are doing.

I cant see what table the Deleted field is refering to ?
You are best to go back and try the released version v4.6 and see if get the same error