fidley
  • Posts: 7
  • Joined: 19/08/2009
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:

Quote:


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
Sponsor
Jaben
  • Posts: 2544
  • Joined: 09/10/2004
Make sure "Full Text Search" if unselected in the Admin->Host Settings->Search settings.
fidley
  • Posts: 7
  • Joined: 19/08/2009
It doesn't matter if I enable or disable "Full text search", i get same error for both.
Jaben
  • Posts: 2544
  • Joined: 09/10/2004
What text string are you searching for?
fidley
  • Posts: 7
  • Joined: 19/08/2009
I'm searching for simple text "test" in all posts, in all forums.
midwestSS
  • Posts: 357
  • Joined: 17/08/2008
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
  • Posts: 7
  • Joined: 19/08/2009
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
  • Posts: 7
  • Joined: 19/08/2009
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
Forum Jump  
  • You cannot post new topics in this forum.
  • You cannot reply to topics in this forum.
  • You cannot delete your posts in this forum.
  • You cannot edit your posts in this forum.
  • You cannot create polls in this forum.
  • You cannot vote in polls in this forum.

About Us

The YAF.NET is an open source .NET forum project. YAF.NET is supported by an team of international developers who are build community by building community software.

Powered by Resharper Donate with PayPal button

Project Twitter Updates

Copyright © YetAnotherForum.NET & Ingo Herbote. All rights reserved