From nobody Fri Apr 12 08:37:42 2024 X-Original-To: dev-commits-ports-all@mlmmj.nyi.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2610:1c1:1:606c::19:1]) by mlmmj.nyi.freebsd.org (Postfix) with ESMTP id 4VG91L5dZQz5GyVb; Fri, 12 Apr 2024 08:37:42 +0000 (UTC) (envelope-from git@FreeBSD.org) Received: from mxrelay.nyi.freebsd.org (mxrelay.nyi.freebsd.org [IPv6:2610:1c1:1:606c::19:3]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest SHA256 client-signature RSA-PSS (4096 bits) client-digest SHA256) (Client CN "mxrelay.nyi.freebsd.org", Issuer "R3" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id 4VG91L3W90z45mr; Fri, 12 Apr 2024 08:37:42 +0000 (UTC) (envelope-from git@FreeBSD.org) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=freebsd.org; s=dkim; t=1712911062; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding; bh=0nwFYvQzHMW5JVXZccw+2aUAJizG0rPNygFyEmiR2cA=; b=OLlUV7eR8YYVnmxiFL3df0oN3PyTs/0dnVswLJL4T1bQpkRW9U3D4YUfixnBseIGNVfNlm vcSRY1bkm0tAiQMXOWqqo/iU0GIaG46JlfP403TlVdQtYvDNdh2cJ/TpJB2hd+qaxcmVjh Cx7Ua9k3hd3ko4u5t7d/kh6kf5tVVVeKXJ4OhcXqSt1rJd/5xc4RNWZnGRo7IQ04u5ny6D C7bFZSuw2JfSbHB3T9wf9lmdpS0EjJxPyGYK9a9P+pZqpkn8ESiMMx6tRWpBdUG0pQFb0z 58mRF/bWuo5E7Q1xqySMcwfl1ogTVW8/cFuzdQRyAM2j5KLL5M4iJ6EZ+GF77w== ARC-Seal: i=1; s=dkim; d=freebsd.org; t=1712911062; a=rsa-sha256; cv=none; b=uu3w9bhJ41XtsuHy9g2Xo1Ryojg+sO8Fw8s2HsJZFLQJL6Equq5yn4jknOiP136/9tV/2x d+GkETE7QbaZF4rwgwdKXvBgNEh/zWiR1phy6WgIUEYFd9wdZzYrzb1o3CXcD2Yvei6U9D p13Yt4QvTrKVxLhsjZXKwnpSHptfUdQkSnpRyOsAglCCNzD3JEQGWQ+SngiGF0p5/YnA69 fGoN7esjere6rdi0ODxO3Yp3J2O0kZbr5jTpdXQwE4PxXSLj+jpbt8ljPDd4IAbq7slKTW k+mCnum+IA4UVqLIABxIn8ImZ6cqdjCZP/DDS9KlCF2UygRe/FkqUU6BE8sYOg== ARC-Authentication-Results: i=1; mx1.freebsd.org; none ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=freebsd.org; s=dkim; t=1712911062; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding; bh=0nwFYvQzHMW5JVXZccw+2aUAJizG0rPNygFyEmiR2cA=; b=j635pXI9IAKJCbmGW7VcA2XE3elHh00fxisxqlAVuovLX+CLIKinfGWvbpNdv8j1BZ3xEs VTyiwgsKPAwNXjVvqpuypur7/hsPQqnuTWaEkMo5tkXxxjkrY6VR1Nzmgzbc4DKnzCSgf9 SWDsW1g4FSrZq25ZbDMDjrJNUs6VyBuSfD/KZH2r0uviYIGKP7kmzzDO/uviFt2sgbT31I LC8iM2LKyIQOlrDJlZY2BBvEJQm8TZhRjBageVWwxWZVif9kxWnZepia4JK35x4vGZ9O1f KOLEKc0/Y6OdgNsaQ1thxmYQr1aaUlNb08/1kATInLwa4m79NlLUxG3LRAzUew== Received: from gitrepo.freebsd.org (gitrepo.freebsd.org [IPv6:2610:1c1:1:6068::e6a:5]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest SHA256) (Client did not present a certificate) by mxrelay.nyi.freebsd.org (Postfix) with ESMTPS id 4VG91L37SfzhqH; Fri, 12 Apr 2024 08:37:42 +0000 (UTC) (envelope-from git@FreeBSD.org) Received: from gitrepo.freebsd.org ([127.0.1.44]) by gitrepo.freebsd.org (8.17.1/8.17.1) with ESMTP id 43C8bgoY094871; Fri, 12 Apr 2024 08:37:42 GMT (envelope-from git@gitrepo.freebsd.org) Received: (from git@localhost) by gitrepo.freebsd.org (8.17.1/8.17.1/Submit) id 43C8bgDt094868; Fri, 12 Apr 2024 08:37:42 GMT (envelope-from git) Date: Fri, 12 Apr 2024 08:37:42 GMT Message-Id: <202404120837.43C8bgDt094868@gitrepo.freebsd.org> To: ports-committers@FreeBSD.org, dev-commits-ports-all@FreeBSD.org, dev-commits-ports-main@FreeBSD.org From: Robert Clausecker Subject: git: 50154e657e63 - main - databases/evolution-data-server: make usable when sqlite3 has option DQS disabled List-Id: Commit messages for all branches of the ports repository List-Archive: https://lists.freebsd.org/archives/dev-commits-ports-all List-Help: List-Post: List-Subscribe: List-Unsubscribe: X-BeenThere: dev-commits-ports-all@freebsd.org MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit X-Git-Committer: fuz X-Git-Repository: ports X-Git-Refname: refs/heads/main X-Git-Reftype: branch X-Git-Commit: 50154e657e63e12df3938dcd7dc15b7e340f5a6f Auto-Submitted: auto-generated The branch main has been updated by fuz: URL: https://cgit.FreeBSD.org/ports/commit/?id=50154e657e63e12df3938dcd7dc15b7e340f5a6f commit 50154e657e63e12df3938dcd7dc15b7e340f5a6f Author: Robert Clausecker AuthorDate: 2024-04-08 09:52:26 +0000 Commit: Robert Clausecker CommitDate: 2024-04-12 08:36:56 +0000 databases/evolution-data-server: make usable when sqlite3 has option DQS disabled This port uses "%s" in some SQL queries where '%s' should have been used. When the DQS (double-quoted string) misfeatures of SQLite3 is disabled, these queries fail and cause the error "no such column: %s". Change these queries to fix evolution. PR: 278249 Approved by: fluffy (gnome) MFH: 2024Q2 --- databases/evolution-data-server/Makefile | 2 +- .../files/patch-src_camel_camel-db.c | 36 ++++++++++++++++++++++ 2 files changed, 37 insertions(+), 1 deletion(-) diff --git a/databases/evolution-data-server/Makefile b/databases/evolution-data-server/Makefile index e1208fc20932..e56f1c5cd37e 100644 --- a/databases/evolution-data-server/Makefile +++ b/databases/evolution-data-server/Makefile @@ -1,6 +1,6 @@ PORTNAME= evolution-data-server DISTVERSION= 3.44.4 -PORTREVISION= 6 +PORTREVISION= 7 CATEGORIES= databases gnome MASTER_SITES= GNOME DIST_SUBDIR= gnome diff --git a/databases/evolution-data-server/files/patch-src_camel_camel-db.c b/databases/evolution-data-server/files/patch-src_camel_camel-db.c new file mode 100644 index 000000000000..2ff44c2cb5e8 --- /dev/null +++ b/databases/evolution-data-server/files/patch-src_camel_camel-db.c @@ -0,0 +1,36 @@ +Allow evolution to be used when databases/sqlite3 has been compiled +with option DQS disabled. + +--- src/camel/camel-db.c.orig 2024-04-08 09:37:09 UTC ++++ src/camel/camel-db.c +@@ -1823,8 +1823,8 @@ camel_db_migrate_folder_prepare (CamelDB *cdb, + "mail_to , mail_cc , mlist , followup_flag , " + "followup_completed_on , followup_due_by , " + "part , labels , usertags , cinfo , bdata , '', '', " +- "strftime(\"%%s\", 'now'), " +- "strftime(\"%%s\", 'now') FROM %Q", ++ "strftime('%%s', 'now'), " ++ "strftime('%%s', 'now') FROM %Q", + folder_name, folder_name); + ret = camel_db_add_to_transaction (cdb, table_creation_query, error); + sqlite3_free (table_creation_query); +@@ -2093,8 +2093,8 @@ camel_db_write_message_info_record (CamelDB *cdb, + "%Q, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, " + "%lld, %lld, %Q, %Q, %Q, %Q, %Q, %Q, %Q, %Q, " + "%Q, %Q, %Q, %Q, %Q, %Q, %Q, " +- "strftime(\"%%s\", 'now'), " +- "strftime(\"%%s\", 'now') )", ++ "strftime('%%s', 'now'), " ++ "strftime('%%s', 'now') )", + folder_name, + record->uid, + record->flags, +@@ -2578,7 +2578,7 @@ camel_db_rename_folder (CamelDB *cdb, + ret = camel_db_add_to_transaction (cdb, cmd, error); + sqlite3_free (cmd); + +- cmd = sqlite3_mprintf ("UPDATE %Q SET modified=strftime(\"%%s\", 'now'), created=strftime(\"%%s\", 'now')", new_folder_name); ++ cmd = sqlite3_mprintf ("UPDATE %Q SET modified=strftime('%%s', 'now'), created=strftime('%%s', 'now')", new_folder_name); + ret = camel_db_add_to_transaction (cdb, cmd, error); + sqlite3_free (cmd); +