HomeHome Product Discus... Product Discus...SmithCartSmithCartv4.71 upgrade - Canv4.71 upgrade - Can't save new Payment settings
Previous
 
Next
New Post
11/14/2011 10:08 AM
 
Mike Katulka
No Ranking

Joined: 9/21/2011
Posts: 40

DNN 5.6.3

MSSQL 2008 on PowerDNN

I filled out the new Payment Setup screen, in this order:

1. Payment Gateways - Manual, no other changes - Saved successfully

2. Zones - US & Canada - Saved successfully

3. Payment Methods - Purchase Order   < Clicking Submit on this screen bring up this error:  
A critical error has occurred.
Cannot insert the value NULL into column 'CheckoutOK', table 'smcindustries.dbo.Smith_PaymentMethods'; column does not allow nulls. INSERT fails. The statement has been terminated.
 
New Post
11/15/2011 2:28 AM
 
Dave Smith
1st Level Poster

Joined: 7/28/2009
Posts: 1452
Hi Mike,
I will email you cart v4.72 which fixes this error when adding payment methods in the new payment setup screen.

At your service,
Dave Smith
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
New Post
11/15/2011 10:59 AM
 
Mike Katulka
No Ranking

Joined: 9/21/2011
Posts: 40

Ok, I'll wait for that then.  Thanks,
 
New Post
11/16/2011 3:08 PM
 
No Ranking

Joined: 1/1/0001
Posts: 0
Hi Mike,

we have email you v.4.72 to resolve this issue, you may also need to delete the field 'CheckoutOK' in table 'DNNProd.dbo.Smith_PaymentMethods'

Thanks,
 
New Post
11/18/2011 12:00 PM
Accepted Answer 
Mike Katulka
No Ranking

Joined: 9/21/2011
Posts: 40

I installed 4.74 and was able to save the payment options after deleting the CheckoutOK column through SQL.

Thanks,
 
New Post
11/21/2011 6:56 PM
 
No Ranking

Joined: 1/1/0001
Posts: 0
Hi Mike,

Glad we could help.

Thanks,
 
 Page 1 of 1
Previous
 
Next
HomeHome Product Discus... Product Discus...SmithCartSmithCartv4.71 upgrade - Canv4.71 upgrade - Can't save new Payment settings




Questions? Contact us for answers!

Contact Us!