1.8 to 4.0 upgrade Problems

This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.
5 years ago
While not my first rodeo..
(I have multiple sites running, all different versions)
I have upgraded a few to 4.0 with no issues.

I had one that had a very custom layout so I didn't want to upgrade till I had to and so I started the process.
Ran all the scripts..
First getting 2.0 fulling working..
Then just ran Scripts all the way up and including the 4.0 one.

Server is running other 4.0 sites so I know that is good.

Enabled logging and got this.

Application startup exception: System.TypeInitializationException: The type initializer for 'Nop.Services.Tasks.TaskThread' threw an exception. ---> System.Data.Entity.Core.EntityCommandExecutionException: An error occurred while executing the command definition. See the inner exception for details. ---> System.Data.SqlClient.SqlException: Invalid column name 'DefaultLanguageId'.
Invalid column name 'CompanyName'.
Invalid column name 'CompanyAddress'.
Invalid column name 'CompanyPhoneNumber'.
Invalid column name 'CompanyVat'.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.<Reader>b__c(DbCommand t, DbCommandInterceptionContext`1 c)
   at System.Data.Entity.Infrastructure.Interception.InternalDispatcher`1.Dispatch[TTarget,TInterceptionContext,TResult](TTarget target, Func`3 operation, TInterceptionContext interceptionContext, Action`3 executing, Action`3 executed)
   at System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.Reader(DbCommand command, DbCommandInterceptionContext interceptionContext)
   at System.Data.Entity.Internal.InterceptableDbCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior)
   --- End of inner exception stack trace ---
   at System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior)
   at System.Data.Entity.Core.Objects.Internal.ObjectQueryExecutionPlan.Execute[TResultType](ObjectContext context, ObjectParameterCollection parameterValues)
   at System.Data.Entity.Core.Objects.ObjectQuery`1.<>c__DisplayClass7.<GetResults>b__6()
   at System.Data.Entity.Core.Objects.ObjectContext.ExecuteInTransaction[T](Func`1 func, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction, Boolean releaseConnectionOnSuccess)
   at System.Data.Entity.Core.Objects.ObjectQuery`1.<>c__DisplayClass7.<GetResults>b__5()
   at System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.Execute[TResult](Func`1 operation)
   at System.Data.Entity.Core.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption)
   at System.Data.Entity.Core.Objects.ObjectQuery`1.<System.Collections.Generic.IEnumerable<T>.GetEnumerator>b__0()
   at System.Data.Entity.Internal.LazyEnumerator`1.MoveNext()
   at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
   at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
   at Nop.Services.Stores.StoreService.<GetAllStores>b__8_0() in E:\nopCommerce\downloads.nopcommerce.com\nopCommerce_4.00_Source\Libraries\Nop.Services\Stores\StoreService.cs:line 98
   at Nop.Services.Stores.StoreService.<>c__DisplayClass8_0.<GetAllStores>b__1() in E:\nopCommerce\downloads.nopcommerce.com\nopCommerce_4.00_Source\Libraries\Nop.Services\Stores\StoreService.cs:line 110
   at Nop.Core.Caching.CacheExtensions.Get[T](ICacheManager cacheManager, String key, Int32 cacheTime, Func`1 acquire) in E:\nopCommerce\downloads.nopcommerce.com\nopCommerce_4.00_Source\Libraries\Nop.Core\Caching\Extensions.cs:line 48
   at Nop.Services.Stores.StoreService.GetAllStores(Boolean loadCacheableCopy) in E:\nopCommerce\downloads.nopcommerce.com\nopCommerce_4.00_Source\Libraries\Nop.Services\Stores\StoreService.cs:line 107
   at Nop.Web.Framework.WebStoreContext.get_CurrentStore() in E:\nopCommerce\downloads.nopcommerce.com\nopCommerce_4.00_Source\Presentation\Nop.Web.Framework\WebStoreContext.cs:line 46
   at Nop.Services.Tasks.TaskThread..cctor() in E:\nopCommerce\downloads.nopcommerce.com\nopCommerce_4.00_Source\Libraries\Nop.Services\Tasks\TaskThread.cs:line 31
   --- End of inner exception stack trace ---
   at Nop.Services.Tasks.TaskThread..ctor()
   at Nop.Services.Tasks.TaskManager.Initialize() in E:\nopCommerce\downloads.nopcommerce.com\nopCommerce_4.00_Source\Libraries\Nop.Services\Tasks\TaskManager.cs:line 57
   at Nop.Web.Framework.Infrastructure.Extensions.ServiceCollectionExtensions.ConfigureApplicationServices(IServiceCollection services, IConfigurationRoot configuration) in E:\nopCommerce\downloads.nopcommerce.com\nopCommerce_4.00_Source\Presentation\Nop.Web.Framework\Infrastructure\Extensions\ServiceCollectionExtensions.cs:line 51
   at Nop.Web.Startup.ConfigureServices(IServiceCollection services) in E:\nopCommerce\downloads.nopcommerce.com\nopCommerce_4.00_Source\Presentation\Nop.Web\Startup.cs:line 44
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at Microsoft.AspNetCore.Hosting.ConventionBasedStartup.ConfigureServices(IServiceCollection services)
   at Microsoft.AspNetCore.Hosting.Internal.WebHost.EnsureApplicationServices()
   at Microsoft.AspNetCore.Hosting.Internal.WebHost.BuildApplication()
crit: Microsoft.AspNetCore.Hosting.Internal.WebHost[6]
      Application startup exception
System.TypeInitializationException: The type initializer for 'Nop.Services.Tasks.TaskThread' threw an exception. ---> System.Data.Entity.Core.EntityCommandExecutionException: An error occurred while executing the command definition. See the inner exception for details. ---> System.Data.SqlClient.SqlException: Invalid column name 'DefaultLanguageId'.
Invalid column name 'CompanyName'.
Invalid column name 'CompanyAddress'.
Invalid column name 'CompanyPhoneNumber'.
Invalid column name 'CompanyVat'.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.<Reader>b__c(DbCommand t, DbCommandInterceptionContext`1 c)
   at System.Data.Entity.Infrastructure.Interception.InternalDispatcher`1.Dispatch[TTarget,TInterceptionContext,TResult](TTarget target, Func`3 operation, TInterceptionContext interceptionContext, Action`3 executing, Action`3 executed)
   at System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.Reader(DbCommand command, DbCommandInterceptionContext interceptionContext)
   at System.Data.Entity.Internal.InterceptableDbCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior)
   --- End of inner exception stack trace ---
   at System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior)
   at System.Data.Entity.Core.Objects.Internal.ObjectQueryExecutionPlan.Execute[TResultType](ObjectContext context, ObjectParameterCollection parameterValues)
   at System.Data.Entity.Core.Objects.ObjectQuery`1.<>c__DisplayClass7.<GetResults>b__6()
   at System.Data.Entity.Core.Objects.ObjectContext.ExecuteInTransaction[T](Func`1 func, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction, Boolean releaseConnectionOnSuccess)
   at System.Data.Entity.Core.Objects.ObjectQuery`1.<>c__DisplayClass7.<GetResults>b__5()
   at System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.Execute[TResult](Func`1 operation)
   at System.Data.Entity.Core.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption)
   at System.Data.Entity.Core.Objects.ObjectQuery`1.<System.Collections.Generic.IEnumerable<T>.GetEnumerator>b__0()
   at System.Data.Entity.Internal.LazyEnumerator`1.MoveNext()
   at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
   at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
   at Nop.Services.Stores.StoreService.<GetAllStores>b__8_0() in E:\nopCommerce\downloads.nopcommerce.com\nopCommerce_4.00_Source\Libraries\Nop.Services\Stores\StoreService.cs:line 98
   at Nop.Services.Stores.StoreService.<>c__DisplayClass8_0.<GetAllStores>b__1() in E:\nopCommerce\downloads.nopcommerce.com\nopCommerce_4.00_Source\Libraries\Nop.Services\Stores\StoreService.cs:line 110
   at Nop.Core.Caching.CacheExtensions.Get[T](ICacheManager cacheManager, String key, Int32 cacheTime, Func`1 acquire) in E:\nopCommerce\downloads.nopcommerce.com\nopCommerce_4.00_Source\Libraries\Nop.Core\Caching\Extensions.cs:line 48
   at Nop.Services.Stores.StoreService.GetAllStores(Boolean loadCacheableCopy) in E:\nopCommerce\downloads.nopcommerce.com\nopCommerce_4.00_Source\Libraries\Nop.Services\Stores\StoreService.cs:line 107
   at Nop.Web.Framework.WebStoreContext.get_CurrentStore() in E:\nopCommerce\downloads.nopcommerce.com\nopCommerce_4.00_Source\Presentation\Nop.Web.Framework\WebStoreContext.cs:line 46
   at Nop.Services.Tasks.TaskThread..cctor() in E:\nopCommerce\downloads.nopcommerce.com\nopCommerce_4.00_Source\Libraries\Nop.Services\Tasks\TaskThread.cs:line 31
   --- End of inner exception stack trace ---
   at Nop.Services.Tasks.TaskThread..ctor()
   at Nop.Services.Tasks.TaskManager.Initialize() in E:\nopCommerce\downloads.nopcommerce.com\nopCommerce_4.00_Source\Libraries\Nop.Services\Tasks\TaskManager.cs:line 57
   at Nop.Web.Framework.Infrastructure.Extensions.ServiceCollectionExtensions.ConfigureApplicationServices(IServiceCollection services, IConfigurationRoot configuration) in E:\nopCommerce\downloads.nopcommerce.com\nopCommerce_4.00_Source\Presentation\Nop.Web.Framework\Infrastructure\Extensions\ServiceCollectionExtensions.cs:line 51
   at Nop.Web.Startup.ConfigureServices(IServiceCollection services) in E:\nopCommerce\downloads.nopcommerce.com\nopCommerce_4.00_Source\Presentation\Nop.Web\Startup.cs:line 44
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at Microsoft.AspNetCore.Hosting.ConventionBasedStartup.ConfigureServices(IServiceCollection services)
   at Microsoft.AspNetCore.Hosting.Internal.WebHost.EnsureApplicationServices()
   at Microsoft.AspNetCore.Hosting.Internal.WebHost.BuildApplication()
Hosting environment: Production
Content root path: C:\inetpub\wwwroot\www.scoutcoproducts.com
Now listening on: http://localhost:4138
Application started. Press Ctrl+C to shut down.
info: Microsoft.AspNetCore.Hosting.Internal.WebHost[1]
      Request starting HTTP/1.1 GET http://test.scoutcoproducts.com/  
info: Microsoft.AspNetCore.Hosting.Internal.WebHost[2]
      Request finished in 82.238ms 500 text/html; charset=utf-8
0
5 years ago
I added those fields from a working store and got a bit further.

Now I get the We're sorry, an internal error occurred.
message.

Log look like this now.

Hosting environment: Production
Content root path: C:\inetpub\wwwroot\www.scoutcoproducts.com
Now listening on: http://localhost:13170
Application started. Press Ctrl+C to shut down.
info: Microsoft.AspNetCore.Hosting.Internal.WebHost[1]
      Request starting HTTP/1.1 GET http://test.scoutcoproducts.com/  
fail: Microsoft.AspNetCore.Diagnostics.ExceptionHandlerMiddleware[0]
      An unhandled exception has occurred: An error occurred while executing the command definition. See the inner exception for details.
System.Data.Entity.Core.EntityCommandExecutionException: An error occurred while executing the command definition. See the inner exception for details. ---> System.Data.SqlClient.SqlException: Invalid column name 'EnablePasswordLifetime'.
Invalid column name 'PurchasedWithProductId'.


I'll keep looking for these fields.

But is there a step I missed.. I went though everything per what I saw..
I know I ran each script.
And I know 2.0 was working, as I could view the site.
0
This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.