#1
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
Topic Starter
  • fidley
  • Rank: YAF Forumling
  • Reputation:
    Neutral
    54.2%
  • Joined: 19/08/2009
  • Posts: 7
#2
Make sure "Full Text Search" if unselected in the Admin->Host Settings->Search settings.
  • Jaben
  • Rank: YAF Developer
  • Reputation:
    Exalted
    100%
  • Medals:
    Medal of Honor Key: Given to pillars of the community who are key players in the YAF community and project.YAF.NET Supporter: Loves YAF.NET!YAF.NET Supporter: Supports our efforts. Thank you.Medal of Honor for the Support King: Given to a community member who tirelessly answers tons of support questions.
  • Joined: 09/10/2004
  • Posts: 2,544
  • Location: United States
  • Thanks: 142 times
  • Was thanked: 352 time(s) in 195 post(s)
#3
It doesn't matter if I enable or disable "Full text search", i get same error for both.
Topic Starter
  • fidley
  • Rank: YAF Forumling
  • Reputation:
    Neutral
    54.2%
  • Joined: 19/08/2009
  • Posts: 7
#4
What text string are you searching for?
  • Jaben
  • Rank: YAF Developer
  • Reputation:
    Exalted
    100%
  • Medals:
    Medal of Honor Key: Given to pillars of the community who are key players in the YAF community and project.YAF.NET Supporter: Loves YAF.NET!YAF.NET Supporter: Supports our efforts. Thank you.Medal of Honor for the Support King: Given to a community member who tirelessly answers tons of support questions.
  • Joined: 09/10/2004
  • Posts: 2,544
  • Location: United States
  • Thanks: 142 times
  • Was thanked: 352 time(s) in 195 post(s)
#5
I'm searching for simple text "test" in all posts, in all forums.
Topic Starter
  • fidley
  • Rank: YAF Forumling
  • Reputation:
    Neutral
    54.2%
  • Joined: 19/08/2009
  • Posts: 7
#6
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
  • midwestSS
  • Rank: YAF MVP
  • Reputation:
    Exalted
    100%
  • Medals:
    Medal of Honor for Bug Finder: Given for kick-assery at finding bugs by being excellent at QA.Medal of Open Source Contributer: Given to someone who gets open source and gives back to the community.
  • Joined: 17/08/2008
  • Posts: 357
  • Thanks: 6 times
  • Was thanked: 9 time(s) in 8 post(s)
#7
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.
Topic Starter
  • fidley
  • Rank: YAF Forumling
  • Reputation:
    Neutral
    54.2%
  • Joined: 19/08/2009
  • Posts: 7
#8
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
Topic Starter
  • fidley
  • Rank: YAF Forumling
  • Reputation:
    Neutral
    54.2%
  • Joined: 19/08/2009
  • Posts: 7
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