Design flaw on database column length and UI

This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.
13 anni tempo fa
Hello,

I've noticed a problem when someone put an order through our store and I couldn't open it due to an exception when decrypting Order.CardName field.

I haven't investigated it yet but looks like one of our customers filled out a very long "Name on card" when he provided his credit card info. This lead to a encrypted string with length more than 100 characters so it got truncated when inserted in the database which column is nvarchar(100).

I'm gonna correct it in my project by both modifying the Nop_Order table to a larger length (possibly 512) and by putting a Length validator in the Templates\Payment\Manual\PaymentModule.ascx module. I just have to analyze how bigger the encrypted string gets.

I thought it would be nice to notify the development team.

Thanks,
John
13 anni tempo fa
Thanks for info
This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.