Hello,
i've download YAF last week and i run it on Win2003R2 with framework 2 and Sql2005 express. Almost everything is working wright - almost means that i cannot run search. Everytime i get error message. I've tried to run it also on my local pc (XP + sql2008ex), but i get same error:

System.Data.SqlClient.SqlException: Incorrect syntax near '\'. 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) in c:\1\yetanotherforum.net\pages\search.ascx.cs:line 211

Can anybody tell if they had similar situation?

Thanks in advance
Fidley

Make sure "Full Text Search" if unselected in the Admin->Host Settings->Search settings.

It doesn't matter if I enable or disable "Full text search", i get same error for both.

What text string are you searching for?

I'm searching for simple text "test" in all posts, in all forums.

make sure your database has full text enabled.. i had that problem until i enabled that on the datbase, then turned it on with the install scripts from YAF

i will try, but on my local pc i have turned on full text search for database and selected "Attemp to install full text search support" on install script, but still i get the same error. I hope with server it will be different than my local pc.

there is no need to install full text support for that in sql server, i have recreted forum from the begining, together with database. During install i have check "Attemp to install full text search support" , ofc it didn't install FTS as there is no such service on server, but this time everything was ok with search from begining. I'm not sure what could be the reason of it, but finally it works.
Thanks for help