Version 1.4.4 for nopCommerce 4.60

[iAlexeyProkhorov]

Changes:

• Add slider alignment support. Now slider related to some widget zone displays with alignment. Plugin supports: left side, centered and right side alignments.

Adds:

• localization values for enums;
• update method to install database changes;

Installation:

You need just upload this package into your nopCommerce and reload it. Plugin should automatically upgrade your database.

Possible issues

Plugin should be compatible with all nopCommerce 4.60.x versions. Feel free to write me, if you have some issues.

Have a nice day everyone 😉

---

This discussion was created from the release Version 1.4.4 for nopCommerce 4.60.

[RichJeffries]

Hi there!
I'm attempting to install this version on nopCommerce v4.60.4 as I want the ability to center the slides.
Trying to install the component is throwing the following error:
The plugin "Widgets.qBoSlider" not installed
Trace:
Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid column name 'SliderAlignmentId'.
at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at Microsoft.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction)
at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at Microsoft.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
at Microsoft.Data.SqlClient.SqlDataReader.get_MetaData()
at Microsoft.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
at Microsoft.Data.SqlClient.SqlCommand.CompleteAsyncExecuteReader(Boolean isInternal, Boolean forDescribeParameterEncryption)
at Microsoft.Data.SqlClient.SqlCommand.InternalEndExecuteReader(IAsyncResult asyncResult, Boolean isInternal, String endMethod)
at Microsoft.Data.SqlClient.SqlCommand.EndExecuteReaderInternal(IAsyncResult asyncResult)
at Microsoft.Data.SqlClient.SqlCommand.EndExecuteReaderAsync(IAsyncResult asyncResult)
at Microsoft.Data.SqlClient.SqlCommand.EndExecuteReaderAsyncCallback(IAsyncResult asyncResult)
at System.Threading.Tasks.TaskFactory1.FromAsyncCoreLogic(IAsyncResult iar, Func2 endFunction, Action1 endAction, Task1 promise, Boolean requiresSynchronization)
--- End of stack trace from previous location ---
at LinqToDB.Data.DataConnection.ExecuteScalarAsync(CancellationToken cancellationToken)
at LinqToDB.Data.DataConnection.ExecuteScalarDataAsync(CancellationToken cancellationToken)
at LinqToDB.Data.DataConnection.ExecuteScalarDataAsync(CancellationToken cancellationToken)
at LinqToDB.Data.DataConnection.QueryRunner.ExecuteScalarAsync(CancellationToken cancellationToken)
at LinqToDB.Linq.QueryRunner.ScalarQueryAsync(Query query, IDataContext dataContext, Expression expression, Object[] ps, Object[] preambles, CancellationToken cancellationToken)
at LinqToDB.Linq.QueryRunner.ScalarQueryAsync(Query query, IDataContext dataContext, Expression expression, Object[] ps, Object[] preambles, CancellationToken cancellationToken)
at LinqToDB.Linq.QueryRunner.InsertWithIdentity1.QueryAsync(IDataContext dataContext, T obj, InsertColumnFilter1 columnFilter, String tableName, String serverName, String databaseName, String schemaName, TableOptions tableOptions, CancellationToken token)
at LinqToDB.DataExtensions.InsertWithInt32IdentityAsync[T](IDataContext dataContext, T obj, InsertColumnFilter1 columnFilter, String tableName, String databaseName, String schemaName, String serverName, TableOptions tableOptions, CancellationToken token) at Nop.Data.DataProviders.BaseDataProvider.InsertEntityAsync[TEntity](TEntity entity) in S:\3D Printing\Company\Web\nopCommerce\nopCommerce_4.60.4_Source\src\Libraries\Nop.Data\DataProviders\BaseDataProvider.cs:line 279 at Nop.Data.EntityRepository1.InsertAsync(TEntity entity, Boolean publishEvent) in S:\3D Printing\Company\Web\nopCommerce\nopCommerce_4.60.4_Source\src\Libraries\Nop.Data\EntityRepository.cs:line 374
at Nop.Plugin.Widgets.qBoSlider.Service.WidgetZoneService.InsertWidgetZoneAsync(WidgetZone widgetZone) in P:\Baroque\Git\nopPlugins\nopCommerce_4.60.1_Source\Plugins\Nop.Plugin.Baroque.Widgets.qBoSlider\Service\WidgetZoneService.cs:line 147
at Nop.Plugin.Widgets.qBoSlider.qBoSliderPlugin.InstallAsync() in P:\Baroque\Git\nopPlugins\nopCommerce_4.60.1_Source\Plugins\Nop.Plugin.Baroque.Widgets.qBoSlider\qBoSliderPlugin.cs:line 216
at Nop.Services.Plugins.PluginService.InstallPluginsAsync() in S:\3D Printing\Company\Web\nopCommerce\nopCommerce_4.60.4_Source\src\Libraries\Nop.Services\Plugins\PluginService.cs:line 527
ClientConnectionId:c75cf469-9111-4f2a-b227-6cc0b3f5f68b
Error Number:207,State:1,Class:16

Thanks for your work!
Rich

[iAlexeyProkhorov]

Hi! Did you solve this issue?

…

