When I try to search the KB by an ID, i get following error:

An unexpected error occurred within the application. If your the administrator of this site please contact InstantASP Ltd and provide your "ExceptionLog.config" file to assist with determining the cause of this problem. You can click here to go back to the knowledge base home page.

Error Message: Thread was being aborted.

The Error log on the server:

  <Exception>
    <Message>The column prefix 'Article' does not match with a table name or alias name used in the query.</Message>
    <Source>.Net SqlClient Data Provider</Source>
    <StackTrace>   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.FillFromCommand(Object data, 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, String srcTable)
   at InstantASP.InstantKB.Database.DataAccess.FullTextSearch(String strQuery, String strNodeID, String strArticleType, String strUsing, String strSearch, String strMaximumAge)</StackTrace>
    <AppPath>http://www.bridge-asp.ch/kb/</AppPath>
    <URI>/kb/search.aspx</URI>
    <DateTime>31.05.2006 14:42:20</DateTime>
  </Exception>
  <Exception>
    <Message>Thread was being aborted.</Message>
    <Source>InstantKB</Source>
    <StackTrace>   at InstantASP.InstantKB.Database.DataAccess.FullTextSearch(String strQuery, String strNodeID, String strArticleType, String strUsing, String strSearch, String strMaximumAge)
   at InstantKB.InstantKB_UserUserControlSearch.BindSearchResults()</StackTrace>
    <AppPath>http://www.bridge-asp.ch/kb/</AppPath>
    <URI>/kb/search.aspx</URI>
    <DateTime>31.05.2006 14:42:20</DateTime>
  </Exception>
</ExceptionLog>

Anyone any ideas??
Fulltext search is active and works fine.

Regards

Philippe

Dear Philippe,

Try running this sql script search fix I've attached to this post.

	Post Attachments
	ikb_sp_Search.zip (111 views, 3.53 KB)

I executet the script as you said, but now, i get another problem.
When I try to search for an ID that doesen't exists, the usual warning pops up, telling me that it doesent exist. So far so good, but if I type in an existing ID, I get following error:

ExceptionLog:

<Exception>
    <Message>Arithmetic operation resulted in an overflow.</Message>
    <Source>Microsoft.VisualBasic</Source>
    <StackTrace>   at Microsoft.VisualBasic.CompilerServices.IntegerType.FromString(String Value)
   at InstantKB.InstantKB_UserUserControlSearch.SearchGrid_ItemDataBound(Object Sender, DataGridItemEventArgs e)
   at System.Web.UI.WebControls.DataGrid.OnItemDataBound(DataGridItemEventArgs e)
   at System.Web.UI.WebControls.DataGrid.CreateItem(Int32 itemIndex, Int32 dataSourceIndex, ListItemType itemType, Boolean dataBind, Object dataItem, DataGridColumn[] columns, TableRowCollection rows, PagedDataSource pagedDataSource)
   at System.Web.UI.WebControls.DataGrid.CreateControlHierarchy(Boolean useDataSource)
   at System.Web.UI.WebControls.BaseDataList.OnDataBinding(EventArgs e)
   at System.Web.UI.WebControls.BaseDataList.DataBind()
   at InstantKB.InstantKB_UserUserControlSearch.BindSearchResults()</StackTrace>
    <AppPath>http://www.bridge-asp.ch/kb/</AppPath>
    <URI>/kb/search.aspx</URI>
    <DateTime>01.06.2006 09:12:15</DateTime>
  </Exception>

Any ideas?

Regards

Philippe