Cannot insert Null error during checkout process

For general questions and discussions specific to the AbleCommerce 7.0 Asp.Net product.
Post Reply
it@isa-arbor.com
Lieutenant (LT)
Lieutenant (LT)
Posts: 54
Joined: Fri Aug 15, 2008 7:56 am

Cannot insert Null error during checkout process

Post by it@isa-arbor.com » Thu Feb 26, 2009 12:50 pm

I upgraded to 7.0.2 about two weeks ago and like the changes. I have been getting occasional logged errors since the upgrade, but can not reproduce the error myself.

There are eight occurances of the following error on different dates/times:

MESSAGE: An error occurred during the checkout process. The checkout has failed 3 times and will NOT BE attempted again. UserId: xxxxx/ xxxxx@someemail.net Customer: XXXXX XXXXXX/ xxxxx@someemail.net / (xxx) xxx-xxxx

DEBUG DATA: Cannot insert the value NULL into column 'TotalCharges', table 'myac7dbname.dbo.ac_Orders'; column does not allow nulls. UPDATE fails. The statement has been terminated.

I'm not quite sure what to make of this.

Any suggestions?

User avatar
mazhar
Master Yoda
Master Yoda
Posts: 5084
Joined: Wed Jul 09, 2008 8:21 am
Contact:

Re: Cannot insert Null error during checkout process

Post by mazhar » Fri Feb 27, 2009 6:50 am

Any idea about reproduction sequence?

it@isa-arbor.com
Lieutenant (LT)
Lieutenant (LT)
Posts: 54
Joined: Fri Aug 15, 2008 7:56 am

Re: Cannot insert Null error during checkout process

Post by it@isa-arbor.com » Fri Feb 27, 2009 7:42 am

Unfortunately no. I have not been able to reproduce it, but eight different customers have hit it on different dates and times. I have a hunch that there is a product screwed up in the database, perhaps something has a NULL value in a field that isn't expected to be NULL, but that's a guess.

If I can reproduce it, I will definately post the steps here.

Post Reply