Sign in Register
Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Drew Mayo 27 posts 128 karma points
    May 11, 2022 @ 19:56
    Drew Mayo
    0

    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

    Copy Link
  • Thomas 319 posts 606 karma points c-trib
    Jul 17, 2023 @ 12:08
    Thomas
    0

    Did you find a solution ?

    Copy Link
  • Drew Mayo 27 posts 128 karma points
    Jul 25, 2023 @ 02:20
    Drew Mayo
    1

    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
    Copy Link
  • Thomas 319 posts 606 karma points c-trib
    Jul 25, 2023 @ 06:43
    Thomas
    0

    Hi, thanks.

    I have the issue in 12.0.1 on a custom property field

    Copy Link
Please Sign in or register to post replies

Write your reply to:

Draft