________________________________ From: Rich Jeffries ***@***.***> Sent: Monday, September 18, 2023 12:39:30 AM To: iAlexeyProkhorov/qBoSlider ***@***.***> Cc: Alexey Prokhorov ***@***.***>; Author ***@***.***> Subject: Re: [iAlexeyProkhorov/qBoSlider] Version 1.4.4 for nopCommerce 4.60 (Discussion #19) Hi there! I'm attempting to install this version on nopCommerce v4.60.4 as I want the ability to center the slides. Trying to install the component is throwing the following error: The plugin "Widgets.qBoSlider" not installed Trace: Microsoft.Data.SqlClient.SqlException (0x80131904): Invalid column name 'SliderAlignmentId'. at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at Microsoft.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at Microsoft.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at Microsoft.Data.SqlClient.SqlDataReader.get_MetaData() at Microsoft.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at Microsoft.Data.SqlClient.SqlCommand.CompleteAsyncExecuteReader(Boolean isInternal, Boolean forDescribeParameterEncryption) at Microsoft.Data.SqlClient.SqlCommand.InternalEndExecuteReader(IAsyncResult asyncResult, Boolean isInternal, String endMethod) at Microsoft.Data.SqlClient.SqlCommand.EndExecuteReaderInternal(IAsyncResult asyncResult) at Microsoft.Data.SqlClient.SqlCommand.EndExecuteReaderAsync(IAsyncResult asyncResult) at Microsoft.Data.SqlClient.SqlCommand.EndExecuteReaderAsyncCallback(IAsyncResult asyncResult) at System.Threading.Tasks.TaskFactory1.FromAsyncCoreLogic(IAsyncResult iar, Func2 endFunction, Action1 endAction, Task1 promise, Boolean requiresSynchronization) --- End of stack trace from previous location --- at LinqToDB.Data.DataConnection.ExecuteScalarAsync(CancellationToken cancellationToken) at LinqToDB.Data.DataConnection.ExecuteScalarDataAsync(CancellationToken cancellationToken) at LinqToDB.Data.DataConnection.ExecuteScalarDataAsync(CancellationToken cancellationToken) at LinqToDB.Data.DataConnection.QueryRunner.ExecuteScalarAsync(CancellationToken cancellationToken) at LinqToDB.Linq.QueryRunner.ScalarQueryAsync(Query query, IDataContext dataContext, Expression expression, Object[] ps, Object[] preambles, CancellationToken cancellationToken) at LinqToDB.Linq.QueryRunner.ScalarQueryAsync(Query query, IDataContext dataContext, Expression expression, Object[] ps, Object[] preambles, CancellationToken cancellationToken) at LinqToDB.Linq.QueryRunner.InsertWithIdentity1.QueryAsync(IDataContext dataContext, T obj, InsertColumnFilter1 columnFilter, String tableName, String serverName, String databaseName, String schemaName, TableOptions tableOptions, CancellationToken token) at LinqToDB.DataExtensions.InsertWithInt32IdentityAsync[T](IDataContext dataContext, T obj, InsertColumnFilter1 columnFilter, String tableName, String databaseName, String schemaName, String serverName, TableOptions tableOptions, CancellationToken token) at Nop.Data.DataProviders.BaseDataProvider.InsertEntityAsync[TEntity](TEntity entity) in S:\3D Printing\Company\Web\nopCommerce\nopCommerce_4.60.4_Source\src\Libraries\Nop.Data\DataProviders\BaseDataProvider.cs:line 279 at Nop.Data.EntityRepository1.InsertAsync(TEntity entity, Boolean publishEvent) in S:\3D Printing\Company\Web\nopCommerce\nopCommerce_4.60.4_Source\src\Libraries\Nop.Data\EntityRepository.cs:line 374 at Nop.Plugin.Widgets.qBoSlider.Service.WidgetZoneService.InsertWidgetZoneAsync(WidgetZone widgetZone) in P:\Baroque\Git\nopPlugins\nopCommerce_4.60.1_Source\Plugins\Nop.Plugin.Baroque.Widgets.qBoSlider\Service\WidgetZoneService.cs:line 147 at Nop.Plugin.Widgets.qBoSlider.qBoSliderPlugin.InstallAsync() in P:\Baroque\Git\nopPlugins\nopCommerce_4.60.1_Source\Plugins\Nop.Plugin.Baroque.Widgets.qBoSlider\qBoSliderPlugin.cs:line 216 at Nop.Services.Plugins.PluginService.InstallPluginsAsync() in S:\3D Printing\Company\Web\nopCommerce\nopCommerce_4.60.4_Source\src\Libraries\Nop.Services\Plugins\PluginService.cs:line 527 ClientConnectionId:c75cf469-9111-4f2a-b227-6cc0b3f5f68b Error Number:207,State:1,Class:16 Thanks for your work! Rich — Reply to this email directly, view it on GitHub<#19 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/ANJUVSCE6GGYT6J46EVHCRTX25UZFANCNFSM6AAAAAA4X6R5X4>. You are receiving this because you authored the thread.Message ID: ***@***.***>

[RichJeffries]

I manually added the column to the database, so it may still be an issue.
I can only assume that the ef migration wasn't actually run.

[iAlexeyProkhorov]

Hi! Yes, looks like database migration wasn't initialized🤔

[RichJeffries]

At least you know! :-)

[iAlexeyProkhorov]

Hi! I checked this issue few times at my work PC. Unfortunately I can't restore issue. Plugin updates successfully from 1.4.3 to 1.4.4. If somebody has same issues -> please write me, create issues or discussions.