# HG changeset patch # User Sebastien Jodogne # Date 1762269892 -3600 # Node ID d7b003958d8992e239e1c2ef010af766c98e364b # Parent 2278b9d5fb86bbf7fdf1829cdcc9cabab4c864a9 fix issue #227 diff -r 2278b9d5fb86 -r d7b003958d89 NEWS --- a/NEWS Tue Nov 04 16:20:19 2025 +0100 +++ b/NEWS Tue Nov 04 16:24:52 2025 +0100 @@ -42,6 +42,8 @@ https://discourse.orthanc-server.org/t/cannot-preview-dicom-file/6275 * Fix: Possible deadlocks when using ZipLoaderThreads > 1 when the HttpClient disconnects while downloading the response. +* Fix issue #227: In SQL, string literals must use 'single quotes' + https://stackoverflow.com/a/25141338 * Upgraded dependencies for static builds: - civetweb 1.16, including patch for CVE-2025-55763 - SQLite 3.50.4 diff -r 2278b9d5fb86 -r d7b003958d89 OrthancServer/Sources/Database/PrepareDatabase.sql --- a/OrthancServer/Sources/Database/PrepareDatabase.sql Tue Nov 04 16:20:19 2025 +0100 +++ b/OrthancServer/Sources/Database/PrepareDatabase.sql Tue Nov 04 16:24:52 2025 +0100 @@ -160,4 +160,4 @@ -- Set the version of the database schema -- The "1" corresponds to the "GlobalProperty_DatabaseSchemaVersion" enumeration -INSERT INTO GlobalProperties VALUES (1, "6"); +INSERT INTO GlobalProperties VALUES (1, 6);