logo
Welcome to our new AbleCommerce forums. As a guest, you may view the information here. To post to this forum, you must have a registered account with us, either as a new user evaluating AbleCommerce or an existing user of the application. For all questions related to the older version of Gold and earlier, please go to AbleCommerce Gold forum. Please use your AbleCommerce username and password to Login. New Registrations are disabled.

Notification

Icon
Error

Options
Go to last post Go to first unread
ray22901031  
#1 Posted : Friday, September 10, 2021 10:56:50 PM(UTC)
ray22901031

Rank: Advanced Member

Groups: Authorized User, Developers
Joined: 2/17/2019(UTC)
Posts: 826

Thanks: 3 times
Was thanked: 13 time(s) in 13 post(s)
Version 9.0.4, done this a million times, trying to create a kit and when trying to add an existing product, the product does not show up in the search and the following message gets displayed.

I suspect this is because we have changed the SQL search to Full-Text search and it's looking for more characters in the search? Please confirm - thanks


An error has occured at https://rfl01/Admin/Product/SearchPanelToAddKitProduct?Length=7 View less
Exception: Object reference not set to an instance of an object. Stack Trace: at CommerceBuilder.Search.Providers.SqlFtsSearchProvider.FindProducts(String name, Boolean searchDescription, String sku, Int32 categoryId, Int32 manufacturerId, Int32 vendorId, Int32 wrapGroupId, BitFieldState featured, Int32 taxCodeId, Decimal lowPrice, Decimal highPrice, Boolean digitalGoodsOnly, Boolean giftCertificatesOnly, Boolean kitsOnly, Boolean subscriptionsOnly, Int32 groupId, Nullable`1 visibility, String sortExpression, Int32 maximumRows, Int32 startRowIndex) at CommerceBuilder.Products.ProductRepository.FindProducts(String name, Boolean searchDescription, String sku, Int32 categoryId, Int32 manufacturerId, Int32 vendorId, BitFieldState featured, Int32 taxCodeId, Decimal lowPrice, Decimal highPrice, Boolean digitalGoodsOnly, Boolean giftCertificatesOnly, Boolean kitsOnly, Boolean subscriptionsOnly, Int32 groupId, Nullable`1 visibility, String sortExpression, Int32 maximumRows, Int32 startRowIndex) at AbleCommerce.Areas.Admin.Controllers.ProductController.ListProductsToAddKitProduct(Int32 KitComponentId, String modelData, String sortExpression, Int32 page, Int32 pageSize) in D:\Users\Ray\Documents\Visual Studio Projects\01-Projects\Able-RFL-9.0.4-b-083121\Website\Areas\Admin\Controllers\ProductController.cs:line 4132 at AbleCommerce.Areas.Admin.Controllers.ProductController.SearchPanelToAddKitProduct(ProductsModel productsModel) in D:\Users\Ray\Documents\Visual Studio Projects\01-Projects\Able-RFL-9.0.4-b-083121\Website\Areas\Admin\Controllers\ProductController.cs:line 4096 at lambda_method(Closure , ControllerBase , Object[] ) at System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext, IDictionary`2 parameters) at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary`2 parameters) at System.Web.Mvc.Async.AsyncControllerActionInvoker.b__39(IAsyncResult asyncResult, ActionInvocation innerInvokeState) at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncResult`2.CallEndDelegate(IAsyncResult asyncResult) at System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethod(IAsyncResult asyncResult) at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.b__3d() at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<>c__DisplayClass46.b__3f() at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<>c__DisplayClass46.b__3f() at System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethodWithFilters(IAsyncResult asyncResult) at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass21.<>c__DisplayClass2b.b__1c() at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass21.b__1e(IAsyncResult asyncResult) at System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeAction(IAsyncResult asyncResult) at System.Web.Mvc.Controller.b__1d(IAsyncResult asyncResult, ExecuteCoreState innerState) at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncVoid`1.CallEndDelegate(IAsyncResult asyncResult) at System.Web.Mvc.Controller.EndExecuteCore(IAsyncResult asyncResult) at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncVoid`1.CallEndDelegate(IAsyncResult asyncResult) at System.Web.Mvc.Controller.EndExecute(IAsyncResult asyncResult) at System.Web.Mvc.MvcHandler.b__5(IAsyncResult asyncResult, ProcessRequestState innerState) at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncVoid`1.CallEndDelegate(IAsyncResult asyncResult) at System.Web.Mvc.MvcHandler.EndProcessRequest(IAsyncResult asyncResult) at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step) at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

Edited by user Friday, September 10, 2021 11:07:46 PM(UTC)  | Reason: Not specified

Wanna join the discussion?! Login to your AbleCommerce Forums forum account. New Registrations are disabled.

shaharyar  
#2 Posted : Thursday, September 16, 2021 2:14:24 AM(UTC)
shaharyar

Rank: Advanced Member

Groups: Admin, Developers, Registered, HelpDesk, Authorized User
Joined: 10/5/2018(UTC)
Posts: 703

Thanks: 5 times
Was thanked: 113 time(s) in 112 post(s)
I am able to reproduce the issue. This is because of FTS when enabled.

I am going to register this issue. Thanks for pointing this out.
ray22901031  
#3 Posted : Thursday, September 16, 2021 8:06:37 AM(UTC)
ray22901031

Rank: Advanced Member

Groups: Authorized User, Developers
Joined: 2/17/2019(UTC)
Posts: 826

Thanks: 3 times
Was thanked: 13 time(s) in 13 post(s)
Thank you for verifying, I figured as much. Obviously, the workaround is to increase the length of the item that you're looking for.
Users browsing this topic
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.