Ajax filters not working, and I can't uninstall it

Hello, ajax filters are not working on my site, but they do on my test environment...
so, when I try to filter articles, it blocks the page and error says: "Loading the page failed."



I tried everything, set production database to test server, all settings are the same as on test server etc.

and I have tried to uninstall ajax filters plugin, but when I press uninstall in admin site, and restart application to apply changes, it makes nothing.

Any help? Thank you

which nopCommerce version are you using? plugin install / uninstall works peroperly? check from admim -> system -> log is there any error or not

mflac wrote:

Greetings,

Unfortunately, I'm not able to replicate the issue with our Ajax Plugin locally.

Please raise a ticket in our support system and provide us with more details including the version of nopCommerce you are using, as well as any error messages that you get in the system log when you try to uninstall Ajax Filters.

It is on NOP 4.40.3

log on oninstall:

System.Data.SqlClient.SqlException (0x80131904): Cannot find the object "dbo.Product_SpecificationAttribute_Mapping" because it does not exist or you do not have permissions.
   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.SqlCommand.EndExecuteNonQueryInternal(IAsyncResult asyncResult)
   at System.Data.SqlClient.SqlCommand.EndExecuteNonQuery(IAsyncResult asyncResult)
   at System.Threading.Tasks.TaskFactory`1.FromAsyncCoreLogic(IAsyncResult iar, Func`2 endFunction, Action`1 endAction, Task`1 promise, Boolean requiresSynchronization)
--- End of stack trace from previous location ---
   at LinqToDB.Data.DataConnection.ExecuteNonQueryAsync(CancellationToken cancellationToken)
   at LinqToDB.Data.CommandInfo.ExecuteAsync(CancellationToken cancellationToken)
   at Nop.Data.DataProviders.BaseDataProvider.ExecuteNonQueryAsync(String sql, DataParameter[] dataParameters) in D:\Razvoj - projekti\nopCommerce_4.40_Source\src\Libraries\Nop.Data\DataProviders\BaseDataProvider.cs:line 360
   at SevenSpikes.Nop.Plugins.AjaxFilters.Services.AjaxFiltersDatabaseService.ExecuteDropDatabaseScriptsAsync(Boolean dropSortFunction)
   at SevenSpikes.Nop.Plugins.AjaxFilters.Services.AjaxFiltersDatabaseService.RemoveDatabaseScriptsAsync()
   at SevenSpikes.Nop.Plugins.AjaxFilters.Infrastructure.AjaxFiltersPlugin.UninstallAdditionalSettingsAsync()
   at SevenSpikes.Nop.Framework.Plugin.BasePlugin7Spikes.UninstallAsync()
   at Nop.Services.Plugins.PluginService.UninstallPluginsAsync() in D:\Razvoj - projekti\nopCommerce_4.40_Source\src\Libraries\Nop.Services\Plugins\PluginService.cs:line 557
ClientConnectionId:6e70d196-d7d8-4e7f-8ab2-bd20b21d1341
Error Number:1088,State:12,Class:16

your  "Product_SpecificationAttribute_Mapping" table not created at the time of install. that's why you can not uninstall it. generate this table script from your working site db and import it to test db

That table exist in my database, but it is empty.

Here is log wich is writen when came to error with filter:

System.Data.SqlClient.SqlException (0x80131904): The EXECUTE permission was denied on the object 'ProductLoadAllPagedNopAjaxFilters', database 'H2Shopv4', schema 'dbo'.
   at System.Data.SqlClient.SqlConnection.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)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
   at LinqToDB.Data.DataConnection.ExecuteReader(CommandBehavior commandBehavior)
   at LinqToDB.Data.CommandInfo.Query[T]()
   at LinqToDB.Data.CommandInfo.QueryProc[T]()
   at Nop.Data.DataProviders.BaseDataProvider.QueryProcAsync[T](String procedureName, DataParameter[] parameters) in D:\Razvoj - projekti\nopCommerce_4.40_Source\src\Libraries\Nop.Data\DataProviders\BaseDataProvider.cs:line 380
   at Nop.Data.EntityRepository`1.EntityFromSqlAsync(String procedureName, DataParameter[] parameters) in D:\Razvoj - projekti\nopCommerce_4.40_Source\src\Libraries\Nop.Data\EntityRepository.cs:line 520
   at SevenSpikes.Nop.Plugins.AjaxFilters.Services.ProductServiceNopAjaxFilters.SearchProductsInternalAsync(IList`1 categoryIds, SpecificationFilterModelDTO specifiationFilterModelDTO, AttributeFilterModelDTO attributeFilterModelDTO, ManufacturerFilterModelDTO manufacturerFilterModelDTO, VendorFilterModelDTO vendorFilterModelDTO, Int32 pageIndex, Int32 pageSize, Int32 manufacturerId, Int32 vendorId, Int32 storeId, Nullable`1 featuredProducts, Nullable`1 priceMin, Nullable`1 priceMax, Int32 productTagId, String keywords, Boolean searchDescriptions, Boolean searchSku, Boolean searchProductTags, Int32 languageId, ProductSortingEnum orderBy, Boolean showHidden, Boolean onSale, Boolean inStock)
   at SevenSpikes.Nop.Plugins.AjaxFilters.Services.ProductServiceNopAjaxFilters.SearchProductsAsync(IList`1 categoryIds, SpecificationFilterModelDTO specifiationFilterModelDTO, AttributeFilterModelDTO attributeFilterModelDTO, ManufacturerFilterModelDTO manufacturerFilterModelDTO, VendorFilterModelDTO vendorFilterModelDTO, Int32 pageIndex, Int32 pageSize, Int32 manufacturerId, Int32 vendorId, Int32 storeId, Nullable`1 featuredProducts, Nullable`1 priceMin, Nullable`1 priceMax, Int32 productTagId, String keywords, Boolean searchDescriptions, Boolean searchSku, Boolean searchProductTags, Int32 languageId, ProductSortingEnum orderBy, Boolean showHidden, Boolean onSale, Boolean inStock)
   at SevenSpikes.Nop.Plugins.AjaxFilters.Controllers.Catalog7SpikesController.SearchProductsAsync()
   at SevenSpikes.Nop.Plugins.AjaxFilters.Controllers.Catalog7SpikesController.GetFilteredProductsInternalAsync(Int32 categoryId, Int32 manufacturerId, Int32 vendorId, PriceRangeFilterModel7Spikes priceRangeFilterModel7Spikes, SpecificationFilterModel7Spikes specificationFiltersModel7Spikes, AttributeFilterModel7Spikes attributeFiltersModel7Spikes, ManufacturerFilterModel7Spikes manufacturerFiltersModel7Spikes, VendorFilterModel7Spikes vendorFiltersModel7Spikes, CatalogProductsCommand pagingFilteringModel, OnSaleFilterModel7Spikes onSaleFilterModel, InStockFilterModel7Spikes inStockFilterModel, String queryString, Boolean shouldNotStartFromFirstPage, String keyword, Int32 searchCategoryId, Int32 searchManufacturerId, Int32 searchVendorId, Nullable`1 priceFrom, Nullable`1 priceTo, Boolean includeSubcategories, Boolean searchInProductDescriptions, Boolean advancedSearch, Boolean isOnSearchPage)
   at SevenSpikes.Nop.Plugins.AjaxFilters.Controllers.Catalog7SpikesController.GetFilteredProducts(GetFilteredProductsModel model)
   at lambda_method421784(Closure , Object )
   at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.TaskOfActionResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeActionMethodAsync>g__Awaited|12_0(ControllerActionInvoker invoker, ValueTask`1 actionResultValueTask)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeNextActionFilterAsync>g__Awaited|10_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeInnerFilterAsync>g__Awaited|13_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeNextResourceFilter>g__Awaited|24_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.Rethrow(ResourceExecutedContextSealed context)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeFilterPipelineAsync>g__Awaited|19_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeAsync>g__Logged|17_1(ResourceInvoker invoker)
   at Microsoft.AspNetCore.Routing.EndpointMiddleware.<Invoke>g__AwaitRequestTask|6_0(Endpoint endpoint, Task requestTask, ILogger logger)
   at WebMarkupMin.AspNetCore5.WebMarkupMinMiddleware.ProcessAsync(HttpContext context, Boolean useMinification, Boolean useCompression)
   at WebMarkupMin.AspNetCore5.WebMarkupMinMiddleware.ProcessAsync(HttpContext context, Boolean useMinification, Boolean useCompression)
   at WebMarkupMin.AspNetCore5.WebMarkupMinMiddlewareBase.Invoke(HttpContext context)
   at StackExchange.Profiling.MiniProfilerMiddleware.Invoke(HttpContext context) in C:\projects\dotnet\src\MiniProfiler.AspNetCore\MiniProfilerMiddleware.cs:line 125
   at Microsoft.AspNetCore.Authorization.AuthorizationMiddleware.Invoke(HttpContext context)
   at Nop.Services.Authentication.AuthenticationMiddleware.InvokeAsync(HttpContext context) in D:\Razvoj - projekti\nopCommerce_4.40_Source\src\Libraries\Nop.Services\Authentication\AuthenticationMiddleware.cs:line 94
   at Microsoft.AspNetCore.Routing.EndpointRoutingMiddleware.<Invoke>g__AwaitMatch|8_1(EndpointRoutingMiddleware middleware, HttpContext httpContext, Task matchTask)
   at Microsoft.AspNetCore.Localization.RequestLocalizationMiddleware.Invoke(HttpContext context)
   at Microsoft.AspNetCore.Session.SessionMiddleware.Invoke(HttpContext context)
   at Microsoft.AspNetCore.Session.SessionMiddleware.Invoke(HttpContext context)
   at Nop.Services.Installation.InstallUrlMiddleware.InvokeAsync(HttpContext context, IWebHelper webHelper) in D:\Razvoj - projekti\nopCommerce_4.40_Source\src\Libraries\Nop.Services\Installation\InstallUrlMiddleware.cs:line 53
   at Nop.Services.Common.KeepAliveMiddleware.InvokeAsync(HttpContext context, IWebHelper webHelper) in D:\Razvoj - projekti\nopCommerce_4.40_Source\src\Libraries\Nop.Services\Common\KeepAliveMiddleware.cs:line 50
   at Microsoft.AspNetCore.ResponseCompression.ResponseCompressionMiddleware.Invoke(HttpContext context)
   at Microsoft.AspNetCore.Diagnostics.StatusCodePagesMiddleware.Invoke(HttpContext context)
   at Microsoft.AspNetCore.Diagnostics.StatusCodePagesMiddleware.Invoke(HttpContext context)
   at Microsoft.AspNetCore.Diagnostics.ExceptionHandlerMiddleware.<Invoke>g__Awaited|6_0(ExceptionHandlerMiddleware middleware, HttpContext context, Task task)
ClientConnectionId:6e90ffb8-52a2-4db0-8f59-038fa89629c1
Error Number:229,State:5,Class:14

This started when we migrate from nop 4.3.0 to 4.4

As the issue raised after migrating from 4.3.0 to 4.4, then please check if your plugin version is compatible with 4.4 or not.
Another reason can be The EXECUTE permission was denied on the object 'ProductLoadAllPagedNopAjaxFilters', database 'H2Shopv4', schema 'dbo', which seems a permission issue. You can visit this link for more information https://stackoverflow.com/questions/3708348/the-execute-permission-was-denied-on-the-object-xxxxxxx-database-zzzzzzz-s
Finally, if nothing helps you, it will be better to take support from the plugin provider and remove installed files & tables manually according to their instructions.