After upgrade from v1.3 to v1.4 get the following on any product or category page:
Procedure or function Nop_ProductLoadAllPaged has too many arguments specified.
Stack Trace:
[SqlException (0x80131904): Procedure or function Nop_ProductLoadAllPaged has too many arguments specified.]
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.ConsumeMetaData() +33
System.Data.SqlClient.SqlDataReader.get_MetaData() +83
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) +954
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +162
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +32
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +141
System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +12
System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior) +10
Microsoft.Practices.EnterpriseLibrary.Data.Database.DoExecuteReader(DbCommand command, CommandBehavior cmdBehavior) +223
Microsoft.Practices.EnterpriseLibrary.Data.Database.ExecuteReader(DbCommand command) +244
NopSolutions.NopCommerce.DataAccess.Products.SQLProductProvider.GetAllProducts(Int32 CategoryID, Int32 ManufacturerID, Nullable`1 FeaturedProducts, Nullable`1 PriceMin, Nullable`1 PriceMax, String Keywords, Boolean SearchDescriptions, Int32 PageSize, Int32 PageIndex, List`1 FilteredSpecs, Boolean showHidden, Int32& TotalRecords) +1825
NopSolutions.NopCommerce.BusinessLogic.Products.ProductManager.GetAllProducts(Int32 CategoryID, Int32 ManufacturerID, Nullable`1 FeaturedProducts, Nullable`1 PriceMin, Nullable`1 PriceMax, String Keywords, Boolean SearchDescriptions, Int32 PageSize, Int32 PageIndex, List`1 FilteredSpecs, Int32& TotalRecords) +304
NopSolutions.NopCommerce.BusinessLogic.Products.ProductManager.GetAllProducts(Int32 CategoryID, Int32 ManufacturerID, Nullable`1 FeaturedProducts, Int32 PageSize, Int32 PageIndex, Int32& TotalRecords) +218
NopSolutions.NopCommerce.BusinessLogic.Categories.Category.get_FeaturedProducts() +102
NopSolutions.NopCommerce.Web.Templates.Categories.ProductsInLines1.BindData() +529
NopSolutions.NopCommerce.Web.Templates.Categories.ProductsInLines1.Page_Load(Object sender, EventArgs e) +80
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.OnLoad(EventArgs e) +99
System.Web.UI.Control.LoadRecursive() +50
System.Web.UI.Control.LoadRecursive() +141
System.Web.UI.Control.LoadRecursive() +141
System.Web.UI.Control.LoadRecursive() +141
System.Web.UI.Control.LoadRecursive() +141
System.Web.UI.Control.LoadRecursive() +141
System.Web.UI.Control.LoadRecursive() +141
System.Web.UI.Control.LoadRecursive() +141
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +627
I also get an IsTaxExempt error on the admin page:
IsTaxExempt
Stack Trace:
[IndexOutOfRangeException: IsTaxExempt]
System.Data.ProviderBase.FieldNameLookup.GetOrdinal(String fieldName) +4839010
System.Data.SqlClient.SqlDataReader.GetOrdinal(String name) +67
NopSolutions.NopCommerce.DataAccess.NopSqlDataHelper.GetBoolean(IDataReader rdr, String columnName) +57
NopSolutions.NopCommerce.DataAccess.CustomerManagement.SQLCustomerProvider.GetCustomerFromReader(IDataReader dataReader) +773
NopSolutions.NopCommerce.DataAccess.CustomerManagement.SQLCustomerProvider.GetCustomerByEmail(String Email) +223
NopSolutions.NopCommerce.BusinessLogic.CustomerManagement.CustomerManager.GetCustomerByEmail(String Email) +107
NopSolutions.NopCommerce.BusinessLogic.Profile.StoreMembershipProvider.ValidateUser(String username, String password) +164
System.Web.UI.WebControls.Login.AuthenticateUsingMembershipProvider(AuthenticateEventArgs e) +60
System.Web.UI.WebControls.Login.OnAuthenticate(AuthenticateEventArgs e) +119
System.Web.UI.WebControls.Login.AttemptLogin() +115
System.Web.UI.WebControls.Login.OnBubbleEvent(Object source, EventArgs e) +101
System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +37
System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e) +118
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +166
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +36
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1565
Ran the nopCommerce_upgrade.sql script on the server for v1.3 to v1.4, had lots of errors on the database update through SQL script.
