Upgrade to 4.3 Error

This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.
3 years ago
Just tried to the upgrade from 4.2 and this is the error I got and when I ran the upgrade script, it ran with no errors

An error occurred while starting the application.
SqlException: Invalid column name 'CustomClass'.
Invalid column name 'MobileBreakpoint'.
Invalid column name 'Arrows'.
Invalid column name 'Dots'.
Invalid column name 'Fade'.
Invalid column name 'Speed'.
Invalid column name 'AutoplaySpeed'.
Invalid column name 'Autoplay'.
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, bool breakConnection, Action<Action> wrapCloseInAction)

SqlException: Invalid column name 'CustomClass'. Invalid column name 'MobileBreakpoint'. Invalid column name 'Arrows'. Invalid column name 'Dots'. Invalid column name 'Fade'. Invalid column name 'Speed'. Invalid column name 'AutoplaySpeed'. Invalid column name 'Autoplay'.
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, bool breakConnection, Action<Action> wrapCloseInAction)
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, bool breakConnection, Action<Action> wrapCloseInAction)
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, bool callerHasConnectionLock, bool asyncClose)
System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, out bool dataReady)
System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
System.Data.SqlClient.SqlDataReader.get_MetaData()
System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, string resetOptionsString)
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, bool returnStream, bool async, int timeout, out Task task, bool asyncWrite, SqlDataReader ds)
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, bool returnStream, TaskCompletionSource<object> completion, int timeout, out Task task, bool asyncWrite, string method)
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, bool returnStream, string method)
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)
LinqToDB.Data.DbCommandProcessor.DbCommandProcessorExtensions.ExecuteReaderExt(IDbCommand cmd, CommandBehavior commandBehavior)
LinqToDB.Data.DataConnection.ExecuteReader(IDbCommand command, CommandBehavior commandBehavior)
LinqToDB.Data.DataConnection.ExecuteReader(CommandBehavior commandBehavior)
LinqToDB.Data.DataConnection+QueryRunner.ExecuteReader()
LinqToDB.DataContext+QueryRunner.ExecuteReader()
LinqToDB.Linq.QueryRunner.ExecuteQuery<T>(Query query, IDataContext dataContext, Mapper<T> mapper, Expression expression, object[] ps, int queryNumber)+MoveNext()
System.Collections.Generic.List<T>..ctor(IEnumerable<T> collection)
System.Linq.Enumerable.ToList<TSource>(IEnumerable<TSource> source)
SevenSpikes.Nop.Plugins.AnywhereSliders.Services.SliderService.GetAllSliders()
SevenSpikes.Nop.Plugins.AnywhereSliders.Data.Migrations.SlidersDataMigration.UpdateSlidersData()
SevenSpikes.Nop.Plugins.AnywhereSliders.Data.Migrations.SlidersDataMigration.Up()
FluentMigrator.MigrationBase.GetUpExpressions(IMigrationContext context)
FluentMigrator.Runner.MigrationRunner+<>c.<ApplyMigrationUp>b__69_0(IMigration m, IMigrationContext c)
FluentMigrator.Runner.MigrationRunner.ExecuteMigration(IMigration migration, Action<IMigration, IMigrationContext> getExpressions)
FluentMigrator.Runner.MigrationRunner.ApplyMigrationUp(IMigrationInfo migrationInfo, bool useTransaction)
FluentMigrator.Runner.MigrationRunner.MigrateUp(long targetVersion, bool useAutomaticTransactionManagement)
FluentMigrator.Runner.MigrationRunner.MigrateUp(long targetVersion)
Nop.Data.Migrations.MigrationManager.ApplyUpMigrations(Assembly assembly, bool isUpdateProcess) in MigrationManager.cs
Nop.Services.Plugins.PluginService.InsertPluginData(Type pluginType, bool isUpdateProcess) in PluginService.cs
Nop.Services.Plugins.PluginService.UpdatePlugins() in PluginService.cs
Nop.Web.Framework.Infrastructure.Extensions.ApplicationBuilderExtensions.StartEngine(IApplicationBuilder application) in ApplicationBuilderExtensions.cs
Nop.Web.Startup.Configure(IApplicationBuilder application) in Startup.cs
System.RuntimeMethodHandle.InvokeMethod(object target, object[] arguments, Signature sig, bool constructor, bool wrapExceptions)
System.Reflection.RuntimeMethodInfo.Invoke(object obj, BindingFlags invokeAttr, Binder binder, object[] parameters, CultureInfo culture)
Microsoft.AspNetCore.Hosting.ConfigureBuilder.Invoke(object instance, IApplicationBuilder builder)
Microsoft.AspNetCore.Hosting.ConfigureBuilder+<>c__DisplayClass4_0.<Build>b__0(IApplicationBuilder builder)
Microsoft.AspNetCore.Hosting.GenericWebHostBuilder+<>c__DisplayClass13_0.<UseStartup>b__2(IApplicationBuilder app)
Microsoft.AspNetCore.Mvc.Filters.MiddlewareFilterBuilderStartupFilter+<>c__DisplayClass0_0.<Configure>g__MiddlewareFilterBuilder|0(IApplicationBuilder builder)
Microsoft.AspNetCore.Server.IIS.Core.IISServerSetupFilter+<>c__DisplayClass2_0.<Configure>b__0(IApplicationBuilder app)
Microsoft.AspNetCore.HostFilteringStartupFilter+<>c__DisplayClass0_0.<Configure>b__0(IApplicationBuilder app)
Microsoft.AspNetCore.Hosting.GenericWebHostService.StartAsync(CancellationToken cancellationToken)
Microsoft.Extensions.Hosting.Internal.Host.StartAsync(CancellationToken cancellationToken)
Microsoft.Extensions.Hosting.HostingAbstractionsHostExtensions.RunAsync(IHost host, CancellationToken token)
Microsoft.Extensions.Hosting.HostingAbstractionsHostExtensions.RunAsync(IHost host, CancellationToken token)
Microsoft.Extensions.Hosting.HostingAbstractionsHostExtensions.Run(IHost host)
Nop.Web.Program.Main(string[] args) in Program.cs
3 years ago
So you are using the v4.3 code.
Might be something to do with the AnywhereSliders Plugin
Did you copy it in or did you install it correctly after you ran the website ?
Try taking it out
3 years ago
I forgot to run the sQL for anywhere sliders.  Now it works.   But I do notice that the 4.3 is not any faster than the 4.2 version.  Kind of disappointed.  Thank you for the advise
3 years ago
I am also having similar issue after installing pavilion theme. It uses anywhere slider. I believe the installation should handle implicitly such things internally.
Where can I get the sql to add these missing columns.
3 years ago
Maybe you could try contacting the developer for the plugins
This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.