AbleCommerce Shopping Cart Software

This is one I haven't seen before:

Error 1: PayPal IPN transaction 19K54285PY147323W with a "CANCELED_REVERSAL" status was unhandled.
Error 2: PayPal IPN transaction 6UL67316D1561180V with a "CANCELED_REVERSAL" status was unhandled.
Error 3: Unhandled exception during checkout. Debug Data: Cannot insert the value NULL into column 'TotalCharges', table 'FireFold.dbo.ac_Orders'; column does not allow nulls. UPDATE fails. The statement has been terminated.

Maybe related to the new PayPal fix? Or maybe an old error I've never seen.

Robbie@FireFold wrote:Error 1: PayPal IPN transaction xxx with a "CANCELED_REVERSAL" status was unhandled.
Error 2: PayPal IPN transaction xxx with a "CANCELED_REVERSAL" status was unhandled.

If a charge gets reversed (e.g. disputed by customer) and then the reversal is cancelled (e.g. you win the dispute) our IPN processor is not handling the update. It requires manual intervention to get your AC order database in sync. Look up the paypal transaction to get the AC order number, then edit the AC order. Most likely, you need to see which payment was reversed, then edit it and set the status back to completed.

I think support for these were not added because it was difficult to replicate a testing scenario. I will add an enhancement request.

Robbie@FireFold wrote: Error 3: Unhandled exception during checkout. Debug Data: Cannot insert the value NULL into column 'TotalCharges', table 'FireFold.dbo.ac_Orders'; column does not allow nulls. UPDATE fails. The statement has been terminated.

That is an odd one. Did it come in at the same time as the other two errors?

They did come in at the same time.