We upgraded to the Shopping Cart, Version 2.72, to attempt to get the Special Instructions feature working as we have discussed above. We attempted to add an item to the shopping cart, and then when we clicked the Process Payment button to get to enter in Special Instructions on the payment process page, we got the error below...
A critical error has occurred.
Parameter count does not match Parameter Value count.
We went to the site log of the DNN site, and got this information below...
PortalName: Check Six
UserID: 1
UserName: host
ActiveTabID: 183
ActiveTabName: C6 Giveaways
RawURL: /C6Giveaways/tabid/183/ctl/Confirm/mid/694/Default.aspx
AbsoluteURL: /Default.aspx
AbsoluteURLReferrer: http://www.checksix.us/C6Giveaways/tabid/183/ctl/Confirm/mid/694/Default.aspx
UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.2) Gecko/20100316 Firefox/3.6.2 (.NET CLR 3.5.30729)
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: f1e16c44-a8f3-4b20-9d57-55da4755c891
InnerException: Parameter count does not match Parameter Value count.
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: Microsoft.ApplicationBlocks.Data.SqlHelper.AssignParameterValues
StackTrace:
Message: DotNetNuke.Services.Exceptions.PageLoadException: Parameter count does not match Parameter Value count. ---> System.ArgumentException: Parameter count does not match Parameter Value count. at Microsoft.ApplicationBlocks.Data.SqlHelper.AssignParameterValues(SqlParameter[] commandParameters, Object[] parameterValues) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, String spName, Object[] parameterValues) at Smith.DNN.Modules.BuyNow.SqlDataProvider.AddStoreOrders(Int32 customerID, DateTime orderDate, Int32 payHistID, Decimal ShippingTotal, Decimal TaxTotal, Decimal HandlingCharge, String ShipFirstName, String ShipLastName, String ShipAddress1, String ShipAddress2, String ShipCity, String ShipState, String ShipZipcode, String ShipCountry, String Status, String ShipMethod, String AffiliateId, Int32 couponId, Decimal discount, Decimal memberDiscount, String memberRole, String PDTextbox, Decimal Surcharge, Int32 portalId) at Smith.DNN.Modules.BuyNow.ProductsController.AddStoreOrders(StoreOrdersInfo objStoreOrders) at Smith.DNN.Modules.BuyNow.Confirm.AddStoreOrder(Int32 PayHistID, String orderStatus) at Smith.DNN.Modules.BuyNow.Confirm.ProcessStatus(PaymentStatusInfo status) at Smith.DNN.Modules.BuyNow.Confirm.Submit() at Smith.DNN.Modules.BuyNow.Confirm.btnSubmit_Click(Object sender, EventArgs e) at System.Web.UI.WebControls.Button.OnClick(EventArgs e) at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) --- End of inner exception stack trace ---
Source:
Server Name: GZSQL01
Do we need to create a whole new shopping cart or items due to the upgrade? Is there something we are not taking into consideration here?