I was getting the same error and was able to fix it downgrading SQLite to 1.0.113. It seems that this error was introduced in Sqlite version 1.0.115. See here:

https://sqlite.org/forum/info/f80d7580fc07ce5c

I was using .net 8 and sqlite 1.0.119. On the development computer it was working just fine but when deployed on an container (windows nano server ltsc 2019) I got that error.

So I downgraded the SQLite package version on my Visual Studio project to 1.0.113.0. But note that it is not available directly in the nuget package repository. You have to download it from the Sqlite website:

https://system.data.sqlite.org/blobs/1.0.113.0/Stub.System.Data.SQLite.Core.NetStandard.1.0.113.0.nupkg

And then, under Visual Studio add a folder where this file is located (anywhere, in my case the project folder) as a local package repository (right-click on the project -> Manage NuGet Packages -> click on the wheel at the top right -> Package sources -> click on "+" -> set the path below. done