Log in

Log in

x
Error in RamsdenProductList.ascx: System.Data.SqlClient.SqlException: Cannot use a CONTAINS or FREETEXT predicate on table or indexed view 'rms_ProductFlat' because it is not full-text indexed. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() 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) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader() at Ramsden.Common.RamsdenHelper.ExecuteXml(IDbCommand com) in C:\Subversion\Clients\ramsden-international\00121_Ramsden_site_rewrite\dev\Ramsden.Common\RamsdenHelper.cs:line 34 at Ramsden.Common.RamsdenProductListHelper.ModelProductList(ISession session, Person person, Language language, String listType, String productRangeId, String productCatId, String productSubCatId, String productId, Nullable`1 priceDate, String classificationIds, String priceMarked, String brandIds, String search, String rangeReviewCategories, String rangeReviewCounts, Int32 expandAll, String classificationIdsEx, String brandIdsEx, String selectedRangeId) in C:\Subversion\Clients\ramsden-international\00121_Ramsden_site_rewrite\dev\Ramsden.Common\RamsdenProductListHelper.cs:line 149 at Ramsden.Umbraco.UserControls.RamsdenProductList.Model() in C:\Subversion\Clients\ramsden-international\00121_Ramsden_site_rewrite\dev\Ramsden.Umbraco.UserControls\RamsdenProductList.ascx.cs:line 309 at Ramsden.Umbraco.UserControls.RamsdenProductList.Page_Load(Object sender, EventArgs e) in C:\Subversion\Clients\ramsden-international\00121_Ramsden_site_rewrite\dev\Ramsden.Umbraco.UserControls\RamsdenProductList.ascx.cs:line 102