Setting table's value column length is too small

This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.
4 years ago
NopCommerce verison 4.0 and 4.1

The length of the Setting table's value column is limited to 2000 characters, data type is nvarchar(2000).
In most cases, 2000 chars is fine, but there are cases where it is not enough.

We have an eBay plugin, and we store the token for eBay's REST API's as a setting.
This works great, since it is frequently updated, and easily accessible.
This has been working fine for a while, but now eBay increased the length of their token to be greater than 2000.
We started getting these errors:
Property: Value Error: The field Value must be a string or array type with a maximum length of '2000'.
Upon further investigation, we discovered that we were trying to store a 2005 character string (the eBay token) in a 2000 char value column of the setting table.

Can the NopCommerce team please increase this field to nvarchar(max) for the next 4.2 release?
This should be a very quick and easy change.  Would solve allot of problems and make this table much mover versatile.  If the ZipPostalCode column of the address table can be nvarchar(max), then certainly why not the value column of the a setting table?
4 years ago
Thanks for suggestion. But actually already done
This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.