YAFLogo

Posted by: essej88 - Thursday, 14 October 2010 01:48:27
Hey guys on my YAF forum I am having issues with the search script engine. I am getting this error below when I enter any search and it is showing this instead of the results: System.Data.SqlClient.SqlException: Cannot use a CONTAINS or FREETEXT predicate on table or indexed view 'dbo.yaf_message' 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(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at YAF.Classes.Data.DBAccess.GetDatasetBasic(SqlCommand cmd, Boolean transaction) at YAF.Classes.Data.DBAccess.GetData(SqlCommand cmd, Boolean transaction) at YAF.Classes.Data.DB.GetSearchResult(String toSearchWhat, String toSearchFromWho, SearchWhatFlags searchFromWhoMethod, SearchWhatFlags searchWhatMethod, Int32 forumIDToStartAt, Int32 userID, Int32 boardId, Int32 maxResults, Boolean useFullText) at YAF.Pages.search.SearchBindData(Boolean newSearch) How can I go about fixing this and in what file would it be in Please help Jesse

Posted by: tommy382 - Thursday, 14 October 2010 01:51:46
In your SQL Server Management Studio, go to YAFDB-->Storage-->Fulltext Catalogs. Right click on YafSearch and select Rebuild. As always, backup your Database before making this change.

Posted by: Jaben - Thursday, 14 October 2010 13:37:02
If that doesn't work, re-run your installation and check "Attempt to Install FullText Search Support" when on the "Initialize/Upgrade Database" page. If it still doesn't work, best to turn off Full Text option in the Admin->Host Settings->Search