Hi,
Using v7.0.0, I've been receiving the following error messages:
Unhandled exception during checkout. Cannot insert the value NULL into column 'TotalCharges', table 'skisf0_ecommerce2011.dbo.ac_Orders'; column does not allow nulls. UPDATE fails. The statement has been terminated.
Error sending email with subject 'Packing Slip - Shipment Notification for SkisFast.com'. Mailbox unavailable. The server response was: "Your IP: 216.227.221.17 : Your domain abc.com is not allowed in header
Could not restock 1 of variant 3212,0,0,0,0,0,0,0 for Product 1251
Has anyone seen similar errors or know how I can fix them? Thank you!
Database Errors
- jmestep
- AbleCommerce Angel
- Posts: 8164
- Joined: Sun Feb 29, 2004 8:04 pm
- Location: Dayton, OH
- Contact:
Re: Database Errors
The first one- the null error usually happens when a customer has checked out and then uses his browser back button.
Judy Estep
Web Developer
jestep@web2market.com
http://www.web2market.com
708-653-3100 x209
New search report plugin for business intelligence:
http://www.web2market.com/Search-Report ... -P154.aspx
Web Developer
jestep@web2market.com
http://www.web2market.com
708-653-3100 x209
New search report plugin for business intelligence:
http://www.web2market.com/Search-Report ... -P154.aspx
-
- Ensign (ENS)
- Posts: 11
- Joined: Fri Nov 11, 2011 6:10 pm
Re: Database Errors
jmestep wrote:The first one- the null error usually happens when a customer has checked out and then uses his browser back button.
That makes me feel a bit better...... thanks for that input!
- efficiondave
- Commander (CMDR)
- Posts: 151
- Joined: Tue Dec 02, 2008 10:20 am
- Location: St. Louis Missouri
- Contact:
Re: Database Errors
In reviewing my app.log file, I'm seeing hundreds of these errors but it appears they are linked to only a few instances as I see a grouping of 100 of them that occur within a second or two and then followed by: An error occurred during the checkout process. The checkout has failed 100 times and will NOT BE attempted again. UserId: 192869...
Is that also related to hitting the back button or perhaps refreshing the OrderReceipt page?
Anything I can do to prevent this error?
Is that also related to hitting the back button or perhaps refreshing the OrderReceipt page?
Anything I can do to prevent this error?
David O'Leary
http://www.EfficionConsulting.com
http://www.EfficionConsulting.com