Hi
After applying the CS2008 Service Pack 1 the Shop no longer works. Bombing with the following error:
Must declare the scalar variable "@localRowsToReturn".
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: Must declare the scalar variable "@localRowsToReturn".
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. |
Stack Trace:
[SqlException (0x80131904): Must declare the scalar variable "@localRowsToReturn".]
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +925466
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +800118
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +186
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1932
System.Data.SqlClient.SqlDataReader.SetMetaData(_SqlMetaDataSet metaData, Boolean moreInfo) +126
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1623
System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +31
System.Data.SqlClient.SqlDataReader.get_MetaData() +62
System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +297
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +1005
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +132
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +32
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +122
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) +62
FourRoads.CsShop.SqlProvider.ShopSQLDataProvider.GetItems(ShopItemsQuery query, Int32 settingsID, DataReaderDelegate readerDelegate, BaseThreadQueryBuilder qb) +642
FourRoads.CsShop.SqlProvider.ShopSQLDataProvider.GetItems(ShopItemsQuery query, DataReaderDelegate readerDelegate) +72
FourRoads.CsShop.Core.Items.EnumerateShops(Int32 settingsID, Int32& currentItems) +208
FourRoads.CsShop.Core.Items.EnumerateSites(ICollection sites, Int32& currentItems) +101
FourRoads.CsShop.Core.Items.CurrentItemCount(Boolean useCache) +138
FourRoads.CsShop.Core.Items.HasExceededMaxLicensedItemCount(Boolean useCache) +85
FourRoads.CsShop.Core.Components.ShopPostCRUD.GetItems(ShopItemsQuery query, Boolean cacheable) +264
FourRoads.CsShop.Core.Components.ShopPostCRUD.GetItems(ShopItemsQuery query) +7
FourRoads.CsShop.Core.Controls.ItemList.get_DataSource() +384
System.Web.UI.WebControls.Repeater.ConnectToDataSourceView() +261
System.Web.UI.WebControls.Repeater.OnLoad(EventArgs e) +16
CommunityServer.Controls.PreTemplatedWrappedRepeaterBase.OnLoad(EventArgs e) +9
System.Web.UI.Control.LoadRecursive() +47
System.Web.UI.Control.LoadRecursive() +131
System.Web.UI.Control.LoadRecursive() +131
System.Web.UI.Control.LoadRecursive() +131
System.Web.UI.Control.LoadRecursive() +131
System.Web.UI.Control.LoadRecursive() +131
System.Web.UI.Control.LoadRecursive() +131
System.Web.UI.Control.LoadRecursive() +131
System.Web.UI.Control.LoadRecursive() +131
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1436
|
Have you experienced this error?