R10 certain payments have PaymentMethodName null

For general questions and discussions specific to the AbleCommerce GOLD ASP.Net shopping cart software.
Post Reply
User avatar
AbleMods
Master Yoda
Master Yoda
Posts: 5170
Joined: Wed Sep 26, 2007 5:47 am
Location: Fort Myers, Florida USA

R10 certain payments have PaymentMethodName null

Post by AbleMods » Tue Dec 08, 2015 2:21 am

I noticed an unusual data issue this morning with one of our large clients.

Many of the store payment profiles records in ac_GatewayPaymentProfiles have a PaymentMethodName value that is null. I believe this is causing the PaymentMethodName on the ac_Payments record to be null as well.

This seems like a bug to me. If a stored profile was used to create the payment, there should be no reason for PaymentMethodName to be null. Unless maybe the field itself was added in a later release, and payment profiles created prior to that did not have a value.

But it's not all of them. Seems like it's about 50/50 - some have it populated, and some do not.

So looking at ac_Payments, about half of the payments have PaymentMethodName = null. So there's no way to tell if the payment was a Visa, MC, Discover etc.

Any thoughts?
Joe Payne
AbleCommerce Custom Programming and Modules http://www.AbleMods.com/
AbleCommerce Hosting http://www.AbleModsHosting.com/
Precise Fishing and Hunting Time Tables http://www.Solunar.com

User avatar
mazhar
Master Yoda
Master Yoda
Posts: 5084
Joined: Wed Jul 09, 2008 8:21 am
Contact:

Re: R10 certain payments have PaymentMethodName null

Post by mazhar » Tue Dec 08, 2015 5:29 am

This field was added later that's why some profiles created before that version are missing the method name.

User avatar
AbleMods
Master Yoda
Master Yoda
Posts: 5170
Joined: Wed Sep 26, 2007 5:47 am
Location: Fort Myers, Florida USA

Re: R10 certain payments have PaymentMethodName null

Post by AbleMods » Tue Dec 08, 2015 6:01 am

Ok thanks, that makes sense
Joe Payne
AbleCommerce Custom Programming and Modules http://www.AbleMods.com/
AbleCommerce Hosting http://www.AbleModsHosting.com/
Precise Fishing and Hunting Time Tables http://www.Solunar.com

User avatar
Katie
AbleCommerce Admin
AbleCommerce Admin
Posts: 2651
Joined: Tue Dec 02, 2003 1:54 am
Contact:

Re: R10 certain payments have PaymentMethodName null

Post by Katie » Tue Dec 08, 2015 10:26 am

Hi Joe,

I wanted to make sure that you've seen this patch we recently released -

http://help.ablecommerce.com/index.htm# ... h_2015.htm

It fixes an issue with the Authorize.net CIM payment gateway.

Thanks
Katie
Thank you for choosing AbleCommerce!

http://help.ablecommerce.com - product support
http://wiki.ablecommerce.com - developer support

User avatar
AbleMods
Master Yoda
Master Yoda
Posts: 5170
Joined: Wed Sep 26, 2007 5:47 am
Location: Fort Myers, Florida USA

Re: R10 certain payments have PaymentMethodName null

Post by AbleMods » Tue Dec 08, 2015 10:32 am

Yes thank you. Its already installed.
Joe Payne
AbleCommerce Custom Programming and Modules http://www.AbleMods.com/
AbleCommerce Hosting http://www.AbleModsHosting.com/
Precise Fishing and Hunting Time Tables http://www.Solunar.com

Post Reply