Web Tools COD-Based Order Throws Exception

[Former Member]

After trying to place an online order via COD, I received this error:

Version	2007.0.625.0
Message	Cannot insert the value NULL into column 'AccountExpiration', table 'B1WebTools_625.dbo.UsersWallet'; column does not allow nulls. INSERT fails. The statement has been terminated.
Source	.Net SqlClient Data Provider
Stack	at netpoint.api.data.DataFunctions.ExecuteScalar(String SQL, IDataParameter[] parameters, String connectionstring) 
at netpoint.api.account.NPWallet.Save() 
at ThirdMind.commerce.controls.PaymentBlock.AddPayment() 
at ThirdMind.commerce.controls.PaymentBlock.SubmitPayment() 
at ThirdMind.commerce.billing.a(Object A_0, ImageClickEventArgs A_1) 
at System.Web.UI.WebControls.ImageButton.OnClick(ImageClickEventArgs e) 
at System.Web.UI.WebControls.ImageButton.RaisePostBackEvent(String eventArgument) 
at System.Web.UI.WebControls.ImageButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) 
at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) 
at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) 
at System.Web.UI.Page.ProcessRequestMain

Is it possible that the UsersWallet table structure needs to be updated to allow the AccountExpiration field to have NULLs, or is it simply a bug? In either case, is this fixed in a later version?

[Former Member · Accepted solution]

Hi Micheal,

This is a known issue with 625.

The bug has been fixed, but it would require and upgrade.