[Bugzilla user: bacon4000@gmail.com]
[Bugzilla date: 2025-10-23T14:21:56+00:00]

Sébastien: What version of sqlite are you using on Debian/Ubuntu?  It appears that Debian Bullseye currently uses 3.34.1:

    https://packages.debian.org/bullseye/sqlite3

I approximately followed Frank's workaround, but used single quotes instead of a bare 6:

    INSERT INTO GlobalProperties VALUES (1, '6');

This also fixed the index file and allowed Orthanc to start successfully.  A bare 6 worked as well, though single quotes are probably correct, assuming we trust the error message.

According to https://sicp.pascal-lab.net/2024/labs/lab11/2_2.html, double quotes are no longer allowed for string literals starting with sqlite 3.41.  

FreeBSD ports upgraded to 3.41.2 in April 2023, and is on 3.50.2 now.

So I'm guessing this will break on Debian/Ubuntu as well, once they upgrade sqlite to 3.41 or later.

I'm a FreeBSD ports committer, so I can add a workaround patch to the port framework for now, but it looks like this should be fixed upstream.

Cheers,

    Jason