search error in 1.9.3 · YAF.NET Support Forum

Welcome Guest! To enable all features please Login or Register

fidley
54.2% (Neutral)
YAF Forumling Topic Starter

15 years ago

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

Wanna join the discussion?! Login to your YAF.NET Support Forum forum account or Register a new forum account

Sponsor

Jaben
100% (Exalted)
YAF Developer

15 years ago

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

fidley
54.2% (Neutral)
YAF Forumling Topic Starter

15 years ago

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

Jaben
100% (Exalted)
YAF Developer

15 years ago

What text string are you searching for?

fidley
54.2% (Neutral)
YAF Forumling Topic Starter

15 years ago

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

midwestSS
100% (Exalted)
YAF MVP

15 years ago

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

fidley
54.2% (Neutral)
YAF Forumling Topic Starter

15 years ago

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.

fidley
54.2% (Neutral)
YAF Forumling Topic Starter

15 years ago

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

Important Information: