https://discord.umbraco.com logo
#help-with-umbraco
uSync CheckBoxList failing to import
# help-with-umbraco
c

craig100

01/29/2024, 10:32 PM
Umb V13.0.1, uSync V13.0.1 + FormsEdition V13.0.0.0 All content imports except long checkbox lists. Error:- String or binary data would be truncated in table '6744_Umbraco_SE13.6744_myId.umbracoPropertyData', column 'varcharValue'. Truncated value: '[ "Bath", "BBQ Grill", "BBQ Utensils", "Bed linen", "Carbon monoxide alarm", "Cleaning p'. The statement has been terminated. Looking in the table umbracoDataType, the Umbracl.CheckBoxList datatype is "Nvarchar", whereas uSync appears to be looking for "varchar" unless I'm mistaken of course. To get the site live I'm going to have to let it run on a SQLite DB for now. Please advise.
k

kevinjump

01/29/2024, 11:24 PM
Hi, yeah uSync doesn't care (it doesn't do any direct db stuff, it only puts in things via the api). I think this is the issue you have found here https://github.com/umbraco/Umbraco-CMS/issues/12284 the workaround as i remember it , is to go in and change the column type in the DB . (but don't take my word for it, I am sure that is written down somewhere)
It works on SQLIte because that doesn't have the concept of VARCHAR(size) all the text columns are TEXT so 'unlimited'
c

craig100

01/30/2024, 10:02 AM
Thanks for reminding me, lol. I too seem to remember it was written down somewhere what to set it too. I did try changing from Nvarchar to Nvarchar(max) but it blew up. I guess I got the syntax wrong 😦
Anyone any idea what I could safely change the checkbox datatype to in the DB?