AbleCommerce Shopping Cart Software

Thanks for the suggestion. The table was ac_OrderItems... A previous coder had changed the column to comply with an existing system's SeqNo column. I'm simply reseting the SeqNo when the backup occurs instead of allowing those large numbers to come through in the first place.

Thanks again!

I believe I have found my issue.... Looks like someone changed the data type of the OrderBy column from a smallint to an int, allowing the values in that column to exceed 32767 that is allowed for an 16 bit signed int in .Net. I'm just waiting now to be able to wipe this table and fix the data type....

Here is the trace.... RROR 2009-12-10 11:16:41,625 1225406ms Object a - An error occurred during the checkout process. The checkout has failed 100 times and will NOT BE attempted again. UserId: 621 / bwilliamson@blackstonemedia.net Customer: ben williamson / bwilliamson@blackstonemedia.net / System....

Hopefully someone on here can give me some guidance to get me on the right path.... I'm getting a cast exception during the Checkout method of the Basket object. The error is occurring during some internal sorting when Able is attempting to sort the OrderItems, unable to cast _something_ as an int. ...