So anyway, here is the error I get, maybe someone can help me decipher it?
Code: Select all
Server Error in '/' Application.
Syntax error near 'poi' in the full-text search condition 'fire poi'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Syntax error near 'poi' in the full-text search condition 'fire poi'.
Source Error:
Line 48: {
Line 49: _HiddenPageIndex = AlwaysConvert.ToInt(HiddenPageIndex.Value);
Line 50: _SearchResultCount = ProductDataSource.NarrowSearchCount(_Keywords, this.CategoryId, _ManufacturerId, 0, 0);
Line 51: _LastPageIndex = ((int)Math.Ceiling(((double)_SearchResultCount / (double)_PageSize))) - 1;
Line 52: _PagingVarsInitialized = true;
Source File: d:\Internet\TrickConcepts.com\ConLib\Custom\SearchPage.ascx.cs Line: 50
Stack Trace:
[SqlException (0x80131904): Syntax error near 'poi' in the full-text search condition 'fire poi'.]
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +1950890
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +4846875
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +194
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2392
System.Data.SqlClient.SqlDataReader.HasMoreRows() +157
System.Data.SqlClient.SqlDataReader.ReadInternal(Boolean setTimeout) +197
System.Data.SqlClient.SqlDataReader.Read() +9
System.Data.SqlClient.SqlCommand.CompleteExecuteScalar(SqlDataReader ds, Boolean returnSqlValue) +50
System.Data.SqlClient.SqlCommand.ExecuteScalar() +150
Microsoft.Practices.EnterpriseLibrary.Data.Database.DoExecuteScalar(DbCommand command) +178
Microsoft.Practices.EnterpriseLibrary.Data.Database.ExecuteScalar(DbCommand command) +67
CommerceBuilder.Data.Database.ExecuteScalar(DbCommand command) +233
CommerceBuilder.Products.ProductDataSource.NarrowSearchCount(String keyword, Int32 categoryId, Int32 manufacturerId, LSDecimal lowPrice, LSDecimal highPrice, Boolean onlyFeatured) +3355
CommerceBuilder.Products.ProductDataSource.NarrowSearchCount(String keyword, Int32 categoryId, Int32 manufacturerId, LSDecimal lowPrice, LSDecimal highPrice) +65
ConLib_SearchPage.InitializePagingVars(Boolean forceRefresh) in d:\Internet\TrickConcepts.com\ConLib\Custom\SearchPage.ascx.cs:50
ConLib_SearchPage.SetPagerIndex() in d:\Internet\TrickConcepts.com\ConLib\Custom\SearchPage.ascx.cs:291
ConLib_SearchPage.RefreshCriteria() in d:\Internet\TrickConcepts.com\ConLib\Custom\SearchPage.ascx.cs:116
ConLib_SearchPage.Page_PreRender(Object sender, EventArgs e) in d:\Internet\TrickConcepts.com\ConLib\Custom\SearchPage.ascx.cs:304
System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +14
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +35
System.Web.UI.Control.OnPreRender(EventArgs e) +8686422
System.Web.UI.Control.PreRenderRecursiveInternal() +80
System.Web.UI.Control.PreRenderRecursiveInternal() +171
System.Web.UI.WebControls.WebParts.WebPart.PreRenderRecursiveInternal() +42
System.Web.UI.Control.PreRenderRecursiveInternal() +171
System.Web.UI.Control.PreRenderRecursiveInternal() +171
System.Web.UI.Control.PreRenderRecursiveInternal() +171
System.Web.UI.Control.PreRenderRecursiveInternal() +171
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +842