upgrade to 3.70

Just upgraded but now get this error - any idea

Server Error in '/' Application.




Invalid column name 'DataSourceEntityId'.
Invalid column name 'CarouselType'. 
  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 'DataSourceEntityId'.
Invalid column name 'CarouselType'.




Source Error: 












Line 3:  @foreach (var widget in Model)
Line 4:  {
Line 5:      @Html.Action(widget.ActionName, widget.ControllerName, widget.RouteValues)
Line 6:  }




  




 Source File:  d:\MyWebSites\Shop.AoFAQualifications.org\wwwroot\Views\Widget\WidgetsByZone.cshtml    Line:  5 




Stack Trace: 












[SqlException (0x80131904): Invalid column name 'DataSourceEntityId'.
Invalid column name 'CarouselType'.]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +388
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +815
   System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +4515
   System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() +69
   System.Data.SqlClient.SqlDataReader.get_MetaData() +134
   System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +6553981
   System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) +6556619
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) +586
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +104
   System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +288
   System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +171
   System.Data.Entity.Infrastructure.Interception.InternalDispatcher`1.Dispatch(TTarget target, Func`3 operation, TInterceptionContext interceptionContext, Action`3 executing, Action`3 executed) +208
   System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.Reader(DbCommand command, DbCommandInterceptionContext interceptionContext) +474
   System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior) +53




[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) +158
   System.Data.Entity.Core.Objects.Internal.ObjectQueryExecutionPlan.Execute(ObjectContext context, ObjectParameterCollection parameterValues) +1173
   System.Data.Entity.Core.Objects.ObjectContext.ExecuteInTransaction(Func`1 func, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction, Boolean releaseConnectionOnSuccess) +535
   System.Data.Entity.Core.Objects.<>c__DisplayClass7.<GetResults>b__5() +252
   System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.Execute(Func`1 operation) +275
   System.Data.Entity.Core.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption) +390
   System.Data.Entity.Core.Object

Did you run the upgrade scripts from 3.60 to 3.70 ? Please read the Theme upgrade.txt file in the Theme upgrade folder for detailed instructions how to upgrade.

Hope this helps!

Hi I'm getting this same error.  Theme upgrade.txt? Theme upgrade folder?  I have the current Tiffany Theme rar and I don't see either of these.  "Run upgrade scripts" from nopcommerce? yes I did, do you have upgrade scripts as well?  If so I don't see them in your download.

Thank you

Search folder for 7Spikes_upgrade.sql and run this -  it upgrades the database. Hope this helps.

Hi mmarxen,

When you download the theme zip package from our website, you will find 3.7 folder with the 3.7 version of the theme. Unzip it and you will find the Upgrade folder with the upgrade script from 3.6 to 3.7.
You can find all nopCommerce + our upgrade scripts in this file here.