Not installing correctly on Umbraco 13.4.0

[jrunestone]

Hi!

We can't get the package to install correctly on Umbraco 13.4.0. The nuget installs just fine, but the migration fails with the below stack trace. We also get a 404 when visiting /umbraco#/settings/preflight/overview for /App_Plugins/Preflight/backoffice/preflight/overview.html. We are able to install other packages. Seems like a db data type mismatch for some setting.

There are no files installed in the App_Plugins folder but I'm assuming they're embedded in the assembly/nuget instead. Not sure which error is prohibiting us from getting any content in the backoffice.

2024-08-28T12:37:14.483246898+02:00 [12:37:14 DBG] Final package migration for UmbracoForms state is 773ae769-00b7-4429-b7d5-de0fda0b4217, database contains 773ae769-00b7-4429-b7d5-de0fda0b4217
2024-08-28T12:37:14.483673961+02:00 [12:37:14 INF] Starting unattended package migration for Preflight [Timing a282fbf]
2024-08-28T12:37:14.484410355+02:00 [12:37:14 INF] Starting 'Preflight'...
2024-08-28T12:37:14.484417705+02:00 [12:37:14 INF] At Preflight_ZeroZeroZero
2024-08-28T12:37:14.484441085+02:00 [12:37:14 INF] Execute Preflight_TwoZeroZero
2024-08-28T12:37:14.484911488+02:00 [12:37:14 DBG] Creating Preflight settings table
2024-08-28T12:37:14.487942656+02:00 [12:37:14 INF] Create table:
2024-08-28T12:37:14.487942656+02:00  CREATE TABLE [PreflightSettings] ([Id] INTEGER NOT NULL IDENTITY(1,1),
2024-08-28T12:37:14.487942656+02:00 [Value] NVARCHAR(255) NOT NULL,
2024-08-28T12:37:14.487942656+02:00 [Setting] UniqueIdentifier NOT NULL)
2024-08-28T12:37:14.489113672+02:00 [12:37:14 INF] Create Primary Key:
2024-08-28T12:37:14.489113672+02:00  ALTER TABLE [PreflightSettings] ADD CONSTRAINT [PK_PreflightSettings] PRIMARY KEY CLUSTERED ([Id])
2024-08-28T12:37:14.491188804+02:00 [12:37:14 DBG] Populate from existing settings.json
2024-08-28T12:37:14.497123939+02:00 [12:37:14 ERR] Exception (b71b5d4a).
2024-08-28T12:37:14.497123939+02:00 System.InvalidOperationException: The given value '{"sv-SE":"Umbraco.Grid,Umbraco.TinyMCE,Umbraco.TextArea,Umbraco.TextBox,Umbraco.NestedContent,Umbrac' of type String from the data source cannot be converted to type nvarchar for Column 1 [Value] Row 3.
2024-08-28T12:37:14.497123939+02:00  ---> System.InvalidOperationException: String or binary data would be truncated in table '[PreflightSettings]', column 'Value'. Truncated value: '{"sv-SE":"Umbraco.Grid,Umbraco.TinyMCE,Umbraco.TextArea,Umbraco.TextBox,Umbraco.NestedContent,Umbrac'.
2024-08-28T12:37:14.497123939+02:00    at Microsoft.Data.SqlClient.SqlBulkCopy.ConvertValue(Object value, _SqlMetaData metadata, Boolean isNull, Boolean& isSqlType, Boolean& coercedToDataFeed)
2024-08-28T12:37:14.497123939+02:00    --- End of inner exception stack trace ---
...
...
...
...
2024-08-28T12:37:14.506355872+02:00    at Microsoft.AspNetCore.Server.Kestrel.Core.Internal.Http2.Http2Stream`1.Execute()
2024-08-28T12:37:14.506355872+02:00    at System.Threading.ThreadPoolWorkQueue.Dispatch()
2024-08-28T12:37:14.506355872+02:00    at System.Threading.PortableThreadPool.WorkerThread.WorkerThreadStart()
2024-08-28T12:37:14.506355872+02:00 [12:37:14 DBG] Sql:
2024-08-28T12:37:14.506355872+02:00 ALTER TABLE [PreflightSettings] ADD CONSTRAINT [PK_PreflightSettings] PRIMARY KEY CLUSTERED ([Id])
2024-08-28T12:37:14.506355872+02:00 
2024-08-28T12:37:14.507522589+02:00 [12:37:14 ERR] Plan failed at step Preflight_TwoZeroZero
2024-08-28T12:37:14.507584719+02:00 [12:37:14 INF] Unattended upgrade completed for Preflight (23ms) [Timing a282fbf]```