[Bugzilla user: frank@altpeter.de]
[Bugzilla date: 2024-06-26T15:42:31+00:00]

Hi,

I did read the support.html page, I did search for my problem on the discourse forum and on Google, but I wasn't able to find any information about it. I also read the FAQ, especially the 'Troubleshooting' section.

**What steps will reproduce the problem?**
Install Orthanc 1.12.3 from FreeBSD ports and start it.

**What is the expected output? What do you see instead?**
I expect that the orthanc server is initializing the sqlite database and start - or do something other than just exiting with the following error:

[Called orthanc --trace and pasting the relevant parts from it]

I0626 17:35:37.790530             MAIN SQLiteDatabaseWrapper.cpp:1389] Creating the database
T0626 17:35:37.790571             MAIN Connection.cpp:159] (sqlite) SQLite::Connection::Execute -- Orthanc - A Lightweight, RESTful DICOM Store

[...]

-- Set the version of the database schema
-- The "1" corresponds to the "GlobalProperty_DatabaseSchemaVersion" enumeration
INSERT INTO GlobalProperties VALUES (1, "6");

E0626 17:35:37.796042             MAIN Connection.cpp:168] SQLite execute error: no such column: "6" - should this be a string literal in single-quotes? (1)
E0626 17:35:37.800207             MAIN main.cpp:2106] Uncaught exception, stopping now: [SQLite: Cannot execute a command] (code 1004)
W0626 17:35:37.800297             MAIN main.cpp:2137] Orthanc has stopped

After this first run, the sqlite database is incomplete, which results in an "Incompatible version of the database: Incompatible version of the Orthanc database: Unknown" error in subsequent invocations until removing the index file again. Then the above error reoccurs while trying to populate the database.

**What version of the product are you using? On what operating system?**

root@murphy:~ 0# freebsd-version                  
14.1-RELEASE-p1
root@murphy:~ 0# /usr/local/sbin/Orthanc --version
/usr/local/sbin/Orthanc 1.12.3
root@murphy:~ 1# sqlite3 -version
3.46.0 2024-05-23 13:25:27 96c92aba00c8375bc32fafcdf12429c58bd8aabfcadab6683e35bbb9cdebalt1 (64-bit)
root@murphy:.../etc/orthanc 0# file OrthancStorage/index 
OrthancStorage/index: SQLite 3.x database, last written using SQLite version 3046000, writer version 2, read version 2, file counter 2, database pages 30, cookie 0x19, schema 4, UTF-8, version-valid-for 2



**Please provide sample, possibly anonymized, DICOM files**
Not applicible, because I never got to get the server started yet.