At the conclusion of the order process, after the confirmation screen has shown and user clicks the "Close" button, they are successfully redirected to the url specified in the settings, however they're getting a "A critical error has occurred. Input string was not in a correct format." In the event log, here's what it's saying about the error:

AssemblyVersion: 5.4.2
PortalID: 1
PortalName: Shop Online at the Harvard General Store
UserID: 90
UserName: kenmrobbins
ActiveTabID: 193
ActiveTabName: Quarterdeck
RawURL: /ShopOnline/Quarterdeck/tabid/193/ctl/ConfirmStatus/mid/668/Default.aspx
AbsoluteURL: /Default.aspx
AbsoluteURLReferrer: https://harvardgeneralstore.com/ShopOnline/Quarterdeck/tabid/193/ctl/ConfirmStatus/mid/668/Default.aspx
UserAgent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10_6_3; en-US) AppleWebKit/533.4 (KHTML, like Gecko) Chrome/5.0.375.55 Safari/533.4
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: a220309f-c16a-4c3d-9d92-fc25eb46ac83
InnerException: Input string was not in a correct format.
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: System.Number.StringToNumber
StackTrace:
Message: DotNetNuke.Services.Exceptions.PageLoadException: Input string was not in a correct format. ---> System.FormatException: Input string was not in a correct format. at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal) at System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info) at Smith.DNN.Modules.BuyNow.ConfirmStatus.GetOrderDetails() at Smith.DNN.Modules.BuyNow.ConfirmStatus.SendEmail(CustomerInfo customer, UserInfo objUserInfo) at Smith.DNN.Modules.BuyNow.ConfirmStatus.Redirect() at Smith.DNN.Modules.BuyNow.ConfirmStatus.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: WEB18

---

Ken Robbins http://macoundesign.com

We are also getting the "Input string was not in a correct format" error when trying to print an invoice. We are running on DNN 5.4.1 and Smith Cart 2.86.0.

I've installed v2.90 and the same issue is present. Are we still looking at issues with upgrade installs? I was under the impression this was resolved many versions ago.

Ken

---

Ken Robbins http://macoundesign.com

On a fresh install of v2.90, using a fresh DNN 5.4.2 install, there's no error on the redirect, but the same error on the print invoice command.

---

Ken Robbins http://macoundesign.com

Invoice now shows, no error. Still have the error on the redirect on the upgrade install. Any thoughts?

---

Ken Robbins http://macoundesign.com

Ken,

To repair your current install you can try to copy the dlls and ascx files from v2.9 zip to the respective folders on your server. Then reset iis to make sure the cache is cleared and test. If that doesnt work then the issue is with one of your stored procedures being out of sync. Delete all your sprocs with a prefix of smith and then execute all the new sprocs in v2.9 from sql server mgmt studio.

---

At your service,
Dave Smith

In SQL Mgmt Studio from the view menu select object explorer details and all the sprocs with a prefix of smith should be sorted together, if they are not sorted then click "Name" in the title to sort them together. You can then highlight them all by clicking on the first one in the list then go to the last one and shift-click and they will all highlight. Then click delete.

---

At your service,
Dave Smith