aboutsummaryrefslogtreecommitdiffstats
path: root/science/orthanc/files/patch-OrthancServer_Sources_Database_PrepareDatabase.sql
diff options
context:
space:
mode:
authorLexi Winter <ivy@FreeBSD.org>2025-12-01 03:19:41 +0000
committerLexi Winter <ivy@FreeBSD.org>2025-12-01 03:19:41 +0000
commit2e80774d0b20d167bc0a9e2b63dafbfb171c0d22 (patch)
tree25f0138e1af8902b92dacc8cce09b267447c17db /science/orthanc/files/patch-OrthancServer_Sources_Database_PrepareDatabase.sql
parentf85f2b2d6e5b7ed869376eb4b180c3a74a5c5da9 (diff)
parent1a30da80670973368b399f2b01fe9c04b91a1273 (diff)
Merge remote-tracking branch 'freebsd/main' into lf/mainlf/main
Diffstat (limited to 'science/orthanc/files/patch-OrthancServer_Sources_Database_PrepareDatabase.sql')
-rw-r--r--science/orthanc/files/patch-OrthancServer_Sources_Database_PrepareDatabase.sql13
1 files changed, 13 insertions, 0 deletions
diff --git a/science/orthanc/files/patch-OrthancServer_Sources_Database_PrepareDatabase.sql b/science/orthanc/files/patch-OrthancServer_Sources_Database_PrepareDatabase.sql
new file mode 100644
index 000000000000..ffe19920c2b0
--- /dev/null
+++ b/science/orthanc/files/patch-OrthancServer_Sources_Database_PrepareDatabase.sql
@@ -0,0 +1,13 @@
+--- OrthancServer/Sources/Database/PrepareDatabase.sql.orig 2025-08-11 16:02:50 UTC
++++ OrthancServer/Sources/Database/PrepareDatabase.sql
+@@ -160,4 +160,9 @@ -- The "1" corresponds to the "GlobalProperty_Database
+
+ -- Set the version of the database schema
+ -- The "1" corresponds to the "GlobalProperty_DatabaseSchemaVersion" enumeration
+-INSERT INTO GlobalProperties VALUES (1, "6");
++-- Upstream code has (1, "6"), which causes startup to fail on FreeBSD
++-- E1023 08:43:05.328003 MAIN Connection.cpp:169] SQLite execute error: no such column: "6" - should this be a string literal in single-quotes? (1)
++-- Apparently due to sqlite 3.41+ being stricter about string literals
++-- Debian packages currently uses 3.34
++-- https://orthanc.uclouvain.be/bugs/show_bug.cgi?id=227
++INSERT INTO GlobalProperties VALUES (1, 6);