String or binary data would be truncated.

rasmusjp / umbraco-multi-url-picker

Multi Url Picker for Umbraco 7

MIT License

31 stars 29 forks source link

String or binary data would be truncated. #3

Closed abriggs-eduserv closed 10 years ago

abriggs-eduserv commented 10 years ago

Hi,

I hit this error when adding more than 9 links to a picker.

I think the json property data is being saved in the dataNvarchar column which has a max length of 500 chars. The RTE for example saves its content in the dataNtext column of cmsPropertyData which is unbounded.

I'll have a poke about and see how to save the data in the other column from angular

abriggs-eduserv commented 10 years ago

This is due to the "Database datatype" which used to be a setting you could change in Umbraco4/6 but has been removed from U7.

If you're affected by this issue in U7, executing the following sql will set the storage to NText UPDATE cmsDataType SET dbType = 'Ntext' WHERE propertyEditorAlias = 'RJP.MultiUrlPicker'

Not sure what the long term fix is

rasmusjp commented 10 years ago

I've pushed an update which should fix the problem permanently.

Please update the package (both NuGet and our should have the updated package now) and see if it fixes it.

You might need to recycle the app pool and save the data type again after installation.