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?
Cannot insert Null error during checkout process
-
- Lieutenant (LT)
- Posts: 54
- Joined: Fri Aug 15, 2008 7:56 am
Re: Cannot insert Null error during checkout process
Any idea about reproduction sequence?
-
- Lieutenant (LT)
- Posts: 54
- Joined: Fri Aug 15, 2008 7:56 am
Re: Cannot insert Null error during checkout process
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.
If I can reproduce it, I will definately post the steps here.