This update will cause single word matches with higher match counts to bubble to the top of the search results. This update will replace all previous search stored procedure updates.

In order to run this file you will need to run SQL Server Management Studio and open the file, then select the database you want to patch from the "Available Databases" drop down list. You can hit F5 to run the patch or click "Execute" on the menu.

We're getting these errors and had a total app crash after..it may be unrelated to the update or it may be because of the update. Marcus mentioned something about page caching in IIS previously, either way it may help others. I could not get the crash to repeat.

Using the homepage search which returned results. Once on the search page entering a new search term and hitting search. The app crashed, required moving the web config around to get it back up.

Event log errors:

Could not load file or assembly 'App_Web_qafxoydj, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null' or one of its dependencies. The system cannot find the file specified.[ at ASP.bvmodules_themes_ourname_controls_header_ascx.__BuildControlTree(bvmodules_themes_ourname_controls_header_ascx __ctrl) at ASP.bvmodules_themes_ourname_controls_header_ascx.FrameworkInitialize() at System.Web.UI.UserControl.InitializeAsUserControlInternal() at System.Web.UI.UserControl.InitializeAsUserControl(Page page) at ASP.bvmodules_themes_ourname_search_master.__BuildControlHeader1() at ASP.bvmodules_themes_ourname_search_master.__BuildControlform1() at ASP.bvmodules_themes_promomanagers_search_master.__BuildControlTree(bvmodules_themes_ourname_search_master __ctrl) at ASP.bvmodules_themes_ourname_search_master.FrameworkInitialize() at System.Web.UI.UserControl.InitializeAsUserControlInternal() at System.Web.UI.MasterPage.CreateMaster(TemplateControl owner, HttpContext context, VirtualPath masterPageFile, IDictionary contentTemplateCollection) at System.Web.UI.Page.get_Master() at System.Web.UI.Page.ApplyMasterPage() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) ]

We're also getting this from time to time, SQL Data Helper error:



Exception: System.Data.SqlClient.SqlException: 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 BVSoftware.Bvc5.Core.Datalayer.SqlDataHelper.ExecuteDataSet(DataRequest request, Int32 startRowIndex, Int32 maximumRows, Int32& rowCount)

If it's the association to the .NET temp files, forcing a recompile via the web.config won't be enough to clear the issue. You need to delete the .NET temporary files in the systems .NET tempfiles folder associated with the site.