Database Errors

For general questions and discussions specific to the AbleCommerce 7.0 Asp.Net product.
Post Reply
cwswebdesign
Ensign (ENS)
Ensign (ENS)
Posts: 11
Joined: Fri Nov 11, 2011 6:10 pm

Database Errors

Post by cwswebdesign » Thu Jan 26, 2012 1:30 pm

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!

User avatar
jmestep
AbleCommerce Angel
Posts: 8164
Joined: Sun Feb 29, 2004 8:04 pm
Location: Dayton, OH
Contact:

Re: Database Errors

Post by jmestep » Fri Jan 27, 2012 7:31 am

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

cwswebdesign
Ensign (ENS)
Ensign (ENS)
Posts: 11
Joined: Fri Nov 11, 2011 6:10 pm

Re: Database Errors

Post by cwswebdesign » Fri Jan 27, 2012 10:20 pm

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!

User avatar
efficiondave
Commander (CMDR)
Commander (CMDR)
Posts: 151
Joined: Tue Dec 02, 2008 10:20 am
Location: St. Louis Missouri
Contact:

Re: Database Errors

Post by efficiondave » Wed Apr 17, 2013 2:41 pm

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?

Post Reply