String or binary data would be truncated when Upgrading Umbraco
Hi I'm trying to upgrade Umbraco from 7.15.7 to 8.18.3 (as a experiment at this point) and I'm running into the "String or binary data would be truncated" error when doing so. I think I traced it to the cmsPropertyData table's dataNvarchar column being renamed to varcharValue and it's data type changed NVARCHAR(512). I base that on reading the log file.
Is it possible to keep the data type of NVARCHAR(max) on that column during the upgrade? I have about 100 entries in that column over 512 characters long.
Unfortunately I never found a solution. I did write a quick script to copy off the too long data into a new table then shorten it. This allowed the installation to continue. The script I used is:
select * into cmsPropertyData_bak from cmsPropertyData
where len(dataNvarchar) > 500
update cmsPropertyData
set dataNvarchar = LEFT(dataNvarchar, 500)
where len(dataNvarchar) > 500
String or binary data would be truncated when Upgrading Umbraco
Hi I'm trying to upgrade Umbraco from 7.15.7 to 8.18.3 (as a experiment at this point) and I'm running into the "String or binary data would be truncated" error when doing so. I think I traced it to the cmsPropertyData table's dataNvarchar column being renamed to varcharValue and it's data type changed NVARCHAR(512). I base that on reading the log file.
Is it possible to keep the data type of NVARCHAR(max) on that column during the upgrade? I have about 100 entries in that column over 512 characters long.
Any help is appreciated and thanks,
Drew
Did you find a solution ?
Unfortunately I never found a solution. I did write a quick script to copy off the too long data into a new table then shorten it. This allowed the installation to continue. The script I used is:
Hi, thanks.
I have the issue in 12.0.1 on a custom property field
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.