Upgrade from 3.7 to 3.8 error

I did this:

(1) Backup database and site.

(2) In IIS turn site off.

(3) Execute database upgrade script. (no errors)

(4) Make sure you have copy of App_Data\Settings.txt and App_Data\InstalledPlugins.txt and \Content\Images\

(5) Remove all files from site.

(6) Paste new site files into site folder.

(7) Copy back App_Data\Settings.txt and App_Data\InstalledPlugins.txt and \Content\Images\

(8) In IIS turn site back on.

In browser I see this error:

Server Error in '/' Application.

Runtime Error

Description: An exception occurred while processing your request. Additionally, another exception occurred while executing the custom error page for the first exception. The request has been terminated.
So I tried emptying InstalledPlugins.txt and restarting the site. No difference. This site did have the following plugins installed (and I don't mind losing data here and having to reinstall any of the plugins):

Widgets.NivoSlider
Payments.PayPalStandard
Payments.CheckMoneyOrder
Payments.PurchaseOrder
SevenSpikes.Core
SevenSpikes.Nop.Plugins.RealOnePageCheckout
Shipping.UPS
Widgets.NewsletterExtension
Product.QuickCart
Product.QuickFilter
Widgets.QuickFlexSlider
Widgets.QuickHtml
Widgets.QuickMenu
Widgets.QuickRibbons
Product.QuickView
Theme.Sport

When I turned the site back on after upgrade, and got the error above, I started removing plugins from this file, starting with "Theme.Sport", then the "SevenSpikes" stuff. Each time restarting in IIS. No change. Same error. The plugins folder right now is identical to pure 3.80 install files, with none of the extra stuff that was part of the site before, which I do have a backup of. Is there somewhere else, like in the database, I need to go to turn off plugins?

Thank you!

This is normally due to low-level, chained errors, there can be a few causes. Can you turn on detailed error (see http://stackoverflow.com/questions/2640526/detailed-500-error-message-asp-iis-7-5) and see if it generates any more info for debugging?

Yes! That did the trick! What can you make of this output?

Invalid column name 'LeasedByMachineName'.
Invalid column name 'LeasedUntilUtc'.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Invalid column name 'LeasedByMachineName'.
Invalid column name 'LeasedUntilUtc'.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:


[SqlException (0x80131904): Invalid column name 'LeasedByMachineName'.
Invalid column name 'LeasedUntilUtc'.]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +2442126
   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +5736904
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +628
   System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +3731
   System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() +58
   System.Data.SqlClient.SqlDataReader.get_MetaData() +89
   System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +379
   System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds, Boolean describeParameterEncryptionRequest) +2026
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) +375
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +53
   System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +240
   System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +41
   System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior) +12
   System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.<Reader>b__c(DbCommand t, DbCommandInterceptionContext`1 c) +9
   System.Data.Entity.Infrastructure.Interception.InternalDispatcher`1.Dispatch(TTarget target, Func`3 operation, TInterceptionContext interceptionContext, Action`3 executing, Action`3 executed) +72
   System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.Reader(DbCommand command, DbCommandInterceptionContext interceptionContext) +356
   System.Data.Entity.Internal.InterceptableDbCommand.ExecuteDbDataReader(CommandBehavior behavior) +166
   System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior) +12
   System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior) +37

[EntityCommandExecutionException: An error occurred while executing the command definition. See the inner exception for details.]
   System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior) +112
   System.Data.Entity.Core.Objects.Internal.ObjectQueryExecutionPlan.Execute(ObjectContext context, ObjectParameterCollection parameterValues) +743
   System.Data.Entity.Core.Objects.<>c__DisplayClass7.<GetResults>b__6() +97
   System.Data.Entity.Core.Objects.ObjectContext.ExecuteInTransaction(Func`1 func, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction, Boolean releaseConnectionOnSuccess) +288
   System.Data.Entity.Core.Objects.<>c__DisplayClass7.<GetResults>b__5() +155
   System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.Execute(Func`1 operation) +189
   System.Data.Entity.Core.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption) +280
   System.Data.Entity.Core.Objects.ObjectQuery`1.<System.Collections.Generic.IEnumerable<T>.GetEnumerator>b__0() +11
   System.Data.Entity.Internal.LazyEnumerator`1.MoveNext() +45
   System.Collections.Generic.List`1..ctor(IEnumerable`1 collection) +381
   System.Linq.Enumerable.ToList(IEnumerable`1 source) +58
   Nop.Services.Tasks.ScheduleTaskService.GetAllTasks(Boolean showHidden) +325
   Nop.Services.Tasks.TaskManager.Initialize() +78
   Nop.Web.MvcApplication.Application_Start() +268

[HttpException (0x80004005): An error occurred while executing the command definition. See the inner exception for details.]
   System.Web.HttpApplicationFactory.EnsureAppStartCalledForIntegratedMode(HttpContext context, HttpApplication app) +9959269
   System.Web.HttpApplication.RegisterEventSubscriptionsWithIIS(IntPtr appContext, HttpContext context, MethodInfo[] handlers) +118
   System.Web.HttpApplication.InitSpecial(HttpApplicationState state, MethodInfo[] handlers, IntPtr appContext, HttpContext context) +172
   System.Web.HttpApplicationFactory.GetSpecialApplicationInstance(IntPtr appContext, HttpContext context) +339
   System.Web.Hosting.PipelineRuntime.InitializeApplication(IntPtr appContext) +296

[HttpException (0x80004005): An error occurred while executing the command definition. See the inner exception for details.]
   System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +9940780
   System.Web.HttpRuntime.EnsureFirstRequestInit(HttpContext context) +90
   System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context) +261

It says "Invalid column name 'LeasedByMachineName'. Invalid column name 'LeasedUntilUtc'.", so it doesn't seem like your database is properly updated to 3.70. I would do the following:

1) Get a backup of 3.80 database (the lastest version that you can get)
2) Re-run the DB upgrade script

:)

I re-ran the 3.8 upgrade script.
Same error.
Wondering what tables those two problem fields are in?
It's slow going through every table trying to find those fields.
I'm considering deleting everything and doing a fresh install.

It's in ScheduleTask table. :)

OK I added those two fields to the ScheduleTask table.
Restarted the site.
New error: Invalid column name 'DefaultLanguageId'.
Now looking to find out which table this field should be in.
THANKS for all the help you are giving me!

OK that was in the store table. Field added.
Seems like I'm making progress.
The new error is this:

Invalid column name 'SubjectToAcl'.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Invalid column name 'SubjectToAcl'.

Source Error:

Line 8:      <div class="page-body">
Line 9:          @Html.Widget("home_page_top")
Line 10:         @Html.Action("TopicBlock", "Topic", new { systemName = "HomePageText" })
Line 11:         @Html.Widget("home_page_before_categories")
Line 12:         @Html.Action("HomepageCategories", "Catalog")

Source File: c:\inetpub\sites\aMonkeyMarket\site\Views\Home\Index.cshtml    Line: 10

It's strange that you do not have these fields, because these fields are not new in 3.80. (In fact, even LeasedByMachineName already exists in 3.70)

Agreed!
...and the 3.8 upgrade script wouldn't delete these fields?