We are facing an SQL error with saving property values in Umbraco v7.15.6.
We checked with the database, the values try to save in dbo.cmsPropertyData under dataNvarchar property. the property set as nvarchar(500) , that's the issue, once the input valued limit exceeds 500 it will throw the error.
We can directly update the field datatype in SQL direct query, but we are not preferred that, is there any other ways to handle this, or
Is this issue fixed in some other Upgraded Umbraco versions, If so we need the upgraded Umbraco version name details?
[API] Exception was thrown in class 'SqlConnection' while invoking method 'OnError', with the message: 'String or binary data would be truncated.
The statement has been terminated.'.
System.Data.SqlClient.SqlException (0x80131904): String or binary data would be truncated.
The statement has been terminated.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
String or binary data would be truncated
Hi Team,
We are facing an SQL error with saving property values in Umbraco v7.15.6.
We checked with the database, the values try to save in dbo.cmsPropertyData under dataNvarchar property. the property set as nvarchar(500) , that's the issue, once the input valued limit exceeds 500 it will throw the error.
We can directly update the field datatype in SQL direct query, but we are not preferred that, is there any other ways to handle this, or
Is this issue fixed in some other Upgraded Umbraco versions, If so we need the upgraded Umbraco version name details?
is working on a reply...
This forum is in read-only mode while we transition to the new forum.
You can continue this topic on the new forum by tapping the "Continue discussion" link below.