Server Error in '/' Application.

Cannot use a CONTAINS or FREETEXT predicate on table or indexed view 'KMC_Products' because it is not full-text indexed.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Cannot use a CONTAINS or FREETEXT predicate on table or indexed view 'KMC_Products' because it is not full-text indexed.

Source Error:


Line 80:                 cq.CurrentPage = 0
Line 81:                 cq.SearchKey = urlSearch
Line 82:                 Dim srchProducts = DBProduct.SearchProducts("", Nothing, cq)
Line 83:                 If (srchProducts.Count > 0) Then
Line 84:                     Dim tmpPtah = KobiMaster.WebUtil.GetProductListTemplatePath("") 'Default

Source File: C:\Domains\evyasam.com.tr\wwwroot\errorpages\404.ascx    Line: 82

Stack Trace:


[SqlException (0x80131904): Cannot use a CONTAINS or FREETEXT predicate on table or indexed view 'KMC_Products' because it is not full-text indexed.]
   System.Data.Linq.SqlClient.SqlProvider.Execute(Expression query, QueryInfo queryInfo, IObjectReaderFactory factory, Object[] parentArgs, Object[] userArgs, ICompiledSubQuery[] subQueries, Object lastResult) +3121
   System.Data.Linq.SqlClient.SqlProvider.ExecuteAll(Expression query, QueryInfo[] queryInfos, IObjectReaderFactory factory, Object[] userArguments, ICompiledSubQuery[] subQueries) +187
   System.Data.Linq.SqlClient.SqlProvider.System.Data.Linq.Provider.IProvider.Execute(Expression query) +410
   System.Data.Linq.DataQuery`1.System.Linq.IQueryProvider.Execute(Expression expression) +39
   KobiMaster.DataContext.Helper.DBProduct.SearchProducts(String Path, Nullable`1 CatalogID, ConstructedQuery CQuery) +322
   ASP.errorpages_404_ascx.Page_Load(Object sender, EventArgs e) in C:\Domains\evyasam.com.tr\wwwroot\errorpages\404.ascx:82
   System.Web.UI.Control.OnLoad(EventArgs e) +106
   System.Web.UI.Control.LoadRecursive() +68
   System.Web.UI.Control.LoadRecursive() +162
   System.Web.UI.Control.LoadRecursive() +162
   System.Web.UI.Control.LoadRecursive() +162
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3785


Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.7.4087.0