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

Thank you for verifying, I figured as much. Obviously, the workaround is to increase the length of the item that you're looking for.