Error Unhandled exception during checkout.

[ImmortalLogic]

We are using AbleCommerce 7.0.0 build 11659 and running into an intermittent issue with customers receiving a blank screen when they attempt to make a purchase through our store. The customer will enter all their information including credit card, sometimes more than once and they end up with a blank screen and no order #, and we only see that they have an abandoned basket with their email address.

The error is produced:

Error Unhandled exception during checkout. String or binary data would be truncated. The statement has been terminated.

Does anyone know what would cause this?

Thanks.

[jmestep]

That happens when something is supposed to be stored in the database that has more characters in it than the database field allow. Newer versions of Able have been patch to handle most of those instances.
One of the changes was to the global.asax file. They added the following

Code: Select all

protected void Session_OnStart()
    {
        //SAVE THE REFERRER FOR USE BY THE ORDER MODULE
        if (Request.UrlReferrer != null) Session["SessionReferrerUrl"] = StringHelper.Truncate(Request.UrlReferrer.ToString(), 255);
    